Backing up database from phpMyAdmin

[SkinnerW]

Backing up database or creating a "database dump" is pretty much straight forward process and can be easily done from phpMyAdmin.

Depending on your host settings you may have separate phpMyAdmin panel for every database or single interface to manage all of them.

First step - you need to login into phpMyAdmin interface. In the left column you will see list of databases you can manage - click on one you need to back up.

On the next page you will see list of tables that were created in this database.

On top of the page click "Export" tab.

Next page will show options how you can save back up file.

- In the "Export" section "select" field you want to highlight all options (if they are not highlighted already) and check "SQL" radio.

- In the "Options" section you can leave default settings. Following boxes should be checked:
- Structure - checked
- Add AUTO_INCREMENT value - checked
- enclose table and field names with backquotes - checked

- Data - checked
- Maximal length of created query - leave 50000
- Use hexadecimal for BLOB - checked
- Export type - select "INSERT"

- check "Save as file" box
- File name template - leave default
- Compression - check "none" unless your database is huge than you can use "zip" or "gzip" compression

Click "go"...

Program will create sql file and you should see pop-up window asking if you want to save or open file - check save and file should be saved to default location on your hard disk.

That's it. Now you can easy restore your database if there is a problem or you need to move it to different server.

 

[gkd_uk]

Create tutorial SkinnerW

 

[temi]

Thanks very much for this Skinner, Nick will find it very useful.

 

[vicdigi]

Thanks Skinner, I found this very useful too and will refer to it at a later date.

 

[jackfranklin]

Nice tutorial, I was just about to google it