RESOLVED:how to make script of mysql database using phpmyadmin?

Hi all could any one tell me how i can make a backup of my mysql database using phpmyadmin? i want to use it as backup and also want to transfer a copy of my database tables and data to diffrent mechine .Thanks

Quote:

---

Originally Posted by tony007

Hi all could any one tell me how i can make a backup of my mysql database using phpmyadmin? i want to use it as backup and also want to transfer a copy of my database tables and data to diffrent mechine .Thanks

---

Well, your better off doing it directly from CPanel like so:

CPanel >> Backup >> Download a MySQL Database Backup >> Click the DB you wish to backup, download the file and your done :-)

There are scripts out there that will backup a database for you though.

Cheers,

Ryan Jones

Quote:

---

Originally Posted by sciguyryan

Well, your better off doing it directly from CPanel like so:

CPanel >> Backup >> Download a MySQL Database Backup >> Click the DB you wish to backup, download the file and your done :-)

There are scripts out there that will backup a database for you though.

Cheers,

Ryan Jones

---

You've made the assumption that everyone has CPanel.... which they do not. And not all control panels are created a like.

Within phpmyadmin, in the navigation on the left, click the database name.
Then after the page loads, there should be a tab across the top "Export".
Click It.
Select All Tables. Fill out the rest of the form, be sure to save to file. Include what ever options you want, and click the appropriate button.

-tg

When you export be sure to choose compatability as "Mysql 4", and add the options +drop database and +use statement. That makes life easier :)