uh oh...

Nephalim · November 20th, 2007, 06:11 PM

hi recently moved to new server and all we seen was the default no thumbnail images. well we ran a scan database and all is gone. we backed up the database prior but how and what do we do to get the images back? also got these error messages
Warning: opendir(/home/mysite/public_html/mysite/gallery/data/) [function.opendir]: failed to open dir: No such file or directory in /home/user/public_html/mysite/gallery/adm-inc.php on line 589

Warning: readdir(): supplied argument is not a valid Directory resource in /home/user/public_html/mysite/gallery/adm-inc.php on line 592

Warning: closedir(): supplied argument is not a valid Directory resource in /home/user/public_html/mysite/gallery/adm-inc.php on line 609

running pp 5.6 on a VB 3.6.8level2 forum

thank you

Chuck S · November 20th, 2007, 08:09 PM

This should explain how to move servers.

How to Move Servers and/or Change Directories

You would need to reimport the database to the new server again and then follow the thread above to correct all settings and files and you should show images then. Your photo inserts where deleted because your server paths to images where wrong and you ran a scan database which could find no files.

Nephalim · November 20th, 2007, 10:10 PM

thank you

Chuck S · November 20th, 2007, 10:54 PM

no problem have a good evening

Nephalim · November 20th, 2007, 11:17 PM

Quote:

Originally Posted by Chuck S

You would need to reimport the database to the new server again and then follow the thread above to correct all settings and files and you should show images then. Your photo inserts where deleted because your server paths to images where wrong and you ran a scan database which could find no files.

Thank you once again... one question. When I backed up my database it was a total database backup from my old site. How can I just re-import the PP data?

Thank you for all your patience

Chuck S · November 21st, 2007, 07:44 AM

Really all you need to do is import the pp_photos table inserts.

You would need to find those in your backup and you could use phpmyadmin to insert those or make a new sql file with those entries.

Nephalim · November 22nd, 2007, 01:29 AM

Quote:

Originally Posted by Chuck S

Really all you need to do is import the pp_photos table inserts.

You would need to find those in your backup and you could use phpmyadmin to insert those or make a new sql file with those entries.

Thank you. I opened my backup on my desktop... and WOW!!!!

I do not know where to start to find the PP files? Is there a website or manual on how to just import the PP_photos table?

Thanks. I dont want to give up yet because ALL of the photos are on my site, just not working with PP yet

Chuck S · November 22nd, 2007, 08:53 PM

sorry there is no manual on some other 3rd party program or hosting program on our site as we would just have stuff here related to our program. How did you do a backup using what program? Maybe we should start there and see what your using and are familiar with.

Basically a backup is an sql file and you need to view that file and find the inserts for your pp_photos table and use maybe the sql box in phpmyadmin to import them back in. Are you familiar with that program?

Nephalim · November 22nd, 2007, 09:38 PM

Hi, I have NO idea. I'm sooo lost with that phpadmin

Chuck S · November 23rd, 2007, 07:55 AM

Okay your lost here but how did you do your backup? You did not really answer my question. Did you have a friend help you? To transfer a site you would have backed up a database and then restored it to the new server so excuse me for being a little confused as to why you have no idea what I am talking about when you would have needed to do exactly more or less what we are talking about here.

You have an sql file correct? Basically if you messed up the database when moving you need to start over and redo the database import. I am trying to explain here how you insert just the photo inserts but this requires you to tell me how you moved this in the first place and got your site running.

If you view your sql file you copy and paste all your inserts for the pp_photos table to a new file if you want. Basically viewing phpmyadmin you view the photopost database and then in the big window at top it has tabs. You hit the sql tab and you can copy and paste the inserts into that box or if you have made a new sql file with just the pp_photos inserts in it you can use the http upload prompt if that file is under 2mb to restore the entires.

Nephalim · November 23rd, 2007, 09:32 AM

Quote:

Originally Posted by Chuck S

Okay your lost here but how did you do your backup? You did not really answer my question. Did you have a friend help you? To transfer a site you would have backed up a database and then restored it to the new server so excuse me for being a little confused as to why you have no idea what I am talking about when you would have needed to do exactly more or less what we are talking about here.

You have an sql file correct? Basically if you messed up the database when moving you need to start over and redo the database import. I am trying to explain here how you insert just the photo inserts but this requires you to tell me how you moved this in the first place and got your site running.

If you view your sql file you copy and paste all your inserts for the pp_photos table to a new file if you want. Basically viewing phpmyadmin you view the photopost database and then in the big window at top it has tabs. You hit the sql tab and you can copy and paste the inserts into that box or if you have made a new sql file with just the pp_photos inserts in it you can use the http upload prompt if that file is under 2mb to restore the entires.

Ha... O.k. I did it myself! All I did was backup my VBulletin board using the maintenance backup tool. It downloaded to my desktop....then I made a new database at my new server and imported the backup to the database. Thats all I did

Chuck S · November 23rd, 2007, 09:51 AM

So do you understand what I wrote? did you fix your issue?

Nephalim · November 23rd, 2007, 11:36 AM

Quote:

Originally Posted by Chuck S

So do you understand what I wrote? did you fix your issue?

Thank you for such detail. I emailed support. I am really lost here

Chuck S · November 23rd, 2007, 12:53 PM

Okay you can do that but you need to state what your not understanding with what we are telling you. You made a backup of a database and you have even imported that backup into the new database so you have done both processes here. So you know what you have to do. Let me recap what I have stated above even simpler here. You deleted all your photos because you did not correct your paths when you moved servers so you need to get those photos back. I outlined specific actions my previous post but lets see if we can get you straight here.

1. open your backup of the database

2. delete anything in there that does not start with

INSERT INTO pp_photos

3. save the backup

4. import it into your new database

THATS IT your done. After that you should have your photos back because all your worried about reimporting is the pp_photos table inserts unlike what you did before was importing a full backup.

Nephalim · November 23rd, 2007, 01:03 PM

Thank you Chuck. My only question (and your info is GREAT!!) Is... what do I open my backup with? I opened it with text edit and OH MY GOD!!!! There's so much in there, I can't tell what is what. What program will open it up?

Thank you for your time. This is I'm sure probably elementary to you :-)

Chuck S · November 23rd, 2007, 04:54 PM

Try opening it up with wordpad. that should keep the formatting so you know what you have left.

Nephalim · November 23rd, 2007, 05:07 PM

Quote:

Originally Posted by Chuck S

Try opening it up with wordpad. that should keep the formatting so you know what you have left.

Hehe... I'm on a Mac

Chuck S · November 23rd, 2007, 05:29 PM

UGH

well do what I suggested in your email support thread and I will have a look so lets keep our discussion there in that email