larger smaller normal text version of this page

Revision [1008]

Last edited on 2006-12-15 06:26:04 by AlStillero [minor formatting]
Additions:
*) 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""##''
Deletions:
*) If a template name has not been pre-defined, you could use this: ""__DB__-_%Y%m%d_%T"" which should result in ""YourDatabaseName_yyyymmdd_hh-mm-ss.sql""

Revision [999]

Edited on 2006-12-11 20:44:40 by AlStillero [Added related pages + minor addition + minor formatting]
Additions:
//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)Tick the 'Save as file' option, and leave the template name alone (*). Select 'None' for compression.
*) If a template name has not been pre-defined, you could use this: ""__DB__-_%Y%m%d_%T"" which should result in ""YourDatabaseName_yyyymmdd_hh-mm-ss.sql""
==Related pages==
~- [[RestoreDatabase Restoring your database]]
~- [[PhplistInstallation Installing phplist]]
~- [[PhplistUpgrade Upgrading phplist]]
Deletions:
**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.
[[http://en.wikipedia.org/wiki/PhpMyAdmin phpMyAdmin]] is the name of the program used to manipulate your database. A good hosting package will have this included.
~1)Tick the 'Save as file' option, and leave the template name alone. Select 'None' for compression.

Revision [609]

Edited on 2006-07-17 16:31:28 by HernoL
Additions:
~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.
~~- If you only have phplist using the selected database, in the left column, click 'Select All'.
Deletions:
~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.
~~- If you only have PHPList using the selected database, in the left column, click 'Select All'.

Revision [414]

Edited on 2005-11-08 17:28:32 by SauL11
Additions:
[[http://en.wikipedia.org/wiki/PhpMyAdmin phpMyAdmin]] is the name of the program used to manipulate your database. A good hosting package will have this included.
Deletions:
[[phpMyAdmin]] is the name of the program used to manipulate your database. A good hosting package will have this included.

Revision [407]

Edited on 2005-11-08 15:39:14 by SauL11
Additions:
~~- 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.
Deletions:
~& 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.

Revision [406]

Edited on 2005-11-08 15:38:11 by SauL11
Additions:
~& 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.
Deletions:
~&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.

Revision [405]

Edited on 2005-11-08 15:37:53 by SauL11
Additions:
~&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.
Deletions:
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.

Revision [404]

Edited on 2005-11-08 15:37:31 by SauL11
Additions:
~&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'.
Deletions:
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'.

Revision [403]

Edited on 2005-11-08 15:36:48 by SauL11

No differences.

Revision [402]

Edited on 2005-11-08 15:36:25 by SauL11
Additions:
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.
Deletions:
~ 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.

Revision [401]

Edited on 2005-11-08 15:35:46 by SauL11
Additions:
~ 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.
Deletions:
~- 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.

Revision [400]

Edited on 2005-11-08 15:34:47 by SauL11
Additions:
~- 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.
Deletions:
~-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.

Revision [399]

Edited on 2005-11-08 15:34:06 by SauL11
Additions:
~1)The next screen will show you all the tables inside your PHPList database. Click the 'Export' tab on the top set of tabs.
~-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.
Deletions:
~1)The next screen will show you all the tables inside your PHPList database.
Click the 'Export' tab on the top set of tabs.
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.

Revision [398]

Edited on 2005-11-08 15:32:33 by SauL11
Additions:
**It is strongly recommended that you backup your database at regular intervals and before an upgrade.**
~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.
Deletions:
'''It is strongly recommended that you backup your database at regular intervals and before an upgrade.'''
== Using phpMyAdmin ==

  1. Log into phpMyAdmin on your server

  2. From the main login screen, select 'Databases'

  3. Now click the name of your PHPList database

  4. The next screen will show you all the tables inside your WordPress database.

    Click the 'Export' tab on the top set of tabs. (Image#3)

  5. 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'.


  6. Ensure that the SQL radio-button is selected.


    • The SQL section

    • Tick the following boxes: Structure, 'Add DROP TABLE', 'Add AUTO_INCREMENT' and 'Enclose table and field names with backquotes'

  7. 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.


  8. Tick the 'Save as file' option, and leave the template name alone.

    For now, select 'None' for compression.

  9. 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.

  10. You have now backed up your database.



Revision [397]

The oldest known version of this page was created on 2005-11-08 15:20:57 by SauL11 [created page BackupDatabase]
Page was generated in 0.0344 seconds