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…
The Thanksgiving holiday is quickly coming to an end. I’ll have to say that working from home the 3 days before Thanksgiving was a very nice break after travelling for 9 straight weeks and having a 4-day weekend where I (almost) completely unplugged from work was even better.
The last few weeks before Thanksgiving have been pretty wild (as the next couple probably will be as well). I’ve been working on two different projects that deal extensively with XML (one consuming web services that return XML and the other using XML to import thousands of records into a database from a legacy system). I can definitely see where the hype of a few years ago is justified in allowing many different systems to exchange data. However, there are times when the people developing the XML seriously get too complicated in what they’re trying to do.
I’ve also been playing with the tag and aggregate queries from MySQL to summarize table contents for a client. The things that you can do with the charting components are really cool. I’m looking forward to moving some of these into small Flex apps.
Ok…enough for today. I promise I’ll try to be better in posting in the coming weeks.
