Where is the phpcms database backup?

phpcms database backup In the "Database Tools" interface of the phpcms website management background, the method of backing up the database is: first select the "Database Pool" item; then select the corresponding database; finally click "Start Backing Up Data" "That's it.

##PHPCMS V9 database backup and recovery

1. Database backup

1. Log in to the website management background and record the version of PHPCMS V9

In order to prevent the database from being unable to be restored after the version upgrade, the administrator should develop a When backing up data, record the corresponding platform version. Also be reminded to record the account and password of the administrator at this time.

　2. Enter the database tool interface

On the home page of the management background as shown above, click "Extensions", and you will enter the extension interface. There is a "Database Tools" on the left. It is the place where database backup and recovery are performed.

　3. Back up database

When entering the database tool interface, you will see the interface shown in the figure below. First, select "Please select a database pool", select the corresponding database, and then "Invert selection "Yes, click to select the table of the corresponding database. Experts do not recommend selecting all of them, and then click "Start Backing Up Data".

　4. Download the backup database file

Click "Start Backup Data" in the previous step and you will soon see the interface shown in the figure below, and a "phpcmstables_20120420_7010_1. sql" file, if the database is large, multiple files will be generated, and the files will be stored in the "caches\bakup\default" folder of your website. At this time, please use the download tool to download the backup file. The corresponding URL is "http://website/caches/bakup/default/phpcmstables_20120420_7010_1.sql". If there are multiple files, please download them together.

2. Database recovery

If there is a problem with the website data, you need to upload the backup file to the "caches\bakup\default" of the website, and then enter the management In the background, in "Extensions" | "Data Tools" | "Database Import", you will see the uploaded database backup files here. If you need to restore, please select all files, and then click "Data Recovery" behind the first recovery file. ".

Note: (1) When restoring data, please pay attention to the platform version corresponding to the backup database file; (2) After restoring the database, the account and password of the background administrator are the account and password used when backing up the database.

The above is the detailed content of Where is the phpcms database backup?. For more information, please follow other related articles on the PHP Chinese website!