MySql用户管理 讲义

注意路径，复制my.ini文件里的\（回车上面） 和windows文件夹里的路径所用/的斜杠不一样。

备份数据库 mysqldump -uroot -p books>d:/bak.sq;用哪个斜杠都可以
恢复数据库 mysql -uroot -p books < d:/bak.sql;
Mysql>usebooks;
Mysql>source d:/bak.sql;
导出表：需要根据my.ini的路径写下面的命令 select /mysqldump/execute
mysql> select * from book_info where book_id=20150201 into outfile ‘C:/ProgramData/MySQL/MySQL Server 5.7/Uploads/testout_book_info.txt’;
导出一个包含创建表命令和数据的2个文件，只制定路径，不指定文件名
mysqldump -T “C:/ProgramData/MySQL/MySQL Server 5.7/Uploads“ -uroot -p books book_category
Ente passowrd:

使用mysql命令，需要指定路径和文件名
C:\Users\myPC>mysql -uroot -p --execute=“select * from reader;” books >“C:/ProgramData/MySQL/MySQL Server 5.7/Uploads/reader_bak_2.txt”
Enter password: **********

导入数据表：第一个不乱码，第二个发现乱码
C:\Users\myPC>mysqlimport -uroot -p books “C:/ProgramData/MySQL/MySQL Server 5.7/Uploads/book_category.txt”
Enter password: **********
books.book_category: Records: 5 Deleted: 0 Skipped: 0 Warnings: 0

mysql> load data infile “C:/ProgramData/MySQL/MySQL Server 5.7/Uploads/book_category.txt” into table books.book_category;
Query OK, 5 rows affected (0.01 sec)
Records: 5 Deleted: 0 Skipped: 0 Warnings: 0