VB4 : How can I Transfer only determinated Db Sections to a new forum ?

Discussion in 'Databases' started by mimozo, Dec 22, 2013.

0
  1. #1
    Hi

    I have a forum vb4 with 800.000 posts . with some thematic sections
    I want to create a new forum with a certain thematic . and I have more than 100.000 posts in the Technology section .
    I want to import only the sections of technology on the new forum ( under a new domain name) and also the members who contributed on those threads . and I will delete those section from the original forum .
    How can I do it please ?

    Thank you
     
    mimozo, Dec 22, 2013 IP
  2. khodem

    khodem Well-Known Member

    Messages:
    206
    Likes Received:
    8
    Best Answers:
    3
    Trophy Points:
    120
    #2
    create similar name database and import all data on that... or install that forum once done replace that data with the data you want to with SQL
     
    khodem, Dec 25, 2013 IP
  3. mimozo

    mimozo Well-Known Member

    Messages:
    304
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    103
    #3
    that is my question how to transfer determinated sections/members to the new database ?

    thanks
     
    mimozo, Dec 25, 2013 IP
  4. PoPSiCLe

    PoPSiCLe Illustrious Member

    Messages:
    4,623
    Likes Received:
    725
    Best Answers:
    152
    Trophy Points:
    470
    #4
    Since I don't know directly how the db is set up, the simplest would probably be to just transfer / copy the whole deal, and then use the forum engine to remove subforums and categories that you don't want to have in the new forum. That circumvents having to figure out internal key-configurations and making sure that you delete all, but only those you want to delete.
     
    PoPSiCLe, Dec 25, 2013 IP
  5. mimozo

    mimozo Well-Known Member

    Messages:
    304
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    103
    #5
    Ok , thanks .
    However there is a point I would like to clair .
    The forum which I have has more than 1.000.000 members registered .
    How can I filter only the one who contributed on those selected sections .

    Thanks
     
    mimozo, Dec 26, 2013 IP
  6. khodem

    khodem Well-Known Member

    Messages:
    206
    Likes Received:
    8
    Best Answers:
    3
    Trophy Points:
    120
    #6
    you need to post database structure... it's possible to do this with SQL query but I need to know your database structure without which it's like aim in darkness and wish it will hit the target... only saying you want to transfer something from somewhere does not give detail info... you need to give us the database structure... table name and fields so to create query to select only those that contributed to some particular section of the forum.

    cheers
     
    khodem, Dec 26, 2013 IP