Welcome to Geeklog, Anonymous Sunday, December 22 2024 @ 01:20 am EST
Geeklog Forums
Merging databases
Status: offline
OMAL
Forum User
Regular Poster
Registered: 12/06/17
Posts: 107
Is it possible to merge two databases for the same version of the geeklog?
One is for a dev. site which has upgraded any of plugins for geeklog.
The other is a db used for current production site, that has latest data for users, user-prefs, stories and more.
I plan to upgrade geeklog for the production site so that I will merge the upgraded db with the db that is already upgraded and installed any of necessary latest plugins.
One is for a dev. site which has upgraded any of plugins for geeklog.
The other is a db used for current production site, that has latest data for users, user-prefs, stories and more.
I plan to upgrade geeklog for the production site so that I will merge the upgraded db with the db that is already upgraded and installed any of necessary latest plugins.
36
36
Quote
Status: offline
Laugh
Site Admin
Admin
Registered: 09/27/05
Posts: 1470
Location:Canada
Well anything is possible.. It really depends how different the databases are.
What is important is that that the user ids line up in both databases. Everything from topics, comments, security assignments, etc. is assigned to a user.
You also need to make sure topics and topic assignments are not missing for articles, staticpages, etc
If the dev site has just upgraded plugin tables and the production site just has new records for users and topics (no deletions) then you should be okay but you should really test it and see. If there are say a missing user record then any content that user may have will not be able to display and could have cascading effects elsewhere...
The other spot you would have to update as well would be the geeklog plugins table to make sure all the latest version info, etc is correct for each record.
One of the Geeklog Core Developers.
What is important is that that the user ids line up in both databases. Everything from topics, comments, security assignments, etc. is assigned to a user.
You also need to make sure topics and topic assignments are not missing for articles, staticpages, etc
If the dev site has just upgraded plugin tables and the production site just has new records for users and topics (no deletions) then you should be okay but you should really test it and see. If there are say a missing user record then any content that user may have will not be able to display and could have cascading effects elsewhere...
The other spot you would have to update as well would be the geeklog plugins table to make sure all the latest version info, etc is correct for each record.
One of the Geeklog Core Developers.
30
42
Quote
OMAL
Anonymous
Eventually, I upgraded the main site, and added it the dev's plugins folders, and activated it.
By the way, I found an issue so report it after testing.
By the way, I found an issue so report it after testing.
31
20
Quote
Status: offline
Laugh
Site Admin
Admin
Registered: 09/27/05
Posts: 1470
Location:Canada
Sounds good. You can report all bugs on Github: https://github.com/Geeklog-Core/geeklog/issues
One of the Geeklog Core Developers.
One of the Geeklog Core Developers.
25
25
Quote
All times are EST. The time is now 01:20 am.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content