• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 399
  • Last Modified:

resynchronize tables between two db mysql mariadb


I have to resynchronize tables between  two db mysql mariadb innodb. The tables contain million rows.
How can do it because it can take several hours?
Is it possible to do a cold backup and copy the file tables?

1 Solution
If you were using innodb_file_per_table, and MySQL 5.6, you could copy the .ibd file from one server to another and import the tablespace. I don't know if mariadb has implemented that.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now