MyISAM to InnoDB
ALTER TABLE boblog_blogs ENGINE=InnoDB;
ALTER TABLE boblog_calendar ENGINE=InnoDB;
max connections
show global variables like "%max_con%";
set global max_connections xxx;
GRANT ALL PRIVILEGES
GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘ IDENTIFIED BY ‘sa123‘ WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO ‘myuser‘@‘%‘ IDENTIFIED BY ‘mypassword‘ WITH GRANT OPTION;
flush privileges;
mysqldump
mysqldump -uroot -pabc123 qida_prd_20151122_1753 >qida_prd_20151124_0013.sql
mysql -uroot -p qida2_t001<F:\asp db backup\mysql\sql script\1511qd_shop.sql
MYSQL常用命令 MyISAM to InnoDB, max connections , GRANT ALL PRIVILEGES , mysqldump 等等
原文：http://www.cnblogs.com/zero530/p/5035560.html