MySQL problem set sorting

(1) how to log on to MySQL using command line

Answer:

(2) import the. SQL file to the MySQL database through the command line:

1. The. SQL file to be imported is moved to the binfile, which is convenient.
2. Use CD to specify the corresponding path
3. Enter MYSQL: mysql-u username-P
For example, the command line I entered is mysql-u root-P (enter the same password for MySQL)
4. Create the database you want to create in MySQL-front. An empty database is used, for example, create a target database named "news ".
5. Enter the mysql> use target database name.
For example, the command line I entered is mysql> use news;
6. Import file: the file name imported from mysql> source;
For example, the command line I entered is mysql> source news. SQL;
MySQL backup and restoration are completed using mysqldump, MySQL, and source commands.