Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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?

share|improve this question

1 Answer 1

up vote 2 down vote accepted

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

share|improve this answer

Your Answer

 
discard

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

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