mysqlcheck

//Check all databases and password is required after this command mysqlcheck --all-databases -uroot -p //Check specific database and don't need to e

Continue Reading

MySQL備份

完整備份:(t為資料庫名)Mysql -uroot -pPassword  t -e "FLUSH TABLES";  // 關閉所有開啟的表, 把記憶體中的快取寫入

Continue Reading