mysql备忘

import xxx.sql
#mysql -uroot -p123
mysql>use db;
mysql>source /root/xxx.sql

#mysql -uroot -p123 db < /root/xxx.sql

export to xxx.sql

mysqldump --opt db_name table_name > xxx.sql

exec xxx.sql
mysql -h -u -P -p databasename -e "sql"
mysql -h -u -P -p --default-character-set=utf8 databasename < xxx.sql

>set names utf8

[mysql]
default-character-set=utf-8