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

Xiaobian to share with you how phpmyadmin restore database, I hope you read this article after the harvest, let us discuss it together!

How does phpmyadmin restore the database?

1. To determine the backup file type, you first need to determine what type of backup file is used in the database, such as zhimssql\mysql.

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

Among them, the two types of.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 backed up by MYSQL is MySQL dump information, which is to distinguish the types.

Create an empty database with that database name in PHPmyAdmin.

3. After creation, the left column enters the database by default.

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

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

After reading this article, I believe you have a certain understanding of how phpmyadmin restores the database. If you want to know more about it, welcome to pay attention to the industry information channel. Thank you for reading!

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.