潜龙勿用,见龙在田
全部博文（540）
分类： Mysql/postgreSQL
2011-06-19 14:09:00
full backup:
创建专门用于backup的account:
mysql> grant select,lock tables on *.* to 'backup'@'localhost' identified by 'password';
Query OK, 0 rows affected (0.00 sec)
full backup command:
mysqldump --skip-lock-tables --all-databases -ubackup -ppassword >alldb.sql
