1

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?

1
  • What does "chroot to broken ubuntu server mean"? Jul 20, 2018 at 6:34

1 Answer 1

2

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

2
  • If the OP tries this, very important that the SQL server isn't running!
    – ivanivan
    Jul 19, 2018 at 14:37
  • @ivanivan, yes you are right. I thought anyway the mysql or the server is not running and the op cant login. Otherwise mysqldump is the best option.
    – Diamond
    Jul 19, 2018 at 14:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.