Template:Back up the Database: Difference between revisions From Online Manual

Jump to: navigation, search
(Created page with "<noinclude>This common text is used in both the upgrade and update articles. 1 numbered parameter, the possible values are: *upgrade *update ''(default)'' </noinclude>==Back up...")
 
 
(8 intermediate revisions by 3 users not shown)
Line 1: Line 1:
<noinclude>This common text is used in both the upgrade and update articles. 1 numbered parameter, the possible values are:
<noinclude>This common text is used in the [[template:back up]]. 1 numbered parameter, the possible values are:
*upgrade
*upgrade
*update ''(default)''
*update ''(default)''




</noinclude>==Back up the Database==
</noinclude>===Back up the Database===
Before starting the {{lcfirst:{{{1|update}}}}} process, a backup of the live database should be taken. This protects the forum from accidental damage and any issues from {{#if: {{{1|}}}|{{#ifeq: {{{1}}}|upgrade|upgrading|updating}}}}. Although all steps are taken, and extensive testing carried out, sometimes issues develop. Therefore, having a backup is crucial. The upgrading tool can backup all database tables before it runs, however the best practice is to have a full backup available.


===Back up a database using SMF===
This is crucial. You MUST backup your database. If you don't, there's no way, at all, that you can revert back to v1.x of your forum, should you not be able to upgrade to v2, for some reason.
From SMF, navigate to Forum Maintenance. (''[[Administration Center]] > Maintenance > [[Forum Maintenance]]'') On the [[Forum Maintenance#Database|database section]], save the data and the structure. Then, compress the file. Select "Download" and wait for the database to complete the download completely. '''Note''': It is recommended if you use this method to verify that the backup is complete by opening the file and checking the last line. If the file is not complete and has an error please try one of the other methods to backup your database.


===Back up a database using PHPMyAdmin===
It's highly recommended that you backup from your site's CPanel, or equivalent, as the SMF backup doesn't work, with some servers.
 
====Back up a database using SMF====
To backup the database from SMF's Admin section, navigate to Forum Maintenance (''[[Administration Center]] > Maintenance > [[Forum Maintenance]]''). On the [[Forum Maintenance#Database|database section]], save the data and the structure. Then, compress the file. Select "Download" and wait for the database to complete the download completely. '''Note''': It is recommended if you use this method to verify that the backup is complete by opening the file and checking the last line. If the file is not complete and has an error please try one of the other methods to backup your database.
 
====Back up a database using PHPMyAdmin====
PHPMyAdmin gives the option to export a database, from the initial page, select the "Export" option and follow the instructions. Select your SMF database. These are different based on host.
PHPMyAdmin gives the option to export a database, from the initial page, select the "Export" option and follow the instructions. Select your SMF database. These are different based on host.


===Back up a database using a control panel===
====Back up a database using a control panel====
If your hosting service provides a control panel interface, this can be used to back up a database. Selecting the "Backups" or "Backups Wizard" options should take you to a page, prompting you to back up your database. With different hosts, these options may have different titles.
If your hosting service provides a control panel interface, this can be used to back up a database. Selecting the "Backups" or "Backups Wizard" options should take you to a page, prompting you to back up your database. With different hosts, these options may have different titles.

Latest revision as of 17:26, 31 July 2013

This common text is used in the template:back up. 1 numbered parameter, the possible values are:

  • upgrade
  • update (default)


Back up the Database

This is crucial. You MUST backup your database. If you don't, there's no way, at all, that you can revert back to v1.x of your forum, should you not be able to upgrade to v2, for some reason.

It's highly recommended that you backup from your site's CPanel, or equivalent, as the SMF backup doesn't work, with some servers.

Back up a database using SMF

To backup the database from SMF's Admin section, navigate to Forum Maintenance (Administration Center > Maintenance > Forum Maintenance). On the database section, save the data and the structure. Then, compress the file. Select "Download" and wait for the database to complete the download completely. Note: It is recommended if you use this method to verify that the backup is complete by opening the file and checking the last line. If the file is not complete and has an error please try one of the other methods to backup your database.

Back up a database using PHPMyAdmin

PHPMyAdmin gives the option to export a database, from the initial page, select the "Export" option and follow the instructions. Select your SMF database. These are different based on host.

Back up a database using a control panel

If your hosting service provides a control panel interface, this can be used to back up a database. Selecting the "Backups" or "Backups Wizard" options should take you to a page, prompting you to back up your database. With different hosts, these options may have different titles.



Advertisement: