mysql show databases not showing databases that are in /opt/bitnami/mysql/data directory
- by hgolov
and thank you for taking the time to look at my question.
I have an ebs-backed ec2 ubuntu server which is running but unreachable.
** There are very stupidly no recent backups **
I made a snapshot of the block, created a volume, spun up a new instance, attached the new volume. I see all the data from my site in the /opt/bitnami/mysql/data directory, but when I go into the mysql console, it shows only information_schema and test when I type show databases;
How can I 'point' mysql to the correct folder?
Thank you!