Geeklog Forums

mysql> describe hn_userinfo;
ERROR 1033 (HY000): Incorrect information in file: './zorreros09/hn_userinfo.frm'


Howto solved this error.

:helpme:

My backup is very old

I can not see the users from geeklog, or information from them. But if they can log into the site.

also allows me to create a backup of the database from geeklog, only creates this trash file.

geeklog_db_backup_2010_02_08_16_56_46.sql 744 Bytes

Try repairing the table - phpMyAdmin (if you have that) has an option for that.

bye, Dirk

phpMyAdmin is not installed in my server, any other option?

Can you run SQL requests from the command line?

Muchas gracias Dirk!!

Thanks Dirk!!

I run REPAIR TABLE hn_userinfo; but the problem was not solved.

What else can I do?


mysql> REPAIR TABLE hn_userinfo;

+------------------------+--------+----------+---------------------------------------------------------------+

| Table | Op | Msg_type | Msg_text |

+------------------------+--------+----------+---------------------------------------------------------------+

| zorreros09.hn_userinfo | repair | Error | Incorrect information in file: './zorreros09/hn_userinfo.frm' |

| zorreros09.hn_userinfo | repair | error | Corrupt |

+------------------------+--------+----------+---------------------------------------------------------------+

2 rows in set (3.06 sec)

Hmm. Did you try Google?

The actual problem seems to have something to do with InnoDB (are you using InnoDB tables?).

I also found this quote:

Did you transfer these files from another machine? And MySQL on the new machine doesn't have support for InnoDB?

In any case, it looks like the database as such isn't defective, but something in your (MySQL) server setup is wrong ...

bye, Dirk

I go to search in google.

Thanks Dirk!!