Announcement

Collapse
No announcement yet.

Partial vB 3.6 to vB 3.6 Migration

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Christine
    replied
    Originally posted by Steve Machol View Post
    Impex is available for download in the Members Area.
    Thanks!

    Originally posted by antiekeradio View Post
    can't you use bigdump to restore the .sql file to the database? if there are no duplicate ID's etc, this should go on without overwriting/messing up anything.

    be sure to try it out in a test environment first though...
    Interesting. You are referring to this? http://www.ozerov.de/bigdump.php

    It looks like that utility requires a DROP TABLE statement in the sql script. I am not looking to drop/replace the table -- I just need to merge the old threads back into it.

    Did I miss that on that page?

    Leave a comment:


  • antiekeradio
    replied
    can't you use bigdump to restore the .sql file to the database? if there are no duplicate ID's etc, this should go on without overwriting/messing up anything.

    be sure to try it out in a test environment first though...

    Leave a comment:


  • Steve Machol
    replied
    Impex is available for download in the Members Area.

    Leave a comment:


  • Christine
    replied
    Thanks Steve,

    This is what I was looking for. I started my vB in 2001 from scratch and never had to use IMPEX, so wasn't sure what all it did.

    I would like to take a look to see what I can do with this.

    Where can I d/l this, or how do I go about requesting a copy?

    Leave a comment:


  • Steve Machol
    replied
    If those 5000 threads are the only threads in that database then you should be able to import them. However you would first need to import the users and forums. These are required prior to importing the threads. After that you will of course need to import the posts for those threads as well.

    I just need to plug them back into where they used to be?
    That's not possible with Impex. Importing will assign new thread and postids as well as new forums for these threads. You can then move them to other forums after importing if you want.

    Leave a comment:


  • Christine
    replied
    Originally posted by Steve Machol View Post
    You can't do a partial import. What are the exact errors?
    Steve,

    It *looks* here like you are answering my question by saying that I can't do a partial import -- so we switched to talking about how I was trying to load up, the errors on which prompted me to ask about the import functionality.

    Originally posted by Steve Machol
    That's not the same as using the Impex importer which is the forum you posted in.
    I am quite aware of that and am not looking for any assistance with running SQL scripts. I was just curious as to the file size permitted on the config.php mod you noted.




    The question remains -- Can I or can I not use the IMPEX technology to restore 5,000 threads from one vB 3.6 database into another vB 3.6 database given that these 5,000 threads *used* to belong in said [original] database, they have been restored into a new database where they are on their own (all other threads have been deleted). There is no duplication of threads and no orphaned threads -- I just need to plug them back into where they used to be?

    Would it be better if I just asked for IMPEX and figured it out on my own as opposed to asking if it will do what I need?

    Leave a comment:


  • Steve Machol
    replied
    Originally posted by Christine View Post
    Steve,

    I am not understanding why you and I are seemingly on two different continents with this conversation. LOL!

    It is in a database.
    Originally posted by Christine View Post
    Yes, importing a .sql file via phpmyadmin.
    Frankly I'm confused. Either you are importing an .sql backup into a database or you are using Impex to import data from an existing db into vB.

    Leave a comment:


  • Christine
    replied
    Steve,

    I am not understanding why you and I are seemingly on two different continents with this conversation. LOL!

    It is in a database. Per my opening post, I have 2 vB 3.6 databases. One is my live database (database 1), that is missing 5,000 threads, 100,000 posts.

    The other (database 2) is that SAME database but is ONLY the missing 5,000 threads, 100,000 posts from database 1 as I purged everything but the missing threads/posts after I restored it a few days ago. The reason I did this was to have a clean database with ONLY the missing thread/post data and no other.

    I need to import the threads and posts (and relevant tables like editlog) from database 2 back into database 1 where they started from.

    I tried it manually with sql scripts and it is crashing -- so I opened this thread to ask if the IMPEX system could help me.

    I am still not clear on the original question I came here to ask: Can IMPEX bring in thread and post data from one vB 3.6 into another vB 3.6?
    Last edited by Christine; Fri 27 Apr '07, 9:17am.

    Leave a comment:


  • Steve Machol
    replied
    No, Impex does not import data from a backup to a database. You need to get that data into the database first.

    Leave a comment:


  • Christine
    replied
    Steve,

    I think we are talking about 2 different things. I am asking in the Import forum because that is what I want to do. I need to import 5,000 threads from one vBulletin database into an existing vBulletin database (these threads were deleted out of the database and I need to restore them back into it, not restore/overwrite the whole thing).

    I am asking if your import scripts will allow me to do that -- merge in 100,000 posts back to a database that they were originally in.

    WHen you said no, that left my only option to try to load them manually via SQL insert statements.

    Is it possible to IMPEX these 5.000 threads (100,000 posts) back into the database that they were deleted out of?

    Leave a comment:


  • Steve Machol
    replied
    That's not the same as using the Impex importer which is the forum you posted in.

    The only reliable method of restoring a database is with shell access via telnet or ssh. This is because restoring with a PHP script like that in phpMyAdmin can result in PHP timeout errors and an incomplete database. Please see the instructions here:

    http://www.vbulletin.com/docs/html/m...ce_ssh_restore

    Note: Some people have reported success with these scripts:

    MySQLDumper:
    http://www.mysqldumper.de/en/index.php

    MySQLHotxcopy:
    http://www.vbulletin.com/forum/showt...t=mysqlhotcopy

    Bigdump (restore only):
    http://www.ozerov.de/bigdump.php

    Leave a comment:


  • Christine
    replied
    Yes, importing a .sql file via phpmyadmin.

    Leave a comment:


  • Steve Machol
    replied
    File? What file? I thought you were doing an import.

    Leave a comment:


  • Christine
    replied
    Will do Steve -- much thanks.

    How large of a file will that allow me to load?

    Leave a comment:


  • Steve Machol
    replied
    This may be a server time and/or memory limit. To temporarily up your limits edit your includes/config.php file and add these lines right under the <?php line:

    ini_set('memory_limit', 32 * 1024 * 1024);
    ini_set("max_execution_time", "800");

    Leave a comment:

widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X