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
Re: how to make script of mysql database using phpmyadmin?
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
Re: how to make script of mysql database using phpmyadmin?
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
Re: how to make script of mysql database using phpmyadmin?
When you export be sure to choose compatability as "Mysql 4", and add the options +drop database and +use statement. That makes life easier :)