Moving to a new host

[Fellow Eskimo]

Im moving from my current host to a new one, and I need pixelpost and (hopefully) all of my current entries over with it. I have moved all of the files and pictures and thumbnails, and created a new data base on the new server (I dont think its possible to transfer databases)...but I have no entries now. Please please tell me there is a way to transfer everything from one host to another? Can't I copy the SQL database or something? Help!

[raminia]

If you have copied the files you need only to backup DB.
Ask your host administrator to make a back up of the DB for you.
Or aks admin to help you backup for your self.
It's quite easy.
Then import the DB backup to the new site. IF YOU HAVE CHANGED THE SITE ADDRESS follow the guidelines in this thread (HTTP://WWW.NEWSITE.COM/OR_NEWFOLDER)
UPDATE:
http://www.pixelpost.org/forum/viewtopic.php?t=469&highlight=

[Fellow Eskimo]

Link doesnt work, but I dont need it. Its the same address, just another host. I will definitally try that, thanks. :)

[raminia]

sorry about the broken link. it's now corrected
http://www.pixelpost.org/forum/viewtopic.php?t=469&highlight=

[Fellow Eskimo]

Ok, I have completly moved to the new host...

The domain name is the same, so I did not use the hack in the post above because thats for changing the name. I backed up the mySQL database, and uploaded it into new server, and ran the SSH command to make the tables, and everything seemed right. But its not...

http://www.felloweskimo.net/photo/index.php Its not there. I dont know where I screwed up... after I did the SSH command for the database, it said tables were created. So, I have no idea what went wrong. I have pixel post, just none of my previous posts.

[Connie]

check the name of tables in the file pixelpost.php with the tablenames at the new host

are they really the same?

maybe you included the backup into other tables...

[Rob]

Make sure that your username/password/database/host in the configuration is correct.

If it is, using SSH, try the following to see what is in your database.

1. Type 'mysql -u username -p' at the ssh command line. Change username to your database username. Enter the password when prompted.

2. You should now be at the mysql command line. Type 'use pixelpost_database;' at the command line. Change pixelpost_database to the name of the database you entered in the configuration.

3. If that worked, type 'select * from pixelpost_pixelpost;'. If you changed the database prefix, change pixelpost_ to your prefix. You should see a table with all of your entries in it. If not, you have not properly transferred the database, you have just created a new empty one.

4. You can also try 'show tables;' to show all of the tables in your database. You should see something like (but a bit different, I have several addons);

pixelpost_catassoc
pixelpost_categories
pixelpost_comments
pixelpost_config
pixelpost_pixelpost
pixelpost_visitors

5. To exit mysql, type quit;.

Notice all mysql lines end in ;

Let us know what you see and I'll see what I can do...

[Fellow Eskimo]

Ok, I just got phpMyAdmin on new host, which is what I used before...shows problem.

Browse: (1 Rows) pixelpost_categories
Browse: (0 Rows) pixelpost_comments
Browse: (1 Rows) pixelpost_config
Browse: (0 Rows) pixelpost_pixelpost
Browse: (26 Rows) pixelpost_visitors

I have those. Now...my database name was called on my old host was felloweskimo_net_-_photo...and now its known as db120881588. I cant change that name, and I cant create a new database...so what do I need to change? The tables are there, but empty, mostly. no entries or anything. I will change the name of the database in the mysql dump file and try it....

EDIT: ok, redid database...notice something strange.
in the dump file, I have this:
INSERT INTO `pixelpost_config` VALUES ('PASSWORD', 'password', 'felloweskimo@gmail.com', 'yes', 'grey', '/kunden/homepages/34/d95334646/htdocs/fe/photo/images/', 'http://www.felloweskimo.net/photo/', 'Fellow Eskimo Photography', 'english', 'No Calendar', 'yes', 100, 75, 5, 90, 'Y-m-d H:i:s');

But when I dump it with SSH, it comes out like this...
INSERT INTO pixelpost_config VALUES ('PASSWORD','password','','no','pixelpost-
light','/homepages/34/d95334646/htdocs/fe/photo/images/','http://s95334664.onlin
ehome.us/fe/photo/','pixelpost','english','No Calendar','yes',100,75,5,75,'Y-m-d
H:i:s');

And even at the weird addy, I still dont have the photos. I edited the user name what pass fields. The case with the hosting is, I have domains pointed at different folders, like Felloweskimo.net is pointed at /fe/...but why is it sending it to the other domain? Is this something I should take up with my host?

[Connie]

how many images do you have?
would it be too much to populate the photoblog manually?
I see you have so much problems with that :cry:

[Fellow Eskimo]

39 images...not a whole lot, but would be a pain in the butt to do by hand...I follow directions well...help?

[Rob]

Okay, the problem is that pixelpost has created the database for you so your restore of the backup is failing. What you need to do in PhpMyAdmin is go into your database and drop all of the tables. Do that by checking all the tables on the first page, then selecting Delete from the dropdown below the table list.

Now, without going to your web page (so pixelpost doesn't try to create the tables ;) ) restore your old database using PhpMyAdmin. Do that by going to the SQL tab and loading your textfile in using the browse button.

Now, all of those tables should have returned. Go to your pixelpost admin and make sure it works. Now go to your options pane and update anything you need to change for the new site.

Good luck.

[Fellow Eskimo]

ok, deleted, and tried to upload, error:

Database db120881588 running on db176.perfora.net

Error
There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:
----BEGIN CUT----
eNodzT1ugzAAxfHdp3hDRnBsE1LXG0JWGsl8FKep1I0U1FBZQE 0apWfL0CP1CiVZn/56P11VRaWQ
cqQCRucKHALRmtjdPF8JSfdWYbFtFKYvN9Z+aj113YGOxzE4g1 P5AMFYtGRyySPwtWKx4gx999k6
6MuIBcl+7LNRWFFGxSqcTnXf1L4J3fBBXmyFwgZINjrfBdjrGX 3temTF29aYBDFlpMwSBUFjGpHy
qbw1QWFvdxGdIdP13xdiknyj0PZhNw2hlPFjyMkd/bv+2tafWw83vNfuOEwnMqsazYELJiWPpfwH
FEVG7w==
----END CUT----
----BEGIN RAW----

ERROR: C1 C2 LEN: 1 2 36
STR: »

CVS: $Id: sqlparser.lib.php,v 1.87 2003/08/13 16:05:10 nijel Exp $
MySQL: 4.0.24-standard-log
USR OS, AGENT, VER: Win MOZILLA 5.0
PMA: 2.5.3
PHP VER,OS: 4.3.10 Linux
LANG: en-iso-8859-1
SQL: Server localhost

USE db120881588

----END RAW----

SQL-query :

Server localhost USE db120881588

MySQL said:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'Server localhost

USE db120881588' at line 1


Well, I am guessing the problem has to do with localhost...I dont think I use localhost anymore, because database is stored at db176.perfora.net. I can give the MySQL on request if anyone wants to analyze...

[Fellow Eskimo]

Yay! Ok, I just put a # in front of the first line on the database file and it worked. Commando, you are a saint in my eyes! Many thanks!

[Rob]

Great, I'm glad it worked. :D

[Youmoussa]

Hi there,

I will need to move my PP install to a new host too.

I know how to backup my DB and my files from my previous host. I will keep the same subdomain name. But the DB name/login/passowrd are going to change and I don't get how PP will know these new information.

Should I relaunch the install on the new host or is there a trick?

[Dkozikowski]

Hi there,

I will need to move my PP install to a new host too.

I know how to backup my DB and my files from my previous host. I will keep the same subdomain name. But the DB name/login/passowrd are going to change and I don't get how PP will know these new information.

Should I relaunch the install on the new host or is there a trick?

You can manually edit the pixelpost.php file located in the includes/ folder.

[Youmoussa]

Thank You.

Is that easy to change the subdomain name? (I must admit that I haven't search for this so far)

I would like to do the migration in 2 steps. First move all the files+db and check that everything works. And only after that I could use my domain name with my new hosting provider.

[Dkozikowski]

Yes, it's that easy.

Once you edit the pixelpost.php file with the new database info. Login to your admin panel and goto the options page. Update the site url and you should be done...