Tools Tags

Site management Publishing point management basic settings Security configuration PHPSSO configuration Email configuration connect configuration role management Administrator management

Module management

Announcement management Site Search short message data source Financial module Comment module Friendly link module Advertising module voting module mood module Collection module Enterprise Yellow Pages

User Management

Member management Review members Member module configuration Manage member group Manage membership model

Template management

Template style management Template style list management

Extended management

Background operation log Download image management IP ban Update site-wide cache Source management Database tools Menu management Sensitive words Baibu/Google map Affiliate links Workflow

Home

Backend Development

PHP

phpcms development tutorial

Database tools

Collection 81

update time 2016-09-11

Source management

Menu management

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

Common operations

Operation name	Description
Database export (backup)	None
Data Recovery	None
Data table optimization/repair	none

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.