大网数据广告活动
服务器运维问答

How to backup and restore mysql without mysqldump

· 52CE 我爱测

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?

问题原文

原帖链接 · 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://www.digitalocean.com/community/tutorials/how-to-move-a-mysql-data-directory-to-a-new-location-on-ubuntu-16-04

https://askubuntu.com/questions/137424/how-do-i-move-the-mysql-data-directory

摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。

资料来源与适用范围

资料来源
Server Fault
适用范围
以原帖系统、软件版本与发布日期为准(2018-07-19)
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY-SA 4.0

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。