Dan’s Drivelings

I’ve spent several hours this past weekend working on a project for a client that uses a MySQL database backend. It involves converting thousands of records from XML files exported from the legacy data system. One of the things that’s been bugging me is the process that I have to go to every time I make changes to the the database or import more data into my local development copy in order to get those changes/data up to the staging server.

I am using a tool called EMS SQL Manager to manage the MySQL databases and the only way I have found to export data is to dump the entire database then open the .sql file in a text editor (but DEFINITELY not Notepad as the file is 500+ MB) and strip out the tables/data that I don’t want to update.

Read more…