Copying custom setting from one instance to another.

[denis]

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

[JPDeni]

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?

[denis]

I am talking about different installations, in different directories, on the same server using the same theme.

[JPDeni]

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.

[denis]

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

[JPDeni]

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.

[denis]

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

[JPDeni]

Is 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.

[denis]

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

[denis]

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/ .