For a wordpress blog, MYSQL database is it’s heart. We can restore the wordpress installation, themes plugins or anything easily but once the database is corrupted, it’s not easy to go well with your blog.

I had faced the server crash many times and also due to some problems at server side, my DB was filled with spams and lot of other unnecessary categories and tags. What you can do is to restore the website to previous state. If you’re a heavy blogger, it’s better to keep the backup everyday or otherwise at least once in a week.

Now I’m talking about the backing up the wordpress blog DB easily. Almost all hosting providers are having phpAdmin enabled through webpage to control the database but this is not really easy.

Previously MySQL tool was available in MYSQL website but I was suprised once I format my machine and tried to download the same application again. MySQL provides a better tool called MySQL Workbench for controlling your database. It’s not only a backup tool, but it has other features like server administration, scripting console etc.

Just download MySQL Workbench from MySQL Website and specify your connection strings (servername, username and password) in the “New Server Instance” option.

Finally do your backup through Manage Import/Export. Sorry I could not find any option to automate the backup. Share if you find any options