I was receiving this error when trying to drop a database:
ERROR 1010 (HY000): Error dropping database (can't rmdir './redpopdigital@002ecom', errno: 39 "Directory not empty")
So I went into
/var/lib/mysql and just did an
rm -rf. I did not know that this would screw with literally every other database.
Now it seems all of my databases are inaccessible.
I tried this as a troubleshooting step:
ubuntu@blainelafreniere:~$ mysqlcheck --repair blainelafreniere -u root -p Enter password: blainelafreniere.wp_commentmeta Error : Table 'blainelafreniere.wp_commentmeta' doesn't exist in engine status : Operation failed blainelafreniere.wp_comments Error : Table 'blainelafreniere.wp_comments' doesn't exist in engine status : Operation failed blainelafreniere.wp_links Error : Table 'blainelafreniere.wp_links' doesn't exist in engine status : Operation failed
what’s weird is, all of the data appears to be chilling in
/var/lib/mysql… but I can’t access it for some reason?
Is there any hope of recovering the data from
/var/lib/mysql or am I completely screwed?