Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I want to move MySQL database installed on my "Windows 7 Enterprise" PC to an external hard drive which is PGP 2.0 encrypted.

Could you please suggest how to do this?

share|improve this question
1  
Stop mysql, copy the data directory to the hard drive, change the data directory location in my.cnf, restart mysql. Make sure to make plans for restarts, entering the password to un-encrypt the drive.. –  NickW Jan 7 at 15:42
    
You should be able to simply migrate the physical location of the data using the normal means to do so. The drive will have to be readable state, by the operating system, before MySQL itself isstarted otherwise you will get an error. –  Ramhound Jan 7 at 15:44
    
Thanks for your comments. I am now able to move my database. Extremely helpful. –  Ranchoddas shamaldas chanchad Jan 9 at 14:50

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.