backup

how to back up a mysql db with phpmyadmin ?
d2playerAsked:
Who is Participating?
 
dkjariwalaConnect With a Mentor Commented:
Very simple.

Go to your phpmyadmin setup through browser.

On the left side you have list of databases.
Click on any database.

Then on right frame, it would display all the tables you have with information about them.


Scroll down, you would see a section called,

View dump(schema) of database.
Again there would be list of tables. Dont select any.
This way you can take backup of whole db.

Select
*structure and data* from three options named,

 Structure only
 Structure and data
 Data only

Check all the checkboxes,

 Add 'drop table'  
 Complete inserts  
 Extended inserts  
 Use backquotes with tables and fields' names  
 Send  

and then press Go,

It would ask you to download,

file with same name as your db name. That is your complete DB.

This is how you take backup.
To restore this,
Again go to phpmyadmin and import this file in that run sql query section.


JD
0
All Courses

From novice to tech pro — start learning today.