Advertisement:

Author Topic: Backup file from SMF 1.1.15 (smf2.sql.gz)  (Read 6821 times)

Offline jgo0338

  • Newbie
  • *
  • Posts: 2
Backup file from SMF 1.1.15 (smf2.sql.gz)
« on: November 01, 2018, 08:35:52 AM »
Hello, 

I have an old backup file from an SMF 1.1.15 forum that a friend of me hosted long time ago. The backup is from januari 2009 and the data is readable as ascii tekst. So the file is not corrupt.

This forum was used to discuss historical topics and I would like to recover some of this data. It seems that this file is only containing the SQL data of the forum.

Is there a possibility that I can recover the structure and content of this SMF forum or it this quite impossible and should I forget this idea?


Kind Regards

Johan

Online vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 20,557
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Backup file from SMF 1.1.15 (smf2.sql.gz)
« Reply #1 on: November 01, 2018, 10:37:15 AM »
Yes it is. Pretty much Upload to a database.
Download the largeupgrade package from the SMF site for SMF 2.0.15
Upload to your website.
Change the settings.php to point to the database and then run upgrade.php
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline Illori

  • Project Manager
  • SMF Master
  • *
  • Posts: 49,952
Re: Backup file from SMF 1.1.15 (smf2.sql.gz)
« Reply #2 on: November 01, 2018, 10:40:25 AM »
if the user only has the database they need to get the install working on that old version before they can upgrade. otherwise the upgrade will fail as the paths/URLs in the database will not be updated to work correctly.

Offline Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Lead Support Specialist
  • SMF Super Hero
  • *
  • Posts: 17,468
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • aleksi-kilpinen on LinkedIn
Re: Backup file from SMF 1.1.15 (smf2.sql.gz)
« Reply #3 on: November 01, 2018, 11:49:05 AM »
if the user only has the database they need to get the install working on that old version before they can upgrade. otherwise the upgrade will fail as the paths/URLs in the database will not be updated to work correctly.
How come? I mean the upgrade should actually be completely independent from files as far as I know, and even checks to make sure you are not using old files, such as outdated language packs. You should only need a working copy of settings.php AFAIK.
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.

How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Offline Illori

  • Project Manager
  • SMF Master
  • *
  • Posts: 49,952
Re: Backup file from SMF 1.1.15 (smf2.sql.gz)
« Reply #4 on: November 01, 2018, 11:52:31 AM »
there are paths like to the theme in the database that need to be updated before you can upgrade. the themes directory contains the language files, they will not be found and not work if the install is not working before you upgrade.

Offline Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Lead Support Specialist
  • SMF Super Hero
  • *
  • Posts: 17,468
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • aleksi-kilpinen on LinkedIn
Re: Backup file from SMF 1.1.15 (smf2.sql.gz)
« Reply #5 on: November 01, 2018, 11:58:32 AM »
Okay, I think I'm gonna have to play around and get familiar with the upgrade again, it's been a while, but I was kind of under the impression that at most you would need repair_settings to get things sorted after upgrade.
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.

How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 57,221
  • Gender: Male
    • Kindred-999 on GitHub
Re: Backup file from SMF 1.1.15 (smf2.sql.gz)
« Reply #6 on: November 01, 2018, 12:22:55 PM »
you would need a running version to run Repair_settings on... :)

So...  install 1.1.15 on the server
drop all tables in the newly installed database
load your database backup into that database.
then use repair_settings.php to correctly reconfigure the backedup data to the new location

then you can upgrade to 1.1.21 and from there to 2.0.15 using the standard process
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 jgo0338

  • Newbie
  • *
  • Posts: 2
Re: Backup file from SMF 1.1.15 (smf2.sql.gz)
« Reply #7 on: November 01, 2018, 01:58:53 PM »
Thanks to all. I'm gone give it a try !!