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 [Added related pages + minor addition + minor formatting]
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 [Added related pages + minor addition + minor formatting]
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 [Added related pages + minor addition + minor formatting]
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 [Added related pages + minor addition + minor formatting]
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 [Added related pages + minor addition + minor formatting]
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 [Added related pages + minor addition + minor formatting]
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 [Added related pages + minor addition + minor formatting]

No Differences

Revision [402]

Edited on 2005-11-08 15:36:25 by SauL11 [Added related pages + minor addition + minor formatting]
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 [Added related pages + minor addition + minor formatting]
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 [Added related pages + minor addition + minor formatting]
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 [Added related pages + minor addition + minor formatting]
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 [Added related pages + minor addition + minor formatting]
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 ==
<ol>
<li>Log into phpMyAdmin on your server</li>
<li>From the main login screen, select 'Databases'</li>
<li>Now click the name of your PHPList database</li>
<li>The next screen will show you all the tables inside your WordPress database.<br />
Click the 'Export' tab on the top set of tabs. (Image#3)</li>
<li>Look at the left box at the top of the Export section. All the tables in the database you selected are in that box.</li>
<ul>
<li>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.</li>
<li>If you only have PHPList using the selected database, in the left column, click 'Select All'.</li>
</ul>
<li>Ensure that the SQL radio-button is selected.</li>
<ul>
<li>The SQL section</li>
<li>Tick the following boxes: Structure, 'Add DROP TABLE', 'Add AUTO_INCREMENT' and 'Enclose table and field names with backquotes'</li></ul>
<li>The DATA section</li>
<ul>
<li>Leave the boxes inside this section as they are, but make sure to keep the checkbox next to the "DATA" heading checked.</li>
</ul>
<li>Tick the 'Save as file' option, and leave the template name alone.<br />
For now, select 'None' for compression.</li>
<li>Now click 'Go' and you should be prompted for a file to download. Save the file to your computer.<br />
Depending on the database size, this may take a few moments.</li>
<li>You have now backed up your database.</li>
</li>
</ol>

Revision [397]

The oldest known version of this page was created on 2005-11-08 15:20:57 by SauL11 [Added related pages + minor addition + minor formatting]
Page was generated in 0.3527 seconds