Hello all,

I am trying to write a script to migrate from my XOOPS dev box to staging to production. I have figured out the part where I dump the database, tar the /var/www/html/xoops dir, move those to the new server, untar, mysql, fix mainfile.php.

HOWEVER,...=) This would overwrite all the data in the production site. Obviously you don't want that. Therefore, I think to regularly do site updates like this I need a better understanding of the database structure and ONLY update/insert certain data from dev to stg to prod.

This struck me as a XOOPS development issue and not a general user issue, so I apologize in advance if I put this in the wrong forum. However, I don't think I did because the developers are really the only ones who will know XOOPS this deeply.

Best,
Dave

Use insert-select statements to migrate your new data from one database to the other.

http://dev.mysql.com/doc/refman/5.0/en/insert-select.html

The data structure is pretty easy to see if you use a client like Toad for MySQL, MySQL Query Browser, Navicat, etc.