Database disappeared?

[kirtchristensen]

My database appears to have vanished...

When I log into LMP, it shows 0 subscribers, and 0 sent messages, etc.

When I check on the DB in PHPmyadmin, the DB is there (I can look at lm_saved and it shows me all my past broadcast messages), but:

lm_sendp gives a "can't open file error" error:144
lm_sent gives a "can't open file error" error:144
lm_users gives a "can't open file error" error:144

On my last broadcast, it showed that the message went out, but I didn't get a single "spam verification" or "out of town" auto-response, so it coudln't have...

I'm beginning to think I have my 1and1 server setup screwy or something.

Kirt Christensen

[DW]

Looks like some database corruption - you should be able to recover nearly all, if not all, of your data.

Using PhpMyAdmin attempt to REPAIR all the tables.  You can do this with the checkboxes beside and dropdown underneath the table listing.

If normal repair fails, try manually repairing the table with this command:

Code: [Select]

REPAIR TABLE <table> USE_FRM
Regards