Backing up the mySQL database using phpmyadmin

  1. Log into phpmyadmin on your server
  2. Select your store database from the left hand drop down list of databases
  3. Select the "Export" link from the main menu
  4. From the Export box, Select All and tick the SQL radio button below
  5. To the right in the SQL box check the boxes for Structure and Data
  6. Finally select "Save as File", Compression: None and hit the Go button to save the .sql file to your hard drive

Importing the back up using phpmyadmin

  1. Log into phpmyadmin on your server
  2. Create a new database by typing in the name of the database in the "Create Database" field.
  3. Click on the link at the top of the page "SQL"
  4. In the box "Location of the textfile:" browse to where you saved the .sql file and hit the Go button.
  5. You should now having a listing of all the fields for your store database and you are all finished.
Print page Print Page