switching servers

Crono999 · 2005-07-14 20:29:10

I have an existing site created using textpattern and hosted at textdriven.com. However, I need to move the site to a new server. My question is, once the new server is set up with Apache, MySQL and PHP, am I able to simply transfer the home directory over to the new server and have my site run smoothly, or will I need to do a new textpattern install on the new server? Basically, I’m looking for the absolute easiest/quickest way to transfer a textpattern site from one server to another. Any input on this would be greatly appreciated. thanks.

marios · 2005-07-14 23:24:15

Before you do anything make an sql dump of your database.
I think this is what you are looking fore.

regards, marios

Sencer · 2005-07-15 07:38:36

A server move usually will look like this (and this is the same for any php software that runs with a database).

1) Make a dump of the database
2) Download all the files
3) Upload all the files to the new server
4) Import your dump into the database (here you will have to check for differences between the old and the new db, especially in terms of charsets, collations, versions and such)
5) Change the config-file to reflect the new server (new db-passwords, change paths, domain-name etc.)
6) Try to login – if it doesn’t work, you might have to change some setting in the database in the configuration/prefs table as well (usually this will also be server-specific stuff like paths and domain-names)

Crono999 · 2005-07-15 12:45:25

As far as a database is concerned, the information that is updated on the site is just read from a file that is transfered to a directory every hour. Therefore, backup is not a huge issue. Unless, that is, you are speaking of a database TextPattern creates for its own use? Otherwise the site at the moment is fairly static and simply updated from an external source.

What my main question involved was whether or not I need to run a TextPattern install on the new server, or if TextPattern will transfer over properly by just copying the home directory over to the new server? From the responses I’ve received, it appears I only need to modify the config-file. Please let me know if this is a correct assumption. Thanks again.

Sencer · 2005-07-15 13:31:36

Crono999, did you install Textpattern yourself? During the installation process you have to enter the information of the mysql database that you are going to use – you have to have created that database in mysql either yourself, or your host has created and assigned a database to you – but either way you must have entered that information in the setup, and this information is (besides some other stuff) what is in your configuration file.
Textpattern stores it’s content in this database, and that is the database that I was referring to. If you want to use Textpattern on a different server, you either have to make sure that you access the other database from your new server, or you have to transfer the database to the new server. This is a strictly mysql-related question, and not specific to Textpattern. (If you have questions regarding this, I am sure someone will still be able to help you with this. I was just trying to explain what I meant above)

Crono999 · 2005-07-15 13:56:58

Sencer, thanks a lot, that clears it up pretty well. I actually came onto this project to modify an existing site that another person had created using TextPattern, so I haven’t yet gotten a good feel for how exactly it is set up and works on the server. Thus far, I’ve just been manipulating layout, graphics and content. But now that I’ve completed that, I need to figure out the back-end. Thanks for the help.

bici · 2005-10-08 07:18:50

> A server move usually will look like this (and this is the same for any php software that runs with a database).

1) Make a dump of the database
…edited bits..
5) Change the config-file to reflect the new server (new db-passwords, change paths, domain-name etc.)
6) Try to login – if it doesn’t work, you might have to change some setting in the database in the configuration/prefs table as well (usually this will also be server-specific stuff like paths and domain-names)

Hi. I wish to switch my txp database to a new domain (also onTxD). I exported the db using mysqldump via terminal. the db is called gio_bici, and its path is /home/giovanni/public_html/bici/textpattern. In looking at the sql dump (vi edit the gio_bici) i can see the references to the db name and in various places references to the path. I have created a new db called bici in my new domain, also on TxD. Its path will be /home/giovanni/domains/bicilogic.com/public_html/textpattern. QUESTION. Can I simply change the DB name and the path in the exported DB, and then use mysql import to import the existing db gio_bici into the new one..bici? ( i would also edit the new config.php file accordingly…)

edit: BBcode didn’t stick

Last edited by bici (2005-10-08 07:21:05)

bici · 2005-10-09 22:31:24

> bici wrote:

> QUESTION. Can I simply change the DB name and the path in the exported DB, and then use mysql
> import to import the existing db gio_bici into the new one..bici? ( i would also edit the new config.php file
> accordingly…)

Let me answer my own question. YES. Albeit it took me all day to get it to work. The hardest part if i can recall correctly is the USER settings.

I exported the mydbold_sql. I edited all the fields that had to do with URLs so that they pointed to the new domain and my /files and /images. I edited the name of the db to new name mynewdb. I found out that I had to leave the old txp_user and password that appears after this line: /*!40000 ALTER TABLE `txptxp_users` DISABLE KEYS */;

(NOTE: even if your user/paswd to edit the new db is different leave the old one there. You will edit via MyPHPadmin to reflect the actual passwd and user name that has been given access to th MySQL db via yrself or another admin.)

I then imported the old db into mynewdb. THEN. I went and updated the user field to my new id and pass as per <a href=“http://textpattern.net/wiki/index.php title=Moving_Installation_from_one_Host_to_Another”>this link</a>. Then lastly I ran the /textpattern/index.php, signed in with my new id/passw and all is well with the world. 7hrs later that is ;-)

happy thanksgiving…

jakob · 2005-10-11 13:21:59

…not forgetting at the end don’t forget to change the site url in the admin preference tab to your new domain or your permalinks will be wrong.

bici · 2005-10-11 16:28:08

…and also add or make sure your .htaccess file is there/updated ;-)

Textpattern CMS

Textpattern CMS support forum

#1 2005-07-14 20:29:10

switching servers

#2 2005-07-14 23:24:15

Re: switching servers

#3 2005-07-15 07:38:36

Re: switching servers

#4 2005-07-15 12:45:25

Re: switching servers

#5 2005-07-15 13:31:36

Re: switching servers

#6 2005-07-15 13:56:58

Re: switching servers

#7 2005-10-08 07:18:50

Re: switching servers

#8 2005-10-09 22:31:24

Re: switching servers

#9 2005-10-11 13:21:59

Re: switching servers

#10 2005-10-11 16:28:08

Re: switching servers

Board footer