mysql常见问题

备份

mysqldump --opt --add-drop-database --add-drop-table -h10.1.30.8 -uroot -p123456 --result-file=h:/mysql_dump/tbim_1600.sql --default-character-set=utf8 tbim_1600

 

还原

mysql -h10.1.30.8 -uroot -p123456 tbim_1600 < h:/mysql_dump/tbim_1600.sql

 

 

too many connections

$ mysql –u root –p
SHOW STATUS LIKE 'max_used_connections';

mysql> SHOW VARIABLES LIKE 'max_connections';
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| max_connections | 151   |
+-----------------+-------+

mysql> SET GLOBAL max_connections = 512;