How to Restore live DB to a local DB in 8 easy steps

[ladynada]

Hello SysOps,

Today I made a backup of my live SMF forum and wanted to restore it to my local one, where I do theme work.  I wrote up some notes on how to do this.

How to move your live smf bbs (1.12) to your local smf bbs (1.12)

1. first, logon the live bbs and backup a complete sql file and download to local pc and unzip

2.  then logon to local bbs and make a complete backup for insurance, then log off

3. then boot up mysql-front
select your local smf database and choose import from file menu and import the sql (complete) from the live bbs

Code Select Expand


**** Alternative importing method: Using mysql in command line mode
        open up a comman line window so you can see when it stops

at the mysql prompt use this command structure

c:\>mysql -u USERNAME -p DATABASE_NAME < backup.sql

USERNAME is the mysql username for your database (usually root on local pc)
DATABASE_NAME is the mysql database name of the smf database (usually smf)

mysql will ask you for your password and then start importing, it might take a while
example of command you type in your mysql dir, in the command line window:

mysql -u root -p smf < e:/mysql/backup.sql


4. copy repair_settings.php to your local smf folder and run it from a browser
http://localhost/smf/repair_settings.php

5. answer all questions, the field shows what was in the database (some urls/folders from live bbs)
then look at the suggestions! see the suggestions are correct, so click them in
6. save settings at bottom of page
7. logon to local bbs, its same as the live one!

8. Reset Theme URLs and Directories in admin
__________________________

[KGIII]

Much thanks for your addition - good topic too so that hopefully it is easily found by those people who are looking for this. As this is a "topic solved" board (used by support here) I have gone ahead and marked this one solved. You should be able to "unsolve" it if you don't think of it as solved but it really isn't in need of answering as near as I can tell.

[ladynada]

Great!

I came here to add that it is also a nice way to move all your support files to your local pc, if I am not mistaken, my message board icons came over with the backup zip file.  I am not exactly sure about that though!

nada