How to use Discuz! Back-end backup and database recovery

Statement: This content only represents the personal experience or opinions of netizens, and does not represent the positions and opinions of the website. Backup and Recovery Discuz! There are many methods for site database, and each method has different ideas. Discuz! In order to facilitate the user to back up and restore the database, this function has been built in the background, which is easy for the webmaster to operate. Share Discuz here today! X2.5 Forum background data

Statement: This content only represents the personal experience or opinions of netizens, and does not represent the positions and opinions of the website.

Backup and Recovery Discuz! There are many methods for site database, and each method has different ideas. Discuz! In order to facilitate the user to back up and restore the database, this function has been built in the background, which is easy for the webmaster to operate. Share Discuz here today! X2.5 backup and restoration methods for the background database of the forum, as well as some details to be paid attention to when backing up the database and restoring the database.

I. use Discuz! Back-end database backup

1. to ensure that the backup data is complete and correct, ask the webmaster to close the site before backing up the data;

2. use the webmaster permission to log on to the backend -- webmasters -- database -- Backup. There are two basic data backup types: "Discuz! And UCenter data "and" custom backup ";

1) select "Discuz! And UCenter data ", will back up your Discuz! All data table files of the database (including data tables generated by plug-ins)

2) select "custom backup" and select the data table to be backed up as required.

3. there is a "more options" next to "submit". you can set more options based on your needs. users who are not familiar with it do not have to click on more options, keep Discuz! You can set the default value. The tips for more options are as follows:

1) MySQL Dump is faster than Discuz! Volume-based backup is much faster, but the server needs to support Shell permissions. due to compatibility issues of MySQL, the backup and recovery servers should have the same or similar version numbers before they can proceed smoothly. Therefore, MySQL Dump is risky: once one of the servers performing backup or restoration operations disables Shell, or the import fails due to version compatibility issues, you will not be able to use MySQLDump to back up or recover data from backup; Discuz! This restriction does not apply to volume-based backup;

2) the settings in the data backup option are only for special purposes of advanced users. before you fully understand the database, use the default parameter backup, otherwise, serious problems such as backup data errors will occur;

3) the hexadecimal mode ensures the integrity of the backup data, but the backup file occupies more space;

4) compressing backup files can make your backup files take up less space.

4. select "data backup type" and click submit to start backup. the backup data files are saved in a backup_XXXXXX folder in the data directory under the root directory of the site;

5. after the database is backed up, you can re-open the site.

II. use Discuz! Restore database in the background

1. to restore data integrity, ask the webmaster to close the site before restoring the data;

2. use the webmaster permission to log on to the backend-> webmasters-> database-> recover, and you will see your data backup records, including the backup time and data type;

3. Upload the required restore. php file to restore the database;

1) before restoring data, please go to Discuz! Find the restore. php file in the utility folder under the X2.5 installation file directory, and upload the restore. php file to the data directory of the program folder;

2) If you have recovered the database,/data/restore will be generated in the root directory. lock file, data recovery function lock, if you are sure to restore data, please go to the server to delete. /data/restore. lock.

4. select the database backup file you want to restore and click import next to restore data;

5. for the security of your site, please delete the restore. php file in time after data is restored successfully;

6. after the database is restored, you can re-open the site.