PDA

View Full Version : transferring pixelpost to another domain

Karamac
08-03-2006, 01:33 PM
I am currently trying to transfer my pixelpost blog to another domain. I have backed up the sql db and tried to restore at the new domain but it comes up with the following error:

Connect DB Error: Access denied for user: 'me@******.co.uk' (Using password: NO) Cause #2

I can create a new db at the new domain - no problems.
From what I can make of the sql file, it refers to my old domain, is there any way that I can transfer just the fields of data rather than the whole db to get pass this problem?

I have created a new db using exactly the same name but my new domain seems to keep putting a prefix before the sql db name so when I try to restore, it is saying wrong user and password
jdleung
08-03-2006, 01:39 PM
did you edit the file pixelpost.php? db name, db password and prefix.
Karamac
08-03-2006, 01:50 PM
read wiki, i have done that.. thanks for that thou

yes.. i have altered the php file to enter the new domain prefix it keeps putting in.

I think it must be my new host that is at fault with the sql as it shouldnt put its own prefix in when i create new db.
The backed up sql file has the name of user, db and password embedded in it so when I try to restore to a new location that isnt exactly the same named db, its saying user and db invalid.
Connie
08-03-2006, 01:50 PM
did you read the wiki?

http://wiki.pixelpost.org/index.php?title=Move_Pixelpost_from_A_2_B
Karamac
08-03-2006, 01:58 PM
I am going to try yet again using wiki step by step :)
Connie
08-03-2006, 03:03 PM
I press the thumbs!
Karamac
08-03-2006, 03:14 PM
BINGO!! done it
I was importing sql file instead of copying the text, but I also had to change the dbase name in the sql text
I'm a happy bunny now :)
Connie
08-03-2006, 08:43 PM
great! I was sure you will get it!
Karamac
08-03-2006, 08:52 PM
only problem is now it wont let me upload new image!!
its something to do with the image paths... at least i'm almost there :)
Connie
08-03-2006, 09:40 PM
check the info about paths and tell us, I am sure this problem can be solved!

which error message you get?
GeoS
08-03-2006, 09:47 PM
If you are now working on copy of previous installation then you can go to admin panel -> options and there set Images path to ../images/ and URL to your new URL.