How does PHPmyadmin import *. SQL files online?

Source: Internet
Author: User
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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.