zackw
10-26-2010, 09:06 PM
Hi all.
We are upgrading our forum all around. It is currently on a slower server, running 3.6.6.
I need to move it to a new server and VB 4.0.7.
VB is a fresh install, I don't necessarily want to transfer all the files. In other words, a brand new install of VB, but transfer the existing database. So my first question is, can I expect trouble doing this? Or is it required to transfer all files and DB together?
Second question is, I know the search indexing and other things are different between 3 and 4 so I'm wondering which tables I don't need to transfer. Our postindex table is over 28 million rows and takes forEVER to import via dump or data transfer tools. But I think that table isn't even used now? Would be nice to know such things.
So my second question is, which tables can I skip transferring? The database schema will match, so all the tables will exist, but which tables can I skip transferring the data and just leave blank? searchcore?
I'm trying to trim the time it takes to import the database, even if I have to do some reindexing or something later, that's fine.
The idea is I want as "fresh" an install as possible, but keeping all the old threads, posts, attachments, yadda yadda, you know the drill. And I have a new template to install, so I just don't want any ghosts in the closet or orphaned tables, data, files, etc...
Thoughts?
We are upgrading our forum all around. It is currently on a slower server, running 3.6.6.
I need to move it to a new server and VB 4.0.7.
VB is a fresh install, I don't necessarily want to transfer all the files. In other words, a brand new install of VB, but transfer the existing database. So my first question is, can I expect trouble doing this? Or is it required to transfer all files and DB together?
Second question is, I know the search indexing and other things are different between 3 and 4 so I'm wondering which tables I don't need to transfer. Our postindex table is over 28 million rows and takes forEVER to import via dump or data transfer tools. But I think that table isn't even used now? Would be nice to know such things.
So my second question is, which tables can I skip transferring? The database schema will match, so all the tables will exist, but which tables can I skip transferring the data and just leave blank? searchcore?
I'm trying to trim the time it takes to import the database, even if I have to do some reindexing or something later, that's fine.
The idea is I want as "fresh" an install as possible, but keeping all the old threads, posts, attachments, yadda yadda, you know the drill. And I have a new template to install, so I just don't want any ghosts in the closet or orphaned tables, data, files, etc...
Thoughts?