TinyPortal

Development => Support => Installation => Topic started by: denis on December 29, 2006, 02:02:05 PM

Title: Copying custom setting from one instance to another.
Post by: denis on December 29, 2006, 02:02:05 PM
Hi,

I have 11 SMF-TP instances in development.

I would like to be able to configure TP only once in one instances, let's ay instance "a", and then copy this configuration to the other instances, let's called them instances "b", "c" ... "k".  Is this possible?

Thanks
Title: Re: Copying custom setting from one instance to another.
Post by: JPDeni on December 29, 2006, 03:25:18 PM
I don't know what you mean by "instances." Are you talking about installations in different directories on the same server? Different servers? Different themes? Something else?
Title: Re: Copying custom setting from one instance to another.
Post by: denis on December 29, 2006, 04:17:57 PM
I am talking about different installations, in different directories, on the same server using the same theme.
Title: Re: Copying custom setting from one instance to another.
Post by: JPDeni on December 29, 2006, 07:51:33 PM
Since all TP and SMF settings are in the database, you can use the same database for any number of installations, but there would be the same posts as well.

That said.... I believe there is a topic over at the SMF site that is about having several different installations which use some of the same database tables. I would look over there to see what others have written about it.
Title: Re: Copying custom setting from one instance to another.
Post by: denis on December 29, 2006, 08:57:56 PM
Quote from: JPDeni on December 29, 2006, 07:51:33 PM
Since all TP and SMF settings are in the database, you can use the same database for any number of installations, but there would be the same posts as well.

If you use the same database this would be an issue but in the DB there are 6 tables that are related to TP. Two of those, TP_settings and TP_ variables, could be exported and then imported into the new instance.

My question is, can we do this? As someone ever done that?

Thanks
Denis
Title: Re: Copying custom setting from one instance to another.
Post by: JPDeni on December 30, 2006, 12:19:00 AM
Are you just wanting to set one up and copy them to other databases? Yes, that would certainly be possible. I misread at the beginning and thought you were wanting to run them all off the same database. That would be much more difficult.
Title: Re: Copying custom setting from one instance to another.
Post by: denis on December 30, 2006, 01:22:32 AM
Yes that is exactly what I want to do: set one up and copy them to other databases.

So, by exporting TP_settings and TP_ variables, would I achieve what I want to do? Is there anything I need to do extra so that the imported settings and variables work on the new site ?

Thanks

Denis
Title: Re: Copying custom setting from one instance to another.
Post by: JPDeni on December 30, 2006, 01:43:45 AM
QuoteIs there anything I need to do extra so that the imported settings and variables work on the new site ?
I don't think so. I would export each table as an .sql file and then import them the same way. I don't think there's any URL-specific things within those tables.

I'm assuming you know that you need to have the TP files and various SMF files that TP alters as well.
Title: Re: Copying custom setting from one instance to another.
Post by: denis on December 30, 2006, 02:56:36 AM
Quote
I'm assuming you know that you need to have the TP files and various SMF files that TP alters as well.

Actually I don't. I will have two identical forum, except for the location and the database, with TP installed. I will export TP_settings and TP_ variables from one to the other. Tha't all I was thinking of doing.

Thaks for your feedback

Denis
Title: Re: Copying custom setting from one instance to another.
Post by: denis on December 31, 2006, 02:34:48 PM
Well at first glance, it worked. But, the two files that I imported where : TP_Articles and TP_ blocks

I had a little difficulty to rename the tables, MySQL is not very intuitive IMHO, but I found a good site on the subject and it help me find the place where I could rename the table.
It's in french but here it is in case someone need's it. http://cyberzoide.developpez.com/php4/mysql/ .