mysql相关命令行

http://blog.youkuaiyun.com/muziduoxi/article/details/6091202

1. 客户端连接

./mysql -hlocahost -P3306 -uroot -p123456

2. show databases;

3. use es_manager;

4. show tables;

5.数据库导出，进入bin

 ./mysqldump -h localhost -P3306 -ude_user -pabcd data_export > a.sql

6. 数据库导入

先创建data_export数据库

./mysql -h localhost  -u root -p1234 -P3306 data_export < data_export.sql