How to restore database with phpmyadmin

How does phpmyadmin restore the database?

1. Determine the backup type. First, you need to determine the type of backup file of the database, zhimssql\mysql, etc.

MSSQL: Common ones include .sql\.mdf\.bak, etc.; MYSQL: Common ones include .sql\.myd\.psc, etc.

Among them, there are two types. The sql files are different. If the customer cannot provide confirmation, you need to use Notepad to open the backup file to view the header information. Generally, the header of the .SQL file of MYSQL backup is the information of MySQL dump, which distinguishes the type.

2. Create an empty database with the database name in PHPmyAdmin.

3. After the creation is completed, the database will be entered by default in the left column.

4. Select "Import" in the right window; click Browse in the "File Location" to locate the backup file.

5. Click "Execute" below. Note: Generally suitable for smaller backup files.

Recommended tutorial: "phpmyadmin tutorial"

The above is the detailed content of How to restore database with phpmyadmin. For more information, please follow other related articles on the PHP Chinese website!