Simple Machines Community Forum

SMF Support => SMF 2.1.x Support => Topic started by: mcdconcepts on May 22, 2025, 06:02:54 AM

Title: Restore users from old db
Post by: mcdconcepts on May 22, 2025, 06:02:54 AM
Hi
I have moved servers and it did not go well. So I have reinstalled SMF, all I want to do is restore the members we used to have in old db.
Luckily, I have only just started in setting this up so there are not many.
How do I do this please?
Many thanks
Chris
Title: Re: Restore users from old db
Post by: Kindred on May 22, 2025, 09:19:44 AM
you should never do a partial restore. the tables have interconnections and restoring only the users would put things in a bad state.

You should restore the entire database - and then use repair_settings.php to correct the paths, etc that would be different between servers.
Title: Re: Restore users from old db
Post by: Doug Heffernan on May 22, 2025, 11:11:47 AM
Quote from: mcdconcepts on May 22, 2025, 06:02:54 AMI have moved servers and it did not go well.

In what way it didn't go well?
Title: Re: Restore users from old db
Post by: mcdconcepts on May 24, 2025, 05:38:48 AM
Quote from: Kindred on May 22, 2025, 09:19:44 AMyou should never do a partial restore. the tables have interconnections and restoring only the users would put things in a bad state.

You should restore the entire database - and then use repair_settings.php to correct the paths, etc that would be different between servers.
Cheers. Understood
Title: Re: Restore users from old db
Post by: mcdconcepts on May 24, 2025, 05:40:43 AM
Quote from: Doug Heffernan on May 22, 2025, 11:11:47 AM
Quote from: mcdconcepts on May 22, 2025, 06:02:54 AMI have moved servers and it did not go well.

In what way it didn't go well?

Mods didn't go over properly, database got corrupted. All sorts of issues. Up and going again though thanks to davej