(1)导出库:
mysqldump -h localhost -u root -p mydb > e:\mysql\mydb.sql
(2)导入库:
mysql -h localhost -u root -p mydb2 < e:\mysql\mydb2.sql
(3)只导出表数据不导出表结构
mysqldump -u root -p -t dbname>e:\db_data.sql
(4)导出某张表
mysqldump -h localhost -u root -p dbname tablename > D:\tablename.sql
(5)修改root密码:
update mysql.user set password=PASSWORD("新密码") where User="root";
flush privileges;
备注:该博文为原创博文,如果转发请注明出处。(max.li)