is database corrupt ?

[Marco van Herwaarden]

Well somehow the restored file is corrupted. Maybe because mysqld was still running while restoring the database on filesystem level.

Did you have a look at that mysql.com link? especially the part:

Stop the mysqld server with mysqladmin shutdown, run myisamchk --silent --force */*.MYI from the data directory to check all MyISAM tables, and restart mysqld. This ensures that you are running from a clean state. See Chapter 5, Database Administration.

Mind you i am guessing here, i have no real experience with this error.

But maybe a new restore would be a more secure way to go, if ofcourse the backup itself is not corrupt.

One more to look at: http://forums.mysql.com/read.php?20,...6745#msg-16745

[lasto]

cheers marco you been a great help - at moment am waiting for hosts as they are gonna take a look at it and see about another restore.
If that fails then im hoping my luck will hold out so i can grab the members/email/password etc and just copy them over to a new install and just start afresh and learn from this lesson.

well here whats i was hoping to do and that was take the users from the database and just overwrite the user table in a fresh install but already ran into a problem and that is inside the user table must be excess tables which obviously a fresh install would`nt need and because of this when i go to edits a member in admincp i get a mysql error.