It is strongly recommended that you backup your database at regular intervals and before an upgrade. Restoring your database from backup is then possible if something goes wrong. This procedure describes how to backup a database using phpMyAdmin. phpMyAdmin is the name of the tool commonly used to manipulate a MySQL database. A good hosting package will have this included.
- Log into phpMyAdmin on your server
- From the main login screen, select 'Databases'
- Now click the name of your phplist database
- The next screen will show you all the tables inside your phplist database. Click the 'Export' tab on the top set of tabs.
- Look at the left box at the top of the Export section. All the tables in the database you selected are in that box.
- If you have other programs that use the database, then choose only those tables that correspond to your PHPList install. They will be the ones with that start with "phplist_" or whatever 'table_prefix' you specified in your 'config.php' file.
- If you only have phplist using the selected database, in the left column, click 'Select All'.
- Tick the following boxes: Structure, 'Add DROP TABLE', 'Add AUTO_INCREMENT' and 'Enclose table and field names with backquotes'
- And for the DATA section: Leave the boxes inside this section as they are, but make sure to keep the checkbox next to the "DATA" heading checked.
You have now backed up your database.
*) If a template name has not been pre-defined, you could use this: __DB__-_%Y%m%d_%T which should result in DatabaseName_yyyymmdd_hh-mm-ss.sql