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?

link|improve this question

80% accept rate
feedback

1 Answer

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

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

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