Recently I am getting table corruption issue very often and every time when I check the logs it says "Binlog has bad magic number; It's not a binary log file that can be used by this version of MySQL"
Every single time I've to move binary logs from it's existed location to somewhere else and then only I could start the mysql services. I need to know why it happens.
My database engine type is MyISAM, all the database files are in
.MYD format. I also have InnoDB parameters in my.ini
innodb_flush_log_at_trx_commit=0 innodb_log_files_in_group=2 innodb_log_file_size=256M default_table_type = MYISAM transaction_isolation = REPEATABLE-READ read_rnd_buffer_size = 8M (commented)innodb_data_home_dir=D:/eClinicalWorks/mysql/data innodb_data_file_path = mobiledoc_InnoDb_data1:300M:autoextend innodb_file_per_table innodb_additional_mem_pool_size=8M (commented) configure innodb_buffer_pool_size according to available memory innodb_buffer_pool_size=256M innodb_log_buffer_size=8M (commented)set-variable=key_buffer=16M innodb_data_home_dir=D:\eClinicalWorks\\mysql\\data
- Will keeping InnoDB tags enabled in my.ini create problem in?
- Do you think these tags are creating problem?
Need help ASAP.