phpMyAdmin How to import *.sql files online, *.sql with Sql.zip, gzip file conversion

If it is *.sql file directly in the background online generally can not import, background support gzip, bzip2, *. Sql.zip

So how are we going to import *.sql files?

Workaround: First install the PHP component locally, not to mention the recommended use of Wamp.

Enter into the Wampmysqlbin directory from the command line and execute the following command to import *. Sql

E:webwampmysqlbin>mysql-u Root -P b766951_apple < e:/1.sql
Enter Password: ********

Root is the phpMyAdmin login username, b766951_apple is the database name e:/1.sql is the SQL file that needs to be imported.

This is into the phpmyadmin background can see the SQL file has been imported into

You can then directly export other compressed files, such as zip, to facilitate the online import of the database in virtual space or phpMyAdmin on the server.

The steps to import a zip file online are simple, select Import directly, and then browse the compressed file OK. We're not going to talk about this.

phpMyAdmin How to import *.sql files online, *.sql and Sql.zip, gzip file conversion solutions