[SOLVED] Update online database from development environment

[kkreitz]

I have an XAMPP development environment on my computer and find it much faster to work on then online. I have a client that would like for me to update the online CMS once a week as I build out their site.

I can move my CMS from my platform to the online platform fairly easily the first time. However updating the database on a weekly basis has been a bit of a headache, since the only way I have found it to work cleanly for me is to do an install/upgrade each time linking to a newly named and imported db. I tried exporting and importing then setting the config.php db settings for the new imported db and it did not work properly.

Does someone have an easier way for me to be able to do this?

Solution:

Once I migrated the entire development site to the server online, instead of installing a new CMSMS and moving images and database I got it to work as suggested here:

http://forum.cmsmadesimple.org/viewtopi ... se#p247231

Now each time I update, I simply use phpMyAdmin to export the database from my development environment, delete then add the db using the same name and import with phpMyAdmin.