Thursday, April 17, 2014

MySQL not starting up

130502 10:47:03 InnoDB: The InnoDB memory heap is disabled 
130502 10:47:03 InnoDB: Mutexes and rw_locks use GCC atomic builtins 
130502 10:47:03 InnoDB: Compressed tables use zlib 1.2.3 
130502 10:47:03 InnoDB: Initializing buffer pool, size = 128.0M 
130502 10:47:03 InnoDB: Completed initialization of buffer pool 
130502 10:47:03 InnoDB: highest supported file format is Barracuda. 
130502 10:47:03  InnoDB: Waiting for the background threads to start 
130502 10:47:04 InnoDB: 1.1.8 started; log sequence number 1438711997 
/Applications/AMPPS/mysql/bin/mysqld: File './mysql-bin.000108' not found (Errcode: 2) 
130502 10:47:04 [ERROR] Failed to open log (file './mysql-bin.000108', errno 2) 
130502 10:47:04 [ERROR] Could not open log file 
130502 10:47:04 [ERROR] Can't init tc log 
130502 10:47:04 [ERROR] Aborting 

130502 10:47:04  InnoDB: Starting shutdown... 
130502 10:47:05  InnoDB: Shutdown completed; log sequence number 1438711997 
130502 10:47:05 [Note] /Applications/AMPPS/mysql/bin/mysqld: Shutdown complete 







Solution:



delete /Applications/AMPPS/var/mysql-bin.index



or 



Delete all the files from /Applications/AMPPS/var/ like mysql-bin.*,  mysql-bin.index, ib*, etc and try starting the mysql server. DONT REMOVE ANY FOLDER.