V
V
vitalyg2015-04-13 14:16:10
MySQL
vitalyg, 2015-04-13 14:16:10

InnoDB. How to make a backup?

Good day friends!
Interested in the question - how to make a backup of the InnoDB database, so that "transferring" the file, nothing slows down?
And then already 2 or 3 backup slows down ... :(

Answer the question

In order to leave comments, you need to log in

2 answer(s)
K
KorsaR-ZN, 2015-04-13
@vitalyg

And what's the problem with regular mysqldump ?
Dump it with the --single-transaction option to ensure data integrity.
And then just pour this lady into a new server and nothing should slow down, provided the servers have the same configuration.

M
Mirocow, 2015-10-05
@mirocow

I advise you to use my script docs.mirocow.com/doku.php?id=mysql:mysql_utils

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question