1
davetbo
xoops database ERD/documentation?
  • 2008/3/8 15:22

  • davetbo

  • Just popping in

  • Posts: 4

  • Since: 2008/3/8 1


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

2
dbman
Re: xoops database ERD/documentation?
  • 2008/3/8 15:53

  • dbman

  • Friend of XOOPS

  • Posts: 172

  • Since: 2005/4/28


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.

Login

Who's Online

221 user(s) are online (149 user(s) are browsing Support Forums)


Members: 0


Guests: 221


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Mar 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits