Transferred from: http://sour.njcit.cn/html/2012/net_0420/503.html
PHPCMS V9 Database Backup and Recovery
One, database backup
1. Log in to the website management background, record the version of Phpcms V9
To prevent the database from recovering after a version upgrade, administrators should develop a platform version to record when backing up data. Also remind the Administrator to record the account number and password.
2. Access to the Database Tools interface
In the management background of the first page, click on the "extension", this will go into the extension interface, the left side of a "Database Tools", which is the database backup and recovery of the place.
3. Backing Up the database
When entering the database Tools interface, you will see the interface shown, first select "Select Database Pool", select the corresponding database, and then "deselect" is click, select the corresponding database table, not the experts recommend all selected, and then click "Start Backup Data".
4. Download the backed up database file
When you click "Start Backup Data", you will soon see the interface shown, which will generate a "phpcmstables_20120420_7010_1.sql" file, if the database is large, will generate multiple files, then the file is stored on your site "Caches\bakup \default "folder. Please use the download tool to download the backup file, the corresponding URL is "http://URL/caches/bakup/default/phpcmstables_20120420_7010_1.sql", if more than one file please download.
Second, database recovery
If there is a problem with the site data, you need to upload the backed-up file to the "Caches\bakup\default" of the site, and then go to the admin background, in the "extensions" | Data Tools "|" Database import, you will see the uploaded database backup file, if you need to recover select all files, and then click "Data Recovery" after the first recovery file.
Note: (1) When recovering data, please note that the BACKUP database file corresponds to the platform version, (2) after recovering the database, the account and password of the background administrator is the account and password when the database is backed up.
PHPCMS V9 Database Backup and Recovery