Template:Back up the Database

This common text is used in both the upgrade and update articles. 1 numbered parameter, the possible values are:

• upgrade
• update (default)

Back up the Database

Before starting the update process, a backup of the live database should be taken. This protects the forum from accidental damage and any issues from . 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

From SMF, 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.