getButterfly Logo getButterfly code wrangling since 2005

I just ran into a cheap ebook sold somewhere on the Internet. It was all about backup. It was a routine job and it was done using free scripts, so I do not understand why the payment. Remember I told you not to buy ebooks from the Internet? And I mean ebooks that claim to teach you high-rated secrets.

Here’s 2 ways to backup your database:

1. The cPanel way. cPanel is widely used by hosting companies as a backend for their clients. It consists of a control panel (hence the name) for email, subdomains, backups, installations, databases and many, many more. This tutorial is made for beginners, so we will not delve into the secrets of phpMyAdmin.

Go to the Backups section.

Notice the Download a MySQL Database Backup section. You may have only one database or more. Select the one you’re interested in and download it. The extension is .sql.gz, a heavily compressed text archive. That is all. Store the file somewhere safe, and repeat these steps monthly (or whenever you think it’s necessary). Some web site owners do it every day, even every hour.

2. If you are using a blog engine (WordPress in our case), you should be aware that there are a number of plug-ins to help you backup your database. These plug-ins can backup your tables either automatically (every n hours/days/weeks), or on-demand. I, for one prefer the former for my daily updated blogs, and the latter for my passive blogs. I do a database backup whenever I update them.

That’s it. No need for cheap ebooks to learn you this easy stuff.

Subscribe to getButterfly Blog

Once a week or so we send an email with our best content. We never bug you, we just send you our latest piece of content.

If you found any value in this post, agree, disagree, or have anything to add - please do. I use comments as my #1 signal for what to write about. Read our comment policy before commenting! Comments such as "Thank you!", "Awesome!", "You're the man!" are either marked as spam or stripped from URL.

6 thoughts on “How To Backup Your Database

Leave a reply