This article introduces how PHPmyadmin imports *. SQL files online, and converts *. SQL to SQL .zip and gzip files. For more information, see e.
This article introduces how PHPmyadmin imports *. SQL files online, and converts *. SQL to SQL .zip and gzip files. For more information, see e.
If a *. SQL file is directly online in the background, it cannot be imported. The background supports gzip, bzip2 ,*. SQL .zip
How can we import *. SQL files?
Solution: first install the PHP component locally. We recommend that you use wamp.
Run the following command to import data to the wampmysqlbin Directory *. SQL
E: Webwampmysqlbin> mysql-u root-p b766951_apple <E:/1. SQL
Enter password :********
Root is the username for phpmyadmin login, and b766951_apple is the database name E:/1. SQL is the SQL file to be imported.
0 & image. height> 0) {if (image. width >=700) {this. width = 700; this. height = image. height * 700/image. width; }}"/>
You can see that the SQL file has been imported into the phpmyadmin background.
0 & image. height> 0) {if (image. width >=700) {this. width = 700; this. height = image. height * 700/image. width; }}"/>
You can then directly export zip files and other compressed files to facilitate online database import from phpmyadmin in a virtual space or server.
0 & image. height> 0) {if (image. width >=700) {this. width = 700; this. height = image. height * 700/image. width; }}"/>
The process of importing a zip file online is simple. You can directly import the file and then browse the compressed file .. I won't talk about it here.
How does PHPmyadmin import *. SQL files online? *. SQL and SQL .zip file conversion solution