Backing up your mySql databases using MySqlDumper

Backing up your mySql databases using MySqlDumper

MySqlDumper

I shouldn’t have to tell you that backups for your data is crucial, especially your mySql databases. They can power anything from your eCommerce store to your WordPress installation. There are numerous ways to automate this process, but I recently came across one that I really like. Introducing MySqlDumper, a free, web-based mySql backup utility written in PHP.

Installation and Configuration

Installation is straight forward. Just extract and copy the downloaded zip file onto your webserver. The first time you hit the site, you will be greeted with a wizard installation, and everything is pretty basic from there.

One thing to note is that you will need to give mySqlDumper mySql credentials that have at least read access to all of your databases. This is the username that will power all the backups so it needs to be able to see all your mySQL databases.

I setup nightly backups using a scheduled cron job in cPanel, in which mySqlDumper was kind enough to generate the syntax for.  You can even configure it to email you with a full log of your backup to make sure everything is successful.

Even configure it to delete backups past a certain time frame. For example, I keep 2 weeks worth of old databases, and once that threshold is hit, older databases will be automatically removed, saving you disk space.

Restoring Databases

A cool feature of mySqlDumper is that it allows you to quickly choose a particular backup of a database and restore it with just a few clicks.

Price

Free…enough said!

Conclusion

I have been using MySqlDumper for quite a few months now, and I love it. It’s easy to use, the web interface is straight forward and easy to understand, and I have not had any issues yet.  It’s made automated mySql backups nice and easy.

If you have any questions on it, and want more info, let me know!

Share Your Thoughts!

Testimonials

What My Clients Say

Karin - Hope and Future

Brent has always been very prompt and generally exceeds our expectations with his work. His maintenance fee is very reasonable. I strongly recommend him!  We get many compliments on our beautiful web site!

Dan

I contacted Krueger Web Design and Brent did everything.  He setup a test site with the changes so we could verify everything was correct before we transferred from my old hosting provider.  During the setup and conversion Brent was extremely professional and responsive. He responded to any issues the same day.

Dan Kaufman
Emily - GFCLT

We've had a great experience working with Krueger Web Design. Prompt responses, great ideas, effective work... all at a reasonable price! This was the perfect fit for our organization.

Mahmud - ACMC

I would love to recommend you to anyone! You have been very helpful when we needed you the most.

Brian - SEMNIC

Working with Krueger Web Design was effortless. Communicating what I wanted for the website and the results that I saw were identical. The customer service was always prompt and I am completely satisfied with the product.

Zach - Stadium Club

Exactly what I wanted! Fast turnaround time and very affordable. Answered all of our questions quickly and made adjustments promptly. Very easy to work with and puts everything into terminology that even I can understand!

Contact Krueger Web Design

Have a question for me? Need an estimate on some work? You can email me at brent@kruegerwebdesign.com or drop me a line using the button below:

Copyright © 2017 Krueger Web Design - All rights reserved
Web Design in Madison, WI