mysql 簡單全量備份和快速恢復的方法

#每天備份mysql數據庫(保存最近15天的數據腳本) DATE=$(date?+%Y%m%d) /home/cuixiaohuan/lamp/mysql5/bin/mysqldump?-uuser?-ppassword?need_db?>?/home/cuixiaohuan/bak_sql/mysql_dbxx_$DATE.sql; find?/home/cuixiaohuan/bak_sql/?-mtime?+15?-name?'*.sql'?-exec?rm?-rf?{}?;

drop?databases?need_db; create?databases?need_db;

./mysql?-uroot?-p?--default-character-set=utf8?need_db?<p>推薦學習mysql視頻教程：<a href="https://www.php.cn/course/list/51.html" _src="https://www.php.cn/course/list/51.html">https://www.php.cn/course/list/51.html</a></p>