May, 2008

Having to move data from one location to another, or one drive to another in a database can be quite a hair-raising expericene. With MySql, it’s really not that bad. I have a database on a Window 2003 server, but the steps for Linux and Mac OSX are very similar.

But just to be sure that we won’t be shooting ourselves in the foot, lets make a backup of our databases. Whichever way you choose to do it is your call… ( mysqldump, using a 3rd party tool to create a csv files of your tables…etc)

First, lets shutdown the database:

I am going to be talking about something that is very near and dear to my heart. I didn’t think I would be revealing this to my blog audience so soon. I try to closely guard it because I’m not 100% proud of it. It is something that isn’t fully under my control, so bare with me while you read this… and please don’t poke fun.