mySQL acts weird

[oldunis]

Hello,

I've got a problem with mysql. I've got an invision power board forum. When i delete all my mysql files manually (/var/lib/mysql), my forum continues to work without the files, i must restart mysql for it to see that the tables doesnt exist.

Thks in advance!

 

[ballyn]

Um... yeah. Deleting those files is not the best way to drop databases from mysql. Mysql has an internal table containing permissions, etc. that you probably don't really want to delete.

I would suggest using phpmyadmin or the mysql command line to drop the databases instead.

 

[oldunis]

Ya i know, but i'm not deleting the mysql database, neither the test one...

 

[jmstacey]

If you delete a database or table file information directly without going through MySQL, it will not know anything about it until it checks database files for errors. Thats why you must restart MySQL to get it to detect the change, which it corrects noticing that there is an error.

(My guess)