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

Most people do not understand the knowledge points of this article "how to use Mysql to import SQL files under the Linux system", so the editor summarizes the following contents, detailed contents, clear steps, and a certain reference value. I hope you can get something after reading this article. Let's take a look at this "how to import SQL files using Mysql under the Linux system" article.

Create a new empty database mysql > create database abc

Mysql > create database abc

Import database method 1:

1. Select the database you just created

Mysql > use abc

2. Encode the database

Mysql > set names utf8

3. Import SQL file data from the path

Mysql > source / A/B/C.sql

Import database method 2:

Mysql-uabc_f-p abc < C.sql above is about "how to use Mysql to import SQL files under Linux system". I believe we all have some understanding. I hope the content shared by the editor will be helpful to you. If you want to know more about it, please pay attention to the industry information channel.

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.