MySQL-incorrect information in file frm
-
Hi, In my server the MySQL database is not started. Because, the database was corrupted since the table size is large. So i resolved this issue and started the MySQL server by extending the innodb table space. The below line is i added in my.cnf innodb_data_file_path = ibdata1:100M:autoextend:max:500M;ibdata2:100M:autoextend The MySQL is started and database and tables are there. The problem is when i select any table data, i got the error as "incorrect information in file frm". How can we fix this issue?. Any idea pls. Regards, Periyasamy.R
-
Hi, In my server the MySQL database is not started. Because, the database was corrupted since the table size is large. So i resolved this issue and started the MySQL server by extending the innodb table space. The below line is i added in my.cnf innodb_data_file_path = ibdata1:100M:autoextend:max:500M;ibdata2:100M:autoextend The MySQL is started and database and tables are there. The problem is when i select any table data, i got the error as "incorrect information in file frm". How can we fix this issue?. Any idea pls. Regards, Periyasamy.R
restore your backup. :)
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.
-
restore your backup. :)
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.
Hi Luc pattyn, Thanks for your reply. Instead of restoring database Is there any other way by changing configuration in "my.cnf" file?. Thanks, Periyasamy.R