Formatting code for BackupDatabase
=== Backup Process with phpMyAdmin ===
//It is **strongly recommended** that you backup your database at regular intervals and before an upgrade. [[RestoreDatabase Restoring your database]] from backup is then possible if something goes wrong. This procedure describes how to backup a database using ""phpMyAdmin"". [[http://en.wikipedia.org/wiki/PhpMyAdmin phpMyAdmin]] is the name of the tool commonly used to manipulate a [[http://en.wikipedia.org/wiki/MySQL MySQL]] database. A good hosting package will have this included.//
~1)Log into phpMyAdmin on your server
~1)From the main login screen, select 'Databases'
~1)Now click the name of your phplist database
~1)The next screen will show you all the tables inside your phplist database. Click the 'Export' tab on the top set of tabs.
~1)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'.
~1)Ensure that the SQL radio-button is selected.
~1)The SQL Options
~~- 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.
~1)Tick the 'Save as file' option, and leave the template name alone (*). Select 'None' for compression.
~1)Now click 'Go' and you should be prompted for a file to download. Save the file to your computer. Depending on the database size, this may take a few moments.
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""##''
==Related pages==
~- [[RestoreDatabase Restoring your database]]
~- [[PhplistInstallation Installing phplist]]
~- [[PhplistUpgrade Upgrading phplist]]
----
CategoryDocumentation
//It is **strongly recommended** that you backup your database at regular intervals and before an upgrade. [[RestoreDatabase Restoring your database]] from backup is then possible if something goes wrong. This procedure describes how to backup a database using ""phpMyAdmin"". [[http://en.wikipedia.org/wiki/PhpMyAdmin phpMyAdmin]] is the name of the tool commonly used to manipulate a [[http://en.wikipedia.org/wiki/MySQL MySQL]] database. A good hosting package will have this included.//
~1)Log into phpMyAdmin on your server
~1)From the main login screen, select 'Databases'
~1)Now click the name of your phplist database
~1)The next screen will show you all the tables inside your phplist database. Click the 'Export' tab on the top set of tabs.
~1)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'.
~1)Ensure that the SQL radio-button is selected.
~1)The SQL Options
~~- 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.
~1)Tick the 'Save as file' option, and leave the template name alone (*). Select 'None' for compression.
~1)Now click 'Go' and you should be prompted for a file to download. Save the file to your computer. Depending on the database size, this may take a few moments.
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""##''
==Related pages==
~- [[RestoreDatabase Restoring your database]]
~- [[PhplistInstallation Installing phplist]]
~- [[PhplistUpgrade Upgrading phplist]]
----
CategoryDocumentation
