问题原文
原帖链接 · 1myb · CC BY-SA 4.0
I couldn't chroot to the broken ubuntu server, may i know how can i backup and restore the mysql server without mysqldump? Could it be copy the directory and replace to the new server?
已采纳解答
原帖链接 · Diamond · CC BY-SA 4.0
This is not guaranteed to work but you may try, and I suppose that mysql is not running.
You can copy everything from mysql data folder /var/lib/mysql (this is the default location, check yours) and put it in the new location/server, check config to see datadir location matches, restart services and see if it works.
The configs are under /etc/mysql.
And of course not to forget the file and directory permissions.
Here are two useful links.
https://askubuntu.com/questions/137424/how-do-i-move-the-mysql-data-directory
摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。
