also, the databases are not showing up at all when they are called by apps on the server
Maybe that's not a problem if the applications in question use the old credentials/privileges etc
I did a mysql show databases from terminal and the database in question is not showing
how screwed am I? I've got a backup from 2 or three weeks ago
This is a bit scary. It should show the available databases. Take a look at /usr/local/mysql/data (if you still use the same mysql from this post
) to see if the other databases are there.
What you can try is to stop mysqld, and from the backup you have copy the mysql database in the directory where the databases are stored (I guess it's /usr/local/mysql/data) overwriting the new one. Make a backup first or better you can move it to somewhere else:
mv /usr/local/mysql/data/mysql /usr/local/mysql/data/mysql.old
So you'll have the previous mysql db with the previous users/credentials/privileges etc
Start mysqld and see if it works
there is a file called cookbooks which is the database sitting in /usr/local/www/apache22/data/phpmyadmin -- this may be the info =--- how do I get it to reload?
it contains the following
I don't know what this file is and how it's used by phpmyadmin.