mysql errors..?!

[Jacko]

i get this on any page:

Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/realmods/public_html/forum/admin/db_mysql.php on line 86


=+=+=+=+=+=+=+=+

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT COUNT(*) AS users,MAX(userid) AS max FROM user WHERE posts=0
mysql error: Got error 127 from table handler

mysql error number: 1030

Date: Thursday 24th of April 2003 12:48:40 PM
Script: http://www.realmods.net/forum/forum/
Referer:

=+=+=+=+=+=+=+=+

havnt changed anything for about 24 hours and its been working all day??

any ideas??

i have checked my Db and all seems fine and file permissions are ok.

[Jacko]

anyone?? i dont want to resort to a backup as i havnt done one for about 2/3 weeks.

[Jacko]

now i just get:

There seems to have been a slight problem with the RealMods.net database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.
:(

[Erwin]

Your user table is corrupted. Repair it via phpmyadmin or upload repair.php from the uploads directory of the vB zip file, and run it.

[Erwin]

Also, in future, backup at least daily. :)

[Jacko]

i noticed the user tabe said:

user l Browse l Select l Insert l Properties l Drop l Empty l in use

thought in use doesnt sound right.!

whats the best way to backup the db??

and where does the repair.php file get uploaded to??

[Jacko]

everytime i try to run the repair script it gives me:

There seems to have been a slight problem with the RealMods.net database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

this is from both forum directory and admin folder.?!

[Erwin]

Run this query:

REPAIR TABLE user;

[Jacko]

Erwin you da man :)

what could of caused this error and whats the easiest way to backup my DB??