MySQL

Backup and restore procedure using phpMyAdmin

Mark Schofield

Return to articles

Table of Contents

• 1. Backup
• 2. Restore

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:
  • Use hexadecimal for BLOB
• 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