You can easily put your home based business in jeopdardy.

How? You are merrily creating niche sites and blogs when the unthinkable happens…

You mistakenly delete a MySQL Database for a blog and you LOSE THE LOT!!!

Now what do you do? Don’t go looking for the undelete button because there ain’t one.

So why am I writing about this?

Because it happened to a good friend of mine!

Last week she lost her entire blog.

And she found out when talking to others, it has happened to them!

IN SHORT: There is no un-delete button so you need to back up your MySQL Databases or rebuild your entire blog from scratch.

Now fortunately for her she had all the basic ‘content’ on her PC because she always composes her posts and pages in a word processor first before posting them into her blog. She uses MSWord to spell and grammar check her work

However, she still needed to “rebuild” her work-from-home blog from scratch by creating a new database, setting up WordPress and re-posting all her posts and pages.

Despite all this all was not lost… she used the experience to consolidate her knowledge of creating a WordPress Blog and the NZPCS Million Dollar Program Stage One. She also took the opportunity to learn how to backup her MySQL databases.

To save you all the pain of her last week my friend has agreed to share these hints with me and those reading this blog, so you can learn from her mistake and hopefully not make it or in the very least recover quickly from it.

This is what she has written.

“Naming your MySQL Databases”

“As we are creating a lot of niche blogs I find it easier to track them by giving them the same basic subject name as my Blog.

For example: My First Guitar Blog = myfirstguitar (database name)

Quite logical when you think about it but when you are new to all of this you can find yourself completely in the dark.

Backing Up Your MySQL Databases

This is imperative! I suggest you do it at least once a week especially if you are posting frequently or using ‘Auto Blog” or “RSS Feeds”

  1. Create a ‘MySQL Databases Backup’ folder on your PC
  2. Go to your cPanel X
  3. Click on Backups icon
  4. Look for ‘Download a MySQL Database Backup’
  5. Underneath you will find your MySQL database name in link form
  6. Right click on link and select “save link” or “save target as”
  7. Save zip file in ‘MySQL Databases Backup’ folder on your PC
  8. Do this for all your MySQL Databases
  9. When you next backup you will be asked if you want to overwrite file – SAY YES!

That’s it. Not as hard as I first thought it might be.

And if you have a catastrophic MySQL failure you can upload the back up file using the “Restore a MySQL Database” facility on the Backups page.

If you back up regularly the most you will lose is a couple of posts.”

OK – Well that’s it from me … time to go backup MySQL Database.


Be Sociable, Share!