February 8th, 2010

How to Backup a Database


by Bianca Gubalke

How to Backup a Database

As part of our weekly or monthly Security and System Maintenance routine to keep our own websites and/or blogs up and running, we should clean out the overheads and backup the database or databases in our cpanel.

We do the same for our Customers at Web Design Consulting who trust they can relax while the Support & Maintenance Team ensure the Top Performance of their websites and blogs.

How to Backup a Database

How to Clean Overheads in a Database

Due to a number of regular requests coming in, let me show you the quick and easy steps as to How to Clean Overheads in a Database – before you back it up:

1.

Log into your cpanel

2.

Go to “Databases” and here click on “phpMyDatabase”.

3.

On the new window that opens, to the left, you see all your databases in a vertical dropdown, in alphabetical order.

Now simply tick the first of these databases, and, on the table that now opens to the right, you see the “Overheads” to the far right and added up at the bottom of that column. This is the accumulated waste you want to get rid of by optimizing the table. It will clean your blog and make it faster.

What you now do is to tick “Check tables having overhead” (it’s in blue under “sum”) and as a result you will see the corresponding tables getting ticked, so you see exactly where your overheads basically came from.

As a next step you tock the little drop down to the right of “Check tables having overhead” saying “With Selected” and here you select “Optimize Table”.

Now let it do its job! Just wait a moment…

How to Backup a Database

Once it’s done, let’s continue exactly where we are… and I show you How to Backup a Database:

4.

At the top, click on EXPORT.

Don’t touch or change anything here… what you do is…

5.

At the bottom, tick “gzipped” and then on “GO” to the far right.

6.

If you get a popup… select “Save File” and “OK”.

Now this database backup will download to your computer, to a designated folder or your “Downloads”. If you are on Firefox, you will see a note “One active download” to the bottom right of your screen. Call it up and let it do its job.

We tend not to pay too much attention to backups as there’s always sooo much to do… I know!

However, may this little Tutorial help you to rather be safe than sorry.

And besides, if you don’t want to bother with this, remember that you can have backups automatically done for you on our Best Web Hosting Services for just $6 a year – perhaps a smart thing to do; think about it!


Author: Bianca Gubalke, Art, Media, Publishing.

Co-Founder of YORGOO, YCADEMY and Semiomantics.

If you enjoyed reading the above, please consider following future tips and strategies by RSS reader, Email delivery, or Kindle subscription.

Read more...

This entry was posted on Monday, February 8th, 2010 at 2:39 am and is filed under &, Backup, Best, Cleanup, Consulting, Design, Development, Dubli, Dubli Networking Business, Dublicator, Herbert Brown, Herbert Brown jr, Herbert L Brown Jr, Hosting, How, Maintenance, Nestoridis, Overheads, Performance, System, Top, WP, Web, YORGOO, Yorgo, a, and, clean, database, eShop, in, out, security, services, site, support, to. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

You must be logged in to post a comment.