943,811 Members | Top Members by Rank

Ad:
  • MySQL Discussion Thread
  • Unsolved
  • Views: 4526
  • MySQL RSS
Jul 30th, 2008
0

MySQL Incorrect information in file

Expand Post »
On of my database stooped working.

Quote ...
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>
It seems some problem with innodb.

My variables are

Quote ...
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>
Anyone know how to fix the problem ?

Thanks,

Yujin
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
netfreehost is offline Offline
12 posts
since Nov 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MySQL Forum Timeline: need help explaining this line
Next Thread in MySQL Forum Timeline: can i use empty resultset object for checking condition





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC