Not the answer you need?
Register and ask your own question!

How to restore form A Machine to B Machine

pontospontos Current User Role Contributor

Hi,everyone I have a question when I worked on my project.

I backup my database and create the folder by name like "20201021" on Machine A,

and I copy this folder to Machine B then start restore by "20201021".it works!

but when I "service mysqld start " mysql can't start.

I already chown -R mysql: /var/lib/mysql.

my step:

  • xtrabackup --backup \..\=>create folder "20201021" on Machine A
  • switch to Machine B and Copy "20201021" to this Machine
  • service mysqld stop
  • xtrabackup --user=root --password=123--prepare --target-dir= /20201021
  • Complete OK
  • xtrabackup --prepare --apply-log-only --target-dir=/20201021
  • Complete OK
  • Clear /var/lib/mysql on Machine B
  • xtrabackup --user=root --password=root --copy-back --target-dir=/20201021
  • Complete OK
  • chown -R mysql: /var/lib/mysql
  • service mysqld start
  • Service Start Failed

Can anyone help me? Thank you!😭


  • pontospontos Current User Role Contributor

    Find the solution!

    just my Machine A and Machine B different version!


Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.