Hi Paul,

I tried entering 'REPAIR Sample_Users_Sessions' and I got an error message.

Error

MySQL said: You have an error in your SQL syntax near 'Sample_Users_Sessions' at line 1.

Query: REPAIR Sample_Users_Sessions

I even tried entering a semi-colon at the end, but I still get an error. Also, I tried this at the command prompt and through the mysql monitor.

-----------

when I type in 'use dbman' at the sql prompt I get the following message:

mysql> use dbman
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Didn't find any fields in table 'Sample_Users_Sessions'
Database changed
mysql>

Also, I'm getting a new error message now:

GT::Session::SQL (14013): Failed to execute query: 'SELECT * FROM Sample_Users_Sessions WHERE ( session_id = ? AND session_date > ? ) ' Reason: Can't open file: 'Sample_Users_Sessions.MYD'. (errno: 145) at /auto/cweb0/www-home/virtual/wwwin-gsbu/cgi/seg/dbman_SQL/admin/Dbsql/Authenticate.pm line 106.

What should I do now?

BTW, I tried isamchk..but it doesn't do anything..is something suppose to get printed out?

mysql> use dbman
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Didn't find any fields in table 'Sample_Users_Sessions'
Database changed
mysql> isamchk
-> isamchk
-> myisamchk -r customerCases
-> myisamchk -r customerCases;
ERROR 1064: You have an error in your SQL syntax near 'isamchk
isamchk
myisamchk -r customerCases
myisamchk -r customerCases' at line 1
mysql> myisamchk -r customerCases
-> myisamchk -r customerCases
-> myisamchk
->


Reena