mysql Error-1067 damn

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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s