Backup and Restore Your Database Using phpMyAdmin
e107 Wiki: English | Русский | Deutsch | Français | Magyar | Português | Български | Česky | Nederlands | Ελληνικά | Italiano | Norske | Polska | Slovenščina | Español | Svenska | Translate: Wiki | Page
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
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.
Some plugins that might become handy for not so experienced PhpMyAdmin users: