Shulou(Shulou.com)06/02 Report--

Where is the phpcms database backed up? In view of this problem, this article introduces the corresponding analysis and answers in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible way.

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, and finally click "start backing up data".

Backup and recovery of PHPCMS V9 database

I. 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 recover after the version upgrade, the administrator should be trained to record the corresponding platform version when backing up the data. At the same time, remind the administrator's account number and password at this time.

two。 Enter the database tools interface

On the home page of the administrative background shown above, click "expand", and you will enter the expansion interface. On the left, there is a "database tool", which is the place for database backup and recovery.

3. Backup database

When you enter the database tool interface, you will see the interface shown in the following figure. First, select "Please select the database pool", select the corresponding database, and then click "reverse selection" to select the tables of the corresponding database, not all of which are recommended by experts. Then click "start backup data".

4. Download the backed up database file

Click "start backing up data" in the previous step and you will soon see the interface shown in the following figure. At this time, a "phpcmstables_20120420_7010_1.sql" file will be generated. If the database is large, multiple files will be generated, and the files will be stored in your website's "caches\ bakup\ default" folder. At this time, 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 multiple files, please download together.

II. Database recovery

If there is a problem with the data of the website, you need to upload the backup file to the "caches\ bakup\ default" of the website, then go to the administrative backend, in "expand" | "data data tool" | "Database Import", you will see the uploaded database backup file here. If you need to restore, select all the files, and then click "data recovery" after the first restore 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 number and password of the background administrator are the account number and password when backing up the database.

The answer to the question about where to back up the phpcms database is shared here. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel for more related knowledge.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.