Advertisement:

Author Topic: Backing up a forum  (Read 1553 times)

Offline Mbd

  • Semi-Newbie
  • *
  • Posts: 20
Backing up a forum
« on: June 18, 2016, 10:09:02 AM »
Hey, so my forum has quite a lot of bugs, I figure the easiest way is to just backup and then wipe everything clean, re-install SMF and load the backup. Just got a quick question.

When I go Admin > Maintenance > Forum Maintenance > Database, and thenI  check the following -

Save the table structure.
Save the table data (the important stuff).
Compress the file with gzip.

What exactly will this backup, idealy I would like to backup all member accounts, posts, forum structure and avatars/signatures etc, will this back everything up for me then I can just delete everything on my hosting and do a full reinstall?

Thanks!

Offline Siirist

  • Sophist Member
  • *****
  • Posts: 1,201
  • Gender: Male
  • What would Kindred or Illori do?
    • A Sanctuary (Support for Survivors of abuse/Info for Family & Friends)
Re: Backing up a forum
« Reply #1 on: June 18, 2016, 10:29:15 AM »
More info?
Hey, so my forum has quite a lot of bugs, I figure the easiest way is to just backup and then wipe everything clean, re-install SMF and load the backup.

What bugs?

Other helpful information:
- What MODs are installed? - want to save these?
- What Theme are you using?  - want to save these?
- What SMF version are you using?
- A link to your site can be helpful
Needed information:
- What's your SMF version?, What MODs are installed? What Theme(s) are you using? Have you backed up your database?

--> At least 50% of the questions asked are answered in the Online Manual <--
Mods for ver 1.x will NOT run on ver 2.x

Offline Mbd

  • Semi-Newbie
  • *
  • Posts: 20
Re: Backing up a forum
« Reply #2 on: June 18, 2016, 10:35:40 AM »
There's just a bunch of small bugs which have accumulated over time, such as reply box sizes on certain themes, main page no longer working, RSS feeds not working, custom form errors etc.

The only mod I have is the Custom Form Mod, I would like to save this.

I am using the Blackhead theme, this has several errors with it so I will just be doing a full re-install of this theme.

I am on SMF 2.0.5

My website is www.solidarityeu.co.uk [nofollow]

I also just read that it is best to backup through mySQLadmin, I assume this will save absolutely everything if I backup through that oposed to through the SMF backup on the admin pannel.

Online Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,430
  • Gender: Male
    • Kindred-999 on GitHub
Re: Backing up a forum
« Reply #3 on: June 18, 2016, 10:59:45 AM »
1- don't use the backup in smf admin...  most of the time it works... but sometimes it doesn't.  Use the hosting side backup of your database...

2 as for what you actually want to accomplish delete the theme and then just load a fresh set of files for 2.0.11 and run upgrade.php...
That will load your forum clean without any bugs...
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline Mbd

  • Semi-Newbie
  • *
  • Posts: 20
Re: Backing up a forum
« Reply #4 on: June 18, 2016, 12:04:02 PM »
Alright thanks, so how much information does a SQL backup hold? Is it literally all forums contents, members, forums, groups, posts, avatars, signatures?

Online Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,430
  • Gender: Male
    • Kindred-999 on GitHub
Re: Backing up a forum
« Reply #5 on: June 18, 2016, 12:25:49 PM »
the database has all of the CONTENT of the forum...

although it does not have the actual files of the attachments and avatars, it only has the location of those files within the site file system
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline Mbd

  • Semi-Newbie
  • *
  • Posts: 20
Re: Backing up a forum
« Reply #6 on: June 18, 2016, 12:26:58 PM »
Ok thanks!

Online Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,430
  • Gender: Male
    • Kindred-999 on GitHub
Re: Backing up a forum
« Reply #7 on: June 18, 2016, 12:30:24 PM »
to do a clean upgrade

1- delete everything in the files except Settings.php, Settings_bak.php, the attachments directory and the avatars directory.
(if you have mods which add other files, like a gallery, also keep those directories)

2- load a clean set of files from the 2.0.11 large upgrade archive. (NOT the install archive -- the large UPGRADE)

3- run upgrade.php to clean a few things up


Now you have a "clean install" of 2.0.11 with no mods and with all of your original data.
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline Mbd

  • Semi-Newbie
  • *
  • Posts: 20
Re: Backing up a forum
« Reply #8 on: June 18, 2016, 12:53:08 PM »
Alright I'll give that a go, thanks!

Offline a10

  • Charter Member
  • Sr. Member
  • *
  • Posts: 863
Re: Backing up a forum
« Reply #9 on: June 18, 2016, 03:43:33 PM »
...and check this out http://www.mysqldumper.net/
2.0.15, ssl, php 7.1.31, MySQL 10.3.13-MariaDB~bionic
Mods: Contact Page, Like Posts, Responsive Curve, Search Focus Dropdown, Add Join Date to Post.