TinyPortal

Development => Support => Installation => Topic started by: whoflungdoo on January 03, 2007, 12:37:04 AM

Title: Migration suggestion
Post by: whoflungdoo on January 03, 2007, 12:37:04 AM
I have smf installed on host A, 1.1.1

I am moving to host B

I want to install smf 1.1.1 and TP .97 on host b from scratch, and then move my database from host A to host B.

What is the best way to do this? Will moving the database from A which does NOT have tp installed mess up anything when I import to host B which will have fresh install of TP and smf 1.1.1?
Title: Re: Migration suggestion
Post by: JPDeni on January 03, 2007, 02:27:02 AM
It shouldn't cause any problems. The database from A won't have any of the TP tables, so nothing will be overwritten.
Title: Re: Migration suggestion
Post by: whoflungdoo on January 03, 2007, 02:29:28 AM
Ok thanks!
Title: Re: Migration suggestion
Post by: whoflungdoo on January 23, 2007, 04:57:19 PM
Ok, plans have changed... I need to know the best way to do this migration.

I have smf 1.1 rc3 installed in domain A/forum. It has been upgraded from previous versions.  It has content I would like to keep. Tiny portal is NOT installed

I am setting up tiny portal and smf 1.1.1 on domain b ( my development site ) as a fresh install. Once I get the look and feel and layout all like I want, I want to apply that look and feel and layout to domain A.  Remember Domain A is in use and has content.

What would you recommend as the best way to go about this? I'm thinking there is a couple of ways. I want to minimize the downtime.
Title: Re: Migration suggestion
Post by: IchBin on January 23, 2007, 06:41:44 PM
You'll need to install TP on the Domain A/forum when you're ready. Then use a tool like phpMyAdmin to export the TP tables from the test site. Then import those tables to your existing database for Domain A/forum.
Title: Re: Migration suggestion
Post by: whoflungdoo on January 23, 2007, 07:10:17 PM
Are any pathnames stored in the database?
Title: Re: Migration suggestion
Post by: Lesmond on January 23, 2007, 07:38:23 PM
yes, you will need to run repair_settings.php from your root, you can get this from SMF site
Title: Re: Migration suggestion
Post by: IchBin on January 23, 2007, 08:56:54 PM
Actually they're not set in the database, they're stored in the Settings.php file.
Title: Re: Migration suggestion
Post by: JPDeni on January 23, 2007, 09:10:03 PM
Aren't the theme paths stored in the database? That's the one thing I ran into trouble with.
Title: Re: Migration suggestion
Post by: whoflungdoo on January 24, 2007, 12:58:26 AM
Ok how about I just pay one of you guys to do it for me :)
Title: Re: Migration suggestion
Post by: akulion on January 24, 2007, 01:20:10 AM
dont go for the option of having someone do it for u
believe me, one year ago....i used to be ready to faint when doing something like that

but I did it....
it took me trial and error at times
but it was worth it.

now i am pretty much capable of restoring anything anywhere i want because i learned it

and thats part of being a webmaster learning things or else u will always depend on others to do it for u and u wont be in control

follow these easy steps u cant fail...

1. set your forum to the Default core theme and then Take a database backup of the old forum in gzip format either from the forum maintenence tools or from phpmyadmin area

2. go to new host install the new SMF making sure the 1st user (admin)  is the same as your old database. Also make sure the table prefix is the same!

3. restore the database from PHPmy admin.....
a) click the phpmyadmin link nxt to the database u created on ur new host
b) when the new screen with 2 panels loads up, click on the database name from either the drop down list wich appears there, or in some cases just a link appears
c) when right side of the screen changes click on IMPORT tab at the top
d) specify the file you want to import and click go

4) now u just need to reupload the files from the old server to here

5) once done....upload the repair settings.php file to your new forum root and run it...make sure u click on all the links under each box in that file when it runs...so that paths are fixed

the end
Title: Re: Migration suggestion
Post by: whoflungdoo on January 24, 2007, 01:46:37 AM
Ok guys, Im gonna give it a shot probably this weekend. Will keep you posted.
Title: Re: Migration suggestion
Post by: akulion on January 24, 2007, 01:48:14 AM
dont worry dude
once u get used to it u will thank me for not taking up this task

believe me only a year ago I was the newbie asking questions after questions

it only took 1 try and I learned it...and if i can do it so can u :up:

but if NOTHING works out then dont feel shy to ask here oki
Title: Re: Migration suggestion
Post by: whoflungdoo on January 24, 2007, 01:52:18 AM
Oke doke, thanks for the info