| | |
MySQL Incorrect information in file
Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
•
•
Join Date: Nov 2005
Posts: 12
Reputation:
Solved Threads: 0
On of my database stooped working.
It seems some problem with innodb.
My variables are
Anyone know how to fix the problem ?
Thanks,
Yujin
•
•
•
•
mysql> check table invoice;
+-------------------------------+-------+----------+----------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-------------------------------+-------+----------+----------------------------------------------------------------------+
| billing_db.invoice | check | Error | Incorrect information in file: './billing_db/invoice.frm' |
| billing_db.invoice | check | error | Corrupt |
+-------------------------------+-------+----------+----------------------------------------------------------------------+
2 rows in set (0.00 sec)
mysql> repair table invoice;
+-------------------------------+--------+----------+----------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-------------------------------+--------+----------+----------------------------------------------------------------------+
| billing_db.invoice | repair | Error | Incorrect information in file: './billing_db/invoice.frm' |
| billing_db.invoice | repair | error | Corrupt |
+-------------------------------+--------+----------+----------------------------------------------------------------------+
2 rows in set (0.01 sec)
mysql>
My variables are
•
•
•
•
mysql> show variables like '%innodb%';
+---------------------------------+------------------------+
| Variable_name | Value |
+---------------------------------+------------------------+
| have_innodb | DISABLED |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_autoextend_increment | 8 |
| innodb_buffer_pool_awe_mem_mb | 0 |
| innodb_buffer_pool_size | 4294967296 |
| innodb_checksums | ON |
| innodb_commit_concurrency | 0 |
| innodb_concurrency_tickets | 500 |
| innodb_data_file_path | ibdata1:10M:autoextend |
| innodb_data_home_dir | |
| innodb_doublewrite | ON |
| innodb_fast_shutdown | 1 |
| innodb_file_io_threads | 4 |
| innodb_file_per_table | OFF |
| innodb_flush_log_at_trx_commit | 2 |
| innodb_flush_method | |
| innodb_force_recovery | 0 |
| innodb_lock_wait_timeout | 50 |
| innodb_locks_unsafe_for_binlog | OFF |
| innodb_log_arch_dir | |
| innodb_log_archive | OFF |
| innodb_log_buffer_size | 1048576 |
| innodb_log_file_size | 268435456 |
| innodb_log_files_in_group | 2 |
| innodb_log_group_home_dir | ./ |
| innodb_max_dirty_pages_pct | 90 |
| innodb_max_purge_lag | 0 |
| innodb_mirrored_log_groups | 1 |
| innodb_open_files | 300 |
| innodb_rollback_on_timeout | OFF |
| innodb_support_xa | ON |
| innodb_sync_spin_loops | 20 |
| innodb_table_locks | ON |
| innodb_thread_concurrency | 8 |
| innodb_thread_sleep_delay | 10000 |
+---------------------------------+------------------------+
35 rows in set (0.00 sec)
mysql>
Thanks,
Yujin
![]() |
Similar Threads
Other Threads in the MySQL Forum
- Previous Thread: need help explaining this line
- Next Thread: can i use empty resultset object for checking condition
| Thread Tools | Search this Thread |
Tag cloud for MySQL
1 agplv3 alfresco api artisticlicense aws bizspark breathalyzer camparingtocolumns cmg communityjournalism contentmanagement contractors copyright count court data database design developer development distinct drupal dui ec2 email enter enterprise error eudora facebook form foss gnu government gpl greenit groklaw hiring hyperic images innerjoins insert ip joebrockmeier join journalism keyword keywords kickfire law legal license licensing maintenance managing mariadb matchingcolumns metron micromanage microsoft microsoftexchange montywidenius mozilla multiple music mysql mysqlcolumnupdating mysqldatetimeordermax() mysqlindex mysqlinternalqueries mysqlquery mysqlsearch news open-xchange opendatabasealliance opengovernment opensource oracle penelope php query referencedesign reorderingcolumns resultset saas search select sharepoint simpledb sourcecode spotify sql sugarcrm syntax techsupport thunderbird transparency update virtualization





