Linux Environment MYSQ Import and export MySQL SQL file

Importing or exporting files from a server also requires tools to be transferred to this machine, WINSCP is recommended and used with Xshell

1 Importing a database two methods

　　

1 , first build empty database MySQL >create databasesABC;

method One: ( 1 Select database MySQL> useabc; (2) Set database code MySQL>set  names UTF8; 3 ) Import data (note the path to the SQL file) MySQL>source/home/abc/abc.sql;

-u user name-p password databasename <-uabc_f-p ABC < Abc.sql

2 Exporting Data

1-u user name-p password database name > database name. sql#/usr/local/mysql/bin/   mysqldump-uroot-p ABC >  Abc.sql will prompt for a password after hitting enter

2-u user name-p password-d database name > database name. sql#/usr/local/mysql/bin/   mysqldump-uroot-p-D ABC > AB C.sql Note:/usr/local/mysql/bin/  --->  mysql data directory

Linux Environment MYSQ Import and export MySQL SQL file