Moving servers

sonnyzm · 2006-02-20 00:01:58

Gday people, I’ve been developing my website on my computer and I’ve attempted to move my site onto my webspace. I’ve followed the tutorial here ( http://textpattern.net/wiki/index.php?title=Moving_Installation_from_one_Host_to_Another ) and I’ve read up on some posts but I cant seem to get my website to work.
My diagnostic is as follows:

Pre-flight check:
————————————

path_to_site is inaccessible: C:\Server\xampp\htdocs\x\shmedia5
C:\Server\xampp\htdocs\x\shmedia5/index.php is inaccessible
Image directory is not writable: C:\Server\xampp\htdocs\x\shmedia5/images
File Upload Path is not writable: C:\Server\xampp\htdocs\x\shmedia5\files

————————————

So far what I’ve done is, duplicated my files on my localhost to my webserver, imported the mysql database and changed the config.php file. I dont know why its still showing the old paths to my website. any ideas? (Also what should I change localhost to, in the config file “$txpcfg[‘host’] = ‘localhost’;” if for example my domain was website.com ?)

cheers, Sonny

Last edited by sonnyzm (2006-02-20 00:25:48)

nardo · 2006-02-20 00:14:00

sonny, I’m no expert but… I’ve done this a couple of times, and I’ve always done a fresh install of Textpattern on the new server first (made a db, etc)

when the fresh Txp install is working, I’ve gone back to phpMyAdmin, dropped the contents of the associated db, and imported my proper db

then in preferences, just had to change the site url (and maybe also location of temp folder) and that was it…

Mary · 2006-02-20 00:20:36

$txpcfg['host'] should remain localhost.

The root of your site is inside x\shmedia5? as in http://localhost/x/shmedia5?

Edit: oh and what do you mean by “doesn’t work”?

Last edited by Mary (2006-02-20 00:21:08)

sonnyzm · 2006-02-20 00:24:41

Problem resolved, I had the wrong txpath in my config file
I had ‘http://mywebsiteurl.com/textpattern/’ instead of ‘/home/sonnyzm/public_html/textpattern’

Thanks for helping out guys, much appreciated

Last edited by sonnyzm (2006-02-20 01:37:00)

puthupa · 2006-05-22 00:49:22

nardo: i tried your suggestion, but haven’t had any luck. it seems to be trying to create a db rather than just import the info (fyi i know nothing about mysql). at first it tried to create a db (the name of the db on the original server) but did not have the correct hostname to do so. after i changed the db & hostnames in the exported sql data file, it tells me

MySQL said: Documentation

- Can’t create database ‘laszlolove’; database exists <br />

would you mind explaining a bit further how you have done this? thank you.

els · 2006-05-22 14:52:18

During the install a new database is created. When you export your existing database, make sure that “Add DROP DATABASE” and “Add DROP TABLE” are unchecked. That way it has always worked for me.

puthupa · 2006-05-22 20:35:38

i had those unchecked, as i’d followed the textbook wiki. what do i do with the exported material? that part of the wiki is lacking.

Mary · 2006-05-22 21:13:50

Import it into your new server’s database.

els · 2006-05-22 21:19:43

Ah, ok. So first you have installed Txp on the new server, and the new database is created.
Then you export the old db, I usually save it as a file (so I won’t have to export it again might things not work). Open the file in a text editor, select all and copy.
Go to phpMyAdmin of the new database, click on the SQL icon which will open a window saying “Run SQL query/queries on database …”, and paste everything in there. Hit ‘Go’ and that should do it. You will see a message when the query is successfully executed.
Then, as Nardo said, make the necessary changes in admin > preferences.

Edit: no doubt Mary is right, but I always just see ‘export’ in phpMyAdmin, not ‘import’… In other words, if there is a better way, I never figured it out :/

Last edited by els (2006-05-22 21:23:47)

Mary · 2006-05-22 21:53:43

…but I always just see ‘export’ in phpMyAdmin, not ‘import’…

I do, in my own local copy. I think it could be a phpMyAdmin setting, or a “which version are you using” thing, as I remember I didn’t always have it available before.

hcgtv · 2006-05-22 22:24:46

There is an import, this is the menu when you enter into an empty database: * Structure * SQL * Search * Query * Export * Import * Operations * Privileges * Drop

puthupa · 2006-05-22 23:41:15

import is what i am having a problem with. it tried to create a db (using the name of the old db from which i exported the data). i posted the exact error message in the other thread that is now closed. since the wiki info on this was lacking, i tried nardo’s suggestion and haven’t had any luck with importing the exported data.

Textpattern CMS

Textpattern CMS support forum

#1 2006-02-20 00:01:58

Moving servers

#2 2006-02-20 00:14:00

Re: Moving servers

#3 2006-02-20 00:20:36

Re: Moving servers

#4 2006-02-20 00:24:41

Re: Moving servers

#5 2006-05-22 00:49:22

Re: Moving servers

#6 2006-05-22 14:52:18

Re: Moving servers

#7 2006-05-22 20:35:38

Re: Moving servers

#8 2006-05-22 21:13:50

Re: Moving servers

#9 2006-05-22 21:19:43

Re: Moving servers

#10 2006-05-22 21:53:43

Re: Moving servers

#11 2006-05-22 22:24:46

Re: Moving servers

#12 2006-05-22 23:41:15

Re: Moving servers

Board footer