Database tools

This function is used for common operations such as data backup, recovery, optimization, and repair.

1. Database export (backup)

Export Settings

BackupPHPCMS Created website data table and database For other program data table backups, we select all backups and set the file size of each volume below. It is recommended to use the default 2048 K.

Where are the backup files stored?

The backed up data files are stored in /caches/# Under ##bakup/default, you can use ftp to back up to other machines or this machine . , Backup file format: phpcmstables_20081223_2829_1.sql Fixed name_Year, Month, Day _4 Random number_Generate file number, Database backed up at the same time File The four-digit random numbers are the same

Select the database to be backed up and the data tables to be backed up for backup.

2. Data recovery

If the database has been backed up, you can view the backup records and restore the backup data. Please proceed with caution! As shown below:

3. Data table optimization and repair

Location: Extensions > Extensions > Database Tools >

Database repair: Select the table that needs to be repaired or optimized. After submission, the system will automatically repair or optimize the table you selected to avoid errors and improve data speed.