MySQL restore bd from directory copy. Hello, I recently lost the external storage where my MySQL data directory was located, but I have copied the entire data directory in another location, the problem is that I copied it without stopping mysql before, I would like to know how to get mysql from the directory data where information is saved before the crash

1 Answer 1


Sorry, you are probably SOL.

Case 1: Copying the disk while MySQL is actively writing data. Very likely to be in an inconsistent state -- some things written to disk and copied; some not.

Case 2: MySQL up during the copy, but not actively writing (UPDATE, INSERT, etc). This might work since it is identical to a power failure.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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