0

I had an Ubuntu image that was corrupted and will not longer boot (hosted with EC2). This is just a problem with the OS booting and not a problem wit the actual EBS volume. So I have mounted the EBS volume on another EC2 instance which is working. How can I access the MySQL database on the EBS volume I have mounted so I can copy the data over to the MySQL instance running on the working box?

2

set the data directory in my.cnf to the directory on EBS and restart mysql. Once you see the data do a mysqldump switch the data directory back restart mysql.. then do the import

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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