MySQL
Backup and restore procedure using phpMyAdmin
Mark Schofield
Return to articles
Table of Contents
1. Backup
- Open phpMyAdmin
- Click on Export in the menu
- Make sure that all tables in the database are selected
- Make sure the export format is SQL
- Make sure the Structure option is checked with the following options:
- Add DROP TABLE / DROP VIEW
- Add AUTO_INCREMENT value
- Enclose table and field names with backquotes
- Make sure the Data option is checked with the following options:
- Check Save as file, do not change the file name, use compression if you want
- Click GO to download the backup file
2. Restore
- Open phpMyAdmin
- Click on Import in the menu
- Browse to your backup of the database
- Click GO to restore from the backup file
Mark Schofield
mark.schofield.free.fr
Last updated : 20 August 2008