Backup_and_Restore_Your_Database_Using_phpMyAdmin - e107inc/e107v1 GitHub Wiki

title: Backup and Restore Your Database Using phpMyAdmin permalink: /Backup_and_Restore_Your_Database_Using_phpMyAdmin/

Introduction

From 0.7.0 onwards the internal MySQL database backup tool has been removed. This is because providing an evolving, stable backup solution for the constantly changing structure of MySQL databases would require a lot of effort and also because there are already many quality Open Source backup tools available, such as phpmyadmin.

Don't forget to backup your files, download your website files using FTP under /public_html - the folder where you installed e107.

Backing Up Your Database

  1. First, navigate to your phpMyAdmin page via cPanel or whatever alternative administration system your host provides i.e. Plesk etc. and log in
  2. From the dropdown box on the left (or the text link) click on your e107 database to show all the fields
  3. In the main page, click on the 'Export' tab
  4. Make sure the main 'Structure' 'select all' and 'Data' boxes are ticked
  5. In the right box, make sure 'Add drop table', 'Add AUTO_INCREMENT value' and 'Enclose table and field names with backquotes' are ticked
  6. select the SQL format in the 'export' column'
  7. Tick 'Save as file'
  8. If you want the backup file compressed, tick either 'zipped' or 'gzipped'
  9. Click 'Go'to save your file - the preferred location would be your own PC - saving a backup on a host server could be problematic should the server hard drive fail. It's always better to have your own backup locally!

Restoring a backup

in PhpMyAdmin main page - Click on the 'SQL' tab at the top and browse to the location of your backup file. Then select 'Go' from the tab at the bottom right corner of the screen - you may need to empty your existing database before you can restore the backup however normally you don't as the backup will simply overwrite the existing database.

Back-up / Restore related plugins

Some plugins that might become handy for not so experienced PhpMyAdmin users:

Category:HOWTOs Category:Admin Category:Backup Category:Security Category:Upgrade Category:Theming