MySql is not picking up changes to my.cnf file on a custom Ubuntu AMI. How do I fix this?

by

I created an AMI from my running EC2 Ubuntu instance. I then brought it up, and MySql is not running the same way on this copied instance.

1) Changes to my my.cnf file are not getting picked up.

2) I am unable to query my database as it gives me the following error:

ERROR 1286 (42000): Unknown table engine 'InnoDB'

I guess MySql is not configured correctly? I’m new to MySql, so can you tell me what I’m doing wrong please?

Thanks in advance.

Answer

Check /var/log/syslog for any errors that occurred during MySQL’s startup. It may be that your /etc/mysql/my.cnf file includes a skip-innodb statement, which would disable InnoDB tables.

Attribution
Source : Link , Question Author : cone , Answer Author : daemonofchaos

Leave a Comment