I have my account hosted on server1. One of my databases (kv_kvdb) is giving some error like
"Warning: Incorrect information in file: './kv_kvdb/kv_access.frm' " .
Please check the url here for error.
This repeats for every query I have in the script with a different file name. I tried to repair db from cpanel, but it throws the same error.
After googleing, I found this url which talks about some permission on tmp directory. or may be a restart of mysqld.
Please fix this database. I don't want to remove and recreate it. It has data of several users of my site. I don't have a recent backup too. Please help.
EDIT: Looks like it has something to do with innodb. myisam tables are fine. After executing SHOW ENGINES, I found this:
PS: Rest of my databases are fine. Only this db has problem somehow.
Last edited by kv on Thu Oct 30, 2008 9:57 am; edited 2 times in total
"Warning: Incorrect information in file: './kv_kvdb/kv_access.frm' " .
Please check the url here for error.
This repeats for every query I have in the script with a different file name. I tried to repair db from cpanel, but it throws the same error.
After googleing, I found this url which talks about some permission on tmp directory. or may be a restart of mysqld.
Please fix this database. I don't want to remove and recreate it. It has data of several users of my site. I don't have a recent backup too. Please help.
EDIT: Looks like it has something to do with innodb. myisam tables are fine. After executing SHOW ENGINES, I found this:
| Quote: |
| InnoDB DISABLED Supports transactions, row-level locking, and fore... |
PS: Rest of my databases are fine. Only this db has problem somehow.
Last edited by kv on Thu Oct 30, 2008 9:57 am; edited 2 times in total
Please enable innodb for some time so I can convert innodb tables to myisam or take a backup. I don't have a backup of this database. Please help!