I want to Restore my Data base Backup

[showmetheway]

Hello All
I've changed my Hosting server. I had the Back up of my forum data but i dont know how to restore my database back up on new server.
Will i hve to put file in any directory or in which folder i should put my database backup file?

Thanks
Answer me in detail please....

[babjusi]

You can go about it in 2 ways.

1. Ftp to your pc all the forum files and then re-upload them again to the new host. Then import the database to your new host as well. And as last step, run repair settings to update the db info and all the urls, paths and all that other settings. Don''t forget to delete it after you are done.

2. Install simply a fresh smf at the new host and then import the database. And do the same with the repair_settings.php tool, what I already described above.

Note a few things: If you go with the first method, you will keep all the mods intact, whereas with the second method you will have to re-install them

And regarding importing the database, it depends on some things. Like how mb is its size, how it was made etc. You can read here how to restore it

http://www.simplemachines.org/community/index.php?topic=184356.msg1172622#msg1172622

Hope all this helps

[showmetheway]

Thanks But Where i will hv to go to use this Repair system... Please Guide me thoroughly..

thanks..

[babjusi]

First you must download it at the link that I provided above. Then using a ftp program you will have to upload it at the forum directory at your new host , point your browser to it, i.e. www.yoursite.com/forum-path/repair_settings.php, then click on all the blue recommended values and don''t forget to delete it after you are done. That was it

[showmetheway]

Please Guide me How to import Database to New Host.?

[babjusi]

Please Guide me How to import Database to New Host.?

First you must backup your database at your old host and then restore it at the new one. For more info have a look at this link

http://www.simplemachines.org/community/index.php?topic=184356.msg1172622#msg1172622

and this one

http://docs.simplemachines.org/index.php?board=83.0;sort=subject

[fecu2008]

2. Install simply a fresh smf at the new host and then import the database. And do the same with the repair_settings.php tool, what I already described above.

what do you mean import the database? How?

[青山 素子]

what do you mean import the database? How?

Did you read the links babjusi posted? They might just answer your question.