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
default_table_type = MYISAM
transaction_isolation = REPEATABLE-READ
read_rnd_buffer_size = 8M
innodb_data_file_path = mobiledoc_InnoDb_data1:300M:autoextend
(commented) configure innodb_buffer_pool_size according to available memory
- Will keeping InnoDB tags enabled in my.ini create problem in?
- Do you think these tags are creating problem?
Need help ASAP.