SimplePortal

Support => Install and Upgrade => Topic started by: Divecall on April 16, 2010, 07:41:39 PM

Title: Restore HTML-Block from Backup
Post by: Divecall on April 16, 2010, 07:41:39 PM

Hello!

One question: I have an "old" Forum Backup (SMF 1.1.15) with an old Version from SP on my Harddisk. Not online, no virtual server - only the files (and the SQL-Backup)

But now it is necessary, to restore a HTML-Block from this page.

What i need to do? To install this Backup complete (maybe on a test page) or i can "read" the html-Data´s only from the files or from an DB-entry ?

Title: Re: Restore HTML-Block from Backup
Post by: Nathaniel on April 17, 2010, 02:10:20 AM

I'm guessing that you mean SMF 1.1.5. ;)

Well, it depends on how big/what format your SQL backup is. You could
- Try to copy the contents of the HTML block straight from the sql backup (if its human readable at all).
- Or, restore the entire SQL backup onto a local or remote MySQL server, then use a tool like PhpMyAdmin to recover the relevant block data.

The data will either be in the 'sp_blocks' table or the 'sp_parameters' table, depending on how old the version of SimplePortal was for that data. Looking at the 'content' column of the rows in the 'sp_blocks' table is a good bet if its a very old backup.

Title: Re: Restore HTML-Block from Backup
Post by: Divecall on April 17, 2010, 06:46:08 AM

Yes, it was 1.1.5... :-[

Thank you. I created a new SQL and put the backup inside. After this i found my information in the "sp_parameter" table.

Problem solved  :applause: