Simple Machines Community Forum

Archived Boards and Threads... => Archived Boards => SMF Feedback and Discussion => Aiheen aloitti: showmetheway - joulukuu 01, 2007, 11:41:32 AP

Otsikko: I want to Restore my Data base Backup
Kirjoitti: showmetheway - joulukuu 01, 2007, 11:41:32 AP
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....
Otsikko: Re: I want to Restore my Data base Backup
Kirjoitti: babjusi - joulukuu 01, 2007, 11:54:18 AP
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 (http://www.simplemachines.org/download/index.php?thanks;filename=repair_settings.php) 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
Otsikko: Re: I want to Restore my Data base Backup
Kirjoitti: showmetheway - joulukuu 01, 2007, 12:02:32 IP
Thanks But Where i will hv to go to use this Repair system... Please Guide me thoroughly..

thanks..
Otsikko: Re: I want to Restore my Data base Backup
Kirjoitti: babjusi - joulukuu 01, 2007, 12:05:51 IP
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
Otsikko: Re: I want to Restore my Data base Backup
Kirjoitti: showmetheway - joulukuu 02, 2007, 04:10:46 AP
Please Guide me How to import Database to New Host.????
Otsikko: Re: I want to Restore my Data base Backup
Kirjoitti: babjusi - joulukuu 02, 2007, 02:10:39 IP
Lainaus käyttäjältä: showmetheway - joulukuu 02, 2007, 04:10:46 AP
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
Otsikko: Re: I want to Restore my Data base Backup
Kirjoitti: fecu2008 - helmikuu 23, 2008, 02:27:54 AP
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?
Otsikko: Re: I want to Restore my Data base Backup
Kirjoitti: 青山 素子 - helmikuu 25, 2008, 11:40:58 AP
Lainaus käyttäjältä: fecu2008 - helmikuu 23, 2008, 02:27:54 AP
what do you mean import the database? How?

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