MySQL Innodb 快速回復及搬移的方法

[admin]

How can I move a database from one server to another?
http://dba.stackexchange.com/questions/174/how-can-i-move-a-database-from-one-server-to-another

Fastest way to move a database from one server to another
http://dba.stackexchange.com/questions/19219/fastest-way-to-move-a-database-from-one-server-to-another

How to recover the innodb when mysql data dir moved from one system to another system?
http://dba.stackexchange.com/questions/15290/how-to-recover-the-innodb-when-mysql-data-dir-moved-from-one-system-to-another-s

Moving InnoDB Table Between Servers
https://avdeo.com/2015/02/19/moving-innodb-table-between-servers/

如舊有的MySQL Server 主機已完全不能啟動, 可以用下列的方法快速還原 :
重新安裝一台全新的MySQL Server, 新MySQL Server 的服務必須停止, 將舊MySQL Server 的整個Data Folder 取代新MySQL Server 的 Data Folder, 注意設定Data Folder 的權限, 如my.ini 或 my.cnf 有特別參數設定, 也需要一併Copy 入新的MySQL Server 主機內, 然後重新啟動新的MySQL Server 便可 !