Picture this, almost 1 AM, almost done with the job. you just wanna get done with it and return home. At this point suddenly you sql server starts giving damn error-1067. How would you feel? after restarting the server, no luck. Ok lets restart the OS, still no luck. Then back to the old but effective solution, google it. finally found the solution. There was some problem with the log file. While i was trying to fix the server my data got corrupted. So after i fix the server i had to re-populate the server with data and start the system. Finally i was done with the system and testing at 3 AM.
solution: delete the logfiles and restart the server.
system: it was a java coded, mysql backed SMS server solution for a renowned TV channel in Bangladesh.
you can get more details on this error in here.