Import part of the database in MODded forum?

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
atnbueno
Registered User
Posts: 39
Joined: Sun Aug 03, 2003 5:26 pm
Location: Spain
Contact:

Import part of the database in MODded forum?

Post by atnbueno » Sun Aug 14, 2005 8:49 am

Hello, all.

I've installed a fresh 2.0.17 (new url, new database), restored a month-old database of my original forum (which is still running) and added a couple dozen MODs, some of them altering the database. Now I'd like to update the new ("fresh") forum's database with the users, posts, private messages, etc. of the old ("original") one. Can I do this importing just some of the tables from the old forum's database? If so, which ones?

Please note that forums, usergroups, banned users and IPs, permissions, ... is already in the new forum, as I started with an old backup and I haven't made any changes in the configuration of the old one since then.

This is the list of tables, with my guess about what to import and what not to import:
auth_access
banlist
categories
config
confirm
disallow
forum_prune
forums
groups

posts
posts_text
privmsgs
privmsgs_text
ranks
search_results
search_wordlist
search_wordmatch

sessions
smilies
themes
themes_name

topics
topics_watch
user_group
users
vote_desc
vote_results
vote_voters

words

Am I wrong with any of them? Is there something I'm not aware of?


Thanks in advance,
Last edited by atnbueno on Sun Aug 14, 2005 8:53 am, edited 2 times in total.
Antonio B.
mundoplus.tv - Televisión por Satélite en España

Freestyle XL
Registered User
Posts: 1608
Joined: Sun Jul 31, 2005 4:09 pm
Contact:

Post by Freestyle XL » Sun Aug 14, 2005 8:51 am

Greetings,

You need to import all tables, not only ones that you selected. Items in every table are connected to items in other tables, so importing only few tables will cause a mess.
»AcidTech« »Counter-Strike« »Flower Power« »Getaway« »GreenTech« »Jet«

All styles are updated for phpBB 2.0.21

atnbueno
Registered User
Posts: 39
Joined: Sun Aug 03, 2003 5:26 pm
Location: Spain
Contact:

Post by atnbueno » Sun Aug 14, 2005 9:51 am

Thanks for your answer.

The problem is that I already have data in those tables. If I drop them (before importing) I'll lose the changes made by some of the MODs. And if I don't, wouldn't that also result in a mess?
Antonio B.
mundoplus.tv - Televisión por Satélite en España

Freestyle XL
Registered User
Posts: 1608
Joined: Sun Jul 31, 2005 4:09 pm
Contact:

Post by Freestyle XL » Sun Aug 14, 2005 9:57 am

Greetings,

You can apply those change added by mods after importing database.
»AcidTech« »Counter-Strike« »Flower Power« »Getaway« »GreenTech« »Jet«

All styles are updated for phpBB 2.0.21

ImTheMan
Registered User
Posts: 61
Joined: Thu Oct 21, 2004 5:26 pm

Post by ImTheMan » Sun Aug 14, 2005 10:14 am


atnbueno
Registered User
Posts: 39
Joined: Sun Aug 03, 2003 5:26 pm
Location: Spain
Contact:

Post by atnbueno » Sun Aug 14, 2005 12:49 pm

Hi, again.

@Freestyle XL: I certainly could do that. But it would probably be more work than reinstalling the MODs from scratch :?

@ImTheMan: Thanks for the link. Maybe I can use it and if not, I already got a few ideas from reading the code :)


Thank to both,
Antonio B.
mundoplus.tv - Televisión por Satélite en España

User avatar
Marshalrusty
Project Manager
Project Manager
Posts: 29252
Joined: Mon Nov 22, 2004 10:45 pm
Location: New York City
Name: Yuriy Rusko
Contact:

Post by Marshalrusty » Sun Aug 14, 2005 1:16 pm

Careful when using that script. Make sure you have backups of both parts before trying. It has been known to mess things up quite badly.
Have comments/praise/complaints/suggestions? Please feel free to PM me.

Need private help? Hire me for all your phpBB and web development needs

ScionCrow
Registered User
Posts: 3621
Joined: Fri Feb 13, 2004 6:59 am
Location: Darkness

Post by ScionCrow » Sun Aug 14, 2005 1:18 pm

Although, this KB article should be of some assistance. http://www.phpbb.com/kb/article.php?article_id=212
No longer supporting phpBB. PM or email me regarding support and you will be ignored. I'm fully done with phpBB and everything.

atnbueno
Registered User
Posts: 39
Joined: Sun Aug 03, 2003 5:26 pm
Location: Spain
Contact:

Post by atnbueno » Sun Aug 14, 2005 2:05 pm

Hello again.

@Marshalrusty: Yep. I've been reading carefully the 7-page thread. And I'm also quite paranoid about backups :D

@ScionCrow: Thanks, but in my case it's the same server and I have shell access (so it's just me, not limitations of the system :P). It's more a problem of "transplanting" the public part (users, posts, PMs) of one database to another.

Well, I'm going to give it a first try. Wish me luck!


Cheers,
Antonio B.
mundoplus.tv - Televisión por Satélite en España

Locked

Return to “2.0.x Support Forum”