Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
man oh man. migrating to local site headaches.
uch i’m posting in hopes that someone had the same problem as me. trying out the xampp procedures, i was able to make a fresh textpattern site successfully. migrating a live site to my local computer is more difficult though.
i was able to import the sql file successfully, in the config.php i was able to change the root location properly as well. now what happens is going to my site.dev directory shows my 404 not found error, but also if i go to the site.dev/textpattern, it says config.php is missing or corrupt. i’m pulling my hair out here ha! i did read wion’s article on moving from live to local, and i did the one procedure on resetting the admin password.Offline
#2 2008-05-14 17:05:27
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: man oh man. migrating to local site headaches.
mrtunes wrote:
in the config.php i was able to change the root location properly as well.
Did you also change (if applicable) the database name, user and password? Also in config.php is your table prefix, does it differ locally from your live site?
Offline
Re: man oh man. migrating to local site headaches.
Els wrote:
Did you also change (if applicable) the database name, user and password? Also in config.php is your table prefix, does it differ locally from your live site?
—-
hola. i tried to make the exact same db name, username and password for my local site. my live site has no table prefix in the config.php so i left that blank in my local one too.
Offline
#4 2008-05-14 17:22:13
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: man oh man. migrating to local site headaches.
Can you access your local database with this user name and password in phpMyAdmin? IIRC local installs usually work with user root.
Offline
Re: man oh man. migrating to local site headaches.
Els wrote:
Can you access your local database with this user name and password in phpMyAdmin? IIRC local installs usually work with user root.
what do you mean by “access”? cause in phpmyadmin it seems to be able to do almost anything once you’re logged in.
I tried username root – without changing the password it said “database unavaiable” on the site’s main page, and the same error trying to go to /textpattern(config.php missing or corrupt). then in phpmyadmin i changed root’s password to match what’s in config.php and i’m back to the same spot i was before – 404 on the main page and /textpattern has the same config.php error
Offline
#6 2008-05-14 19:56:27
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: man oh man. migrating to local site headaches.
Then I was wrong about the user ‘root’. It looks like it’s definitely config.php then. There may be something in it that doesn’t belong there. What if you delete the existing file and create a new one using the default that comes with the install (config-dist.php in the /textpattern/ folder)?
Otherwise, here is a similar post that might be helpful.
Offline
Re: man oh man. migrating to local site headaches.
hmmm well maybe you can clarify if i did something wrong then – i created an empty database and then imported the SQL file. are you supposed to import the SQL file after doing a fresh install of textpattern?
after that, i tried to import the SQL file on the fresh install of textpattern and that doesn’t work cause phpmyadmin spits back at you and says “this table is already created”.
Offline
#8 2008-05-15 09:23:54
- redbot
- Plugin Author
- Registered: 2006-02-14
- Posts: 1,410
Re: man oh man. migrating to local site headaches.
mrtunes wrote:
after that, i tried to import the SQL file on the fresh install of textpattern and that doesn’t work cause phpmyadmin spits back at you and says “this table is already created”.
Have you tried to import without first creating an empty table?
Offline
#9 2008-05-15 15:29:08
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: man oh man. migrating to local site headaches.
Here is how I have done it in the past.
- Create an empty database locally.
- Install TXP.
- Delete all tables (DROP) in the local db, because installing TXP has already created all tables.
- Then import your existing database.
- Adapt config.php.
- And don’t forget to change the settings in Preferences (site url, folders)
Last edited by els (2008-05-15 15:30:45)
Offline
Re: man oh man. migrating to local site headaches.
redbot wrote:
Have you tried to import without first creating an empty table?
well don’t you need an empty table to do the sql import to? not sure if i understand your suggestion correctly. i have tried many different combinations though.
also something to note that often when i do a mysql import, the process times out around the 15th table. so i’m left with an incomplete database – a healthy txp database is 18 tables i believe.
Offline
#11 2008-05-15 16:52:54
- redbot
- Plugin Author
- Registered: 2006-02-14
- Posts: 1,410
Re: man oh man. migrating to local site headaches.
mrtunes wrote:
well don’t you need an empty table to do the sql import to? not sure if i understand your suggestion correctly. i have tried many different combinations though.
Ehm… probably I didn’t explain well.
I just wanted to say exactly what Els said.
Els wrote
…Delete all tables (DROP) in the local db…
Last edited by redbot (2008-05-15 16:56:29)
Offline
Re: man oh man. migrating to local site headaches.
yeah i’ve tried that, but still trying to work around the mysql import timing out. isn’t that the same as installing into an empty database though? cause you essentially clean the database out?
Offline