Advertisement:

Author Topic: splitting up a 2.0 install and porting a single board to a 2.1 install  (Read 2595 times)

Offline drewactual

  • Sr. Member
  • ****
  • Posts: 917
    • College Football Fan Site CFB51
... and the 2.1 site is already up and running, void of posts/members, though.

what is the best practice to extract and port over members and then the contents of a single board from the DB?

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 60,287
  • Gender: Male
    • Kindred-999 on GitHub
Re: splitting up a 2.0 install and porting a single board to a 2.1 install
« Reply #1 on: February 02, 2021, 09:30:43 AM »
There is no "best practice" for this because it was never designed to be done....
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Offline drewactual

  • Sr. Member
  • ****
  • Posts: 917
    • College Football Fan Site CFB51
Re: splitting up a 2.0 install and porting a single board to a 2.1 install
« Reply #2 on: February 02, 2021, 09:36:00 AM »
semantics....

what WOULD BE the best practice for accomplishing this?

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 60,287
  • Gender: Male
    • Kindred-999 on GitHub
Re: splitting up a 2.0 install and porting a single board to a 2.1 install
« Reply #3 on: February 02, 2021, 09:39:14 AM »
it gets really complicated because tables are cross referencing.

members, topics, messages, settings, attachments (at the very least) and probably several log_ tables

but you don't want all of the topics, messages or settings tables.

there really is no GOOD way to move over only PART of the content.
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Offline drewactual

  • Sr. Member
  • ****
  • Posts: 917
    • College Football Fan Site CFB51
Re: splitting up a 2.0 install and porting a single board to a 2.1 install
« Reply #4 on: February 02, 2021, 09:41:53 AM »
is there an automated manner to port/copy it to 2.1 as a complete conversion- which then i will later prune the boards not needed?

Offline shawnb61

  • Developer
  • SMF Hero
  • *
  • Posts: 3,139
    • sbulen on GitHub
Re: splitting up a 2.0 install and porting a single board to a 2.1 install
« Reply #5 on: February 02, 2021, 10:42:35 AM »
is there an automated manner to port/copy it to 2.1 as a complete conversion- which then i will later prune the boards not needed?

Run the upgrader.   :)

Seriously, if you want a copy of a 2.0 board in 2.1, make a copy & then upgrade it.
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Offline drewactual

  • Sr. Member
  • ****
  • Posts: 917
    • College Football Fan Site CFB51
Re: splitting up a 2.0 install and porting a single board to a 2.1 install
« Reply #6 on: February 07, 2021, 03:05:49 AM »
- made clean install of 2.0.18
- dumped db of existing site- 300 members, 300k posts, 30k topics
- uploaded db to fresh 2.0.18 site
- pruned the posts and topics not wanted for the move
- ran the upgrade to 2.1rc3
- dumped that db
- uploaded the new 2.1rc3 db over the old 2.1rc3 database...

poof.. the board, member, posts, counts, avatars, PM's, et all was saved.   the only thing that was tricky was setting the permissions groups so folks could actually post... i've no clue why they didn't port w/o effort...