Using phpMyAdmin for database backup and restoration _ MySQL

PhpMyAdmin for database backup and restoration

First, login

In the config. inc. php file, you need to set an option

Search: $ cfg ['servers'] [$ I] ['auth _ type'] = 'cooker ';

This is the authentication method. it is recommended to use http or cookie authentication, which is safer.

It can also be in the config format. In this configuration file, write the account and password of the mysql database. you do not need to enter the password again each time you log on. This is convenient, but it is not safe. therefore, this authentication method is strongly not recommended.

　　

After the page is opened, a verification box is displayed. you need to enter the database account and password.

After successful access, the page may be in English
,

　　

On the right side of the page, select Chinese.

　　

You can select Chinese or other languages you are familiar with in the language on the right.

Install phpwind now.

Create a database named pw.

According to the phpwind encoding version you use, the database encoding you need is different.

　　

If your forum is gbk, then the database is also gbk.

The same is true for UTF8.

　　

Click "Create.

　　

The above prompt is displayed after the creation is successful.

I will not repeat the phpwind installation process here.

After phpwind is installed, refresh the phpmyadmin page and select the database name installed by phpwind on the left side of the page. here is pw.

　　

The page will jump to the pw database page.

You can execute SQL statements here. For example, if some friends want to clear the prestige of all forum users, I will explain this in detail.

First, click "SQL" at the top of the page ",

Enter "update pw_memberdata set rvrc = '0'" and click "execute.

　　

Let's talk about exporting databases. click "export" at the top of the page. Then, select "Save as file" at the bottom left of the page ",

　　

After you click "execute", you will be prompted to download the SQL export file.

　　

Import the data in the reverse order once.

Click "import" or "import" at the top of the page ".

Click browse to select the SQL database file to be imported.

Select "file character set", generally utf8 and gbk.

Click "execute" (lmport) to import.

　　

If the database is too large and larger than 2 MB, some servers will not allow the upload. in this case, the parts will be split.

During phpwind background backup, if the database is too large, phpwind will automatically split the database into files that are slightly less than 2 MB. when importing data from phpmyadmin, import them one by one.