Archive for May, 2009

Backing Up and Restoring MySQL Databases on your PC

MySQLRecently it became obvious that I really didn’t understand how MySQL stores databases on my PC and although I backup frequently, the files I thought were the databases were only the table structures. Not only that but restoring them was not a matter of simply copying the files back to my hard drive.

I was able to restore the databases, but discovered there are some pro’s & con’s to relying on a typical pc backup.

Here’s what I discovered:

Read the rest of this entry »