MySQL Like for Like - 100% accurate Backup/ Restore
1
vote
1
answer
45
views
I've struggled to find the answer to get a perfect backup and restore for MySQL.
I need to do performance test on a database so I need to make sure that the page files, indexes, fragmentation - the whole things is like for like - 100% preserved.
I tried copying the raw files (.frm, .ibd, .trn, .myi etc) files across but get
Table '' doesn't exist in engine.
I also tried dBForge to copy the database which worked, but after looking at the fragmentation levels I can see differences, so I think this isn't a like for like (although I'm copying from production so perhaps I saw some anomaly there).
mysqldump - Does this do it?
Asked by Adam
(113 rep)
Mar 31, 2021, 07:43 AM
Last activity: Mar 31, 2021, 02:45 PM
Last activity: Mar 31, 2021, 02:45 PM