I have a new Ubuntu Micro instance on Amazon EC2. The default ami-8cfa58e5.

I have made a backup of an older MySQL database by snapshotting the volume the data is stored on. I now need to recover from that backup. When I install mysql using: sudo apt-get install mysql-server I get the latest version 5.5. When I then go through and mount the drives per this document: http://aws.amazon.com/articles/1663?_encoding=UTF8&jiveRedirect=1

Everything works ok, but MySQL will not start. I think this may be because the backed up instance is using mysql 5.0.75. I'm not an expert on Linux, how can I install Mysql 5.0.75 to test if that is the cause of my problem?

  • What do your logs say - check /var/log/mysql/error.log and add any relevant information to your question. – user9517 Jul 27 '12 at 7:00
  • There doesn't appear to be an error.log. I see mysql.err and mysql.log but both are empty. – Joshua Jul 27 '12 at 7:16
  • I was able to get mysql 5.5 to open the 5.0.75 database file by removing the default character set from my.cnf – Joshua Jul 27 '12 at 17:37

You can install a previous version of a package in Ubuntu using apt-get as follows

sudo apt-get install foo_package=version

but for for ami-8cfa58e5 (Ubuntu 12.04 Precise) the version you want to test was never packaged, the oldest release from mysql-server for 12.04 is mysql-server 5.1.58-1ubuntu1 and can be installed with

sudo apt-get install mysql-server=5.1.58

To get 5.0.75 you would need to use and older Amazon EC2 image.

| improve this answer | |

If you feel a little adventurous, I have a link to the Source Code of MySQL 5.0.75

Courtesy of SkySQL : http://downloads.skysql.com/archive/index/p/mysql/v/5.0.75

Download the Source Code to Amazon EC2 and run make installation

Please let us know if this helped

| improve this answer | |

It seems an permission issue , please make sure you have correct permission and correct owner setup for your Mysql Data directory.

  chown mysql:mysql /PathtoMysqldatadirectory
| improve this answer | |

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.