I have a redhat linux server.
yum update mysql and it worked fine.
The problem is that when I went to phpMyAdmin all of the databases were deleted.
So I used "import" to import the database which I backed up before the process, but in the middle I got an error saying "primary key duplication" (though I could not find it in the file).
phpMyAdmin listed all tables created until that point. When I used
SELECT * FROM table_which_caused_error query, I got all rows even though this table wasn't listed in the tables list. However, when I tried to run "DROP TABLE table_which_caused_error" I got an error saying "table does not exist".
What can be wrong??