Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#1 2006-10-29 18:51:05
- cfisher
- New Member
- Registered: 2006-10-27
- Posts: 2
Transfering/exporting textpattern to another server
Im in the process of transfering to another webhost server. I did some searching on the forums and the FAQ but i coudlnt find anything relating to exporting the database and files (i might have missed it). How would I go about doing this?
Thanks in advance,
Christopher
Last edited by cfisher (2006-10-29 18:52:04)
Offline
Re: Transfering/exporting textpattern to another server
We Love TXP . TXP Themes . TXP Tags . TXP Planet . TXP Make
Offline
#3 2006-10-30 14:28:24
- cfisher
- New Member
- Registered: 2006-10-27
- Posts: 2
Re: Transfering/exporting textpattern to another server
Thanks, i tried searching on transfering and exporting hehe.. didnt think of trying moving.
Offline
#4 2007-12-19 16:24:29
- maryse
- New Member
- Registered: 2006-08-24
- Posts: 6
Re: Transfering/exporting textpattern to another server
Hello,
So I am moving to another host and I followed the instructions here: http://textpattern.net/wiki/index.php?title=Moving_Installation_from_one_Host_to_Another
I exported my existing database. On the new server, I created the new database name, the first user and added this user to the database (in cPanel 10) but when I try to import my existing database I get the following error: #1044 – Access denied for user ‘userhere’@‘localhost’ to database ‘databasenamehere’
Does anyone know what could be causing this?
Thank you in advance for any tips.
Offline
#5 2007-12-19 17:13:02
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: Transfering/exporting textpattern to another server
Either the username, the password or the database name is not correct.
Offline
#6 2007-12-19 17:16:35
- net-carver
- Archived Plugin Author
- Registered: 2006-03-08
- Posts: 1,648
Re: Transfering/exporting textpattern to another server
Could it also be the MySQL machine name? Some hosts don’t run the SQL server on the same machine as the webserver — so ‘localhost’ doesn’t work for them (Dreamhost being one such case.)
— Steve
Offline
#7 2007-12-19 17:45:38
- maryse
- New Member
- Registered: 2006-08-24
- Posts: 6
Re: Transfering/exporting textpattern to another server
Thank you both for your answers.
Els wrote:
Either the username, the password or the database name is not correct.
In the instructions, it says when I create the new database name, I can use a different database name than the one previously used by Textpattern. So I tried both ways: using the same username, password and database name as the database I am importing and using different ones. It didn’t work either way.
Also, at this point in the process, I’m just trying to import the database.. none of the files (config file, for example) and textpattern structure have been uploaded yet as this comes in the next step. So there is nowhere else where I could have typed the wrong username, password and database name.
Regarding localhost, I’m with HostPapa and in their support section it says to use localhost.
One thing I should mention is that the username in the error message is not the username for the database but the username of my hosting account. So let’s say the username of my hosting account is ABC and the user I created for the database is XYZ, when I look at my list of users in the MySQL Account Maintenance, I see the user ABC_XYZ. And in the error it says :- – Access denied for user ‘ABC’@‘localhost’ to database ‘originaldatabasename’
so it’s not user XYZ or ABC_XYZ. It’s simply ABC, the username of my hosting account. I’m not sure if this helps in finding the problem…
Last edited by maryse (2007-12-19 17:46:46)
Offline