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