MySQL max_connections
show variables like 'max_connections'; SET GLOBAL max_connections = 250;
How to Reset the Root Password
# /etc/init.d/mysql stop # mysqld --skip-grant-tables $ mysql mysql> FLUSH PRIVILEGES; mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';
howto-copy-mysql-database-remote-server
mysqldump -u user -p'password' db-name foo | ssh user@remote.box.com mysql -u user -p'password' db-name foo mysqldump -u username -p'password' db-name | ssh user@remote.box.com mysql -u username -p'password db-name
http://www.cyberciti.biz/tips/howto-copy-mysql-database-remote-server.html
http://www.hackhowtofaq.com/blog/how-to-backup-mysql-db-remotely/
http://www.thegeekstuff.com/2008/09/backup-and-restore-mysql-database-using-mysqldump/
Full backup
Edit the root users mysql home environment configuration
在执行备份的用户home目录下面创建my.cnf文件
cat ~/.my.cnf # Insert the following into the my.cnf file [mysqldump] user = mysqldbusername password = mysqldbpassword
- chmod 600 ~/.my.cnf
Cron
30 12 * * * mysqldump -u mysqlusernamehere -h localhost --all-databases > /home/backups/mydatabasename/$(date +"%F-%H%M")_mydatabasename_mysql_db.sql