Possible? restoring a forum?

[topthisfact]

Hello,
I was wondering if it is possible to restore a blog or a forum without knowing the MYSQL database info & having the forum files, but all i have is the sql file.

The sql file is an smf file, so let say i just download an smf forum from the smf forum website & install it, will it work if i sql the sql file into phpmyadmin just so i can get the backup data, or it wont work.

 

[JayJACKEL!]

The reason is, is that your SMF forum most likely had MODs (Am I right?).

This means the the SQL database is injecting queries to the board that don't exist, which then causes errors and fails.

The only way you'll be able to manage this, is if you install SMF on a new database, copy down ALL of the tables in both databases and eliminate all tables that don't exist in the basic one.

This means no queries will be made that return errors, and it will run fine.

Saying this, do this at your own risk. If you take out a table you weren't meant to, disaster.

 

[topthisfact]

Hello,
How to figure out what table do i have and in what database?

 

[JayJACKEL!]

You have to go into phpMyAdmin through your host.

Then on the left there should be 2 different options to choose from (one should have information in the name, if not click the SMF one)

Then copy and paste all the tables from there.

Next do a clean install of SMF on a new database and repeat the steps above

Copy down the tables and compare them to the ones on your popular board.

Delete those that aren't default.

Away you go 🙂

 

[khaleel]

Is you forum on a different hosting account?
if yes then ask your host to restore your account to a back up
They should do it

 

[topthisfact]

Is you forum on a different hosting account?
if yes then ask your host to restore your account to a back up
They should do it

no the forum is 2-3 years ago.
i only have a backupof the sql file.

 

[Sitepearl]

Install the version of the forum that the sql was dumped from, empty all tables, import data.

 

[Pvcomputers]

write a php script that adds the data back in.