Some common operations for Linux (update at any time) command import SQL file

First,. Open the Terminal method

1. The most convenient is ctrl+alt+t

2. Click on the DASH homepage to enter terminal

Second, display the current path

Pwd

Third, display the file under the current path

Ls

Iv. importing SQL files to MySQL database

1.>mysql-u root-p

2.>mysql Password

3. Enter MySQL to import the >use yourdatabasename;

4 >set name UTF8;

5.>source/home/user/desktop/test.sql;

Began to execute, pay attention to punctuation '; ' Don't lose it.

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Some common operations for Linux (update at any time) command import SQL file