My development server is running WAMP5 which is using Mysql5. However the production server which is owned by a website hosting company is running Mysql4. What I want to do is build up my database in my development server (Mysql5) and update the database my production server (Mysql4.1.21). How should I do this?
You can use the MYSQL Administrator to run backups and restores. The cool part about it is that the restore will just append to what is already there, so you can backup the stuff from the MYSQL5 and restore it the MYSQL4.