Pixelpost

Fellow Eskimo · #1 03-06-2005, 04:19 AM

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**+ · #2 03-06-2005, 06:08 AM

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/viewt...amp;highlight=

Fellow Eskimo · #3 03-06-2005, 05:24 PM

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

**raminia**+ · #4 03-07-2005, 06:34 PM

sorry about the broken link. it's now corrected
http://www.pixelpost.org/forum/viewt...amp;highlight=

Fellow Eskimo · #5 03-21-2005, 11:26 AM

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.

#6 03-21-2005, 12:04 PM

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 · #7 03-21-2005, 01:40 PM

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 · #8 03-21-2005, 08:31 PM

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?

#9 03-21-2005, 08:52 PM

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 · #10 03-21-2005, 08:54 PM

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

Pixelpost

Authentic Photoblog Flavour