PDA

View Full Version : Database back-up


LynnR
04-30-2006, 05:04 PM
I want to upgrade my pixelpost, and I know there is a procedure that I back up my DB in the phpmyadmin in my control panel. I just don't remember what i did when I last backed-up my DB ....

Someone out there to help me?

Joe[y]
04-30-2006, 05:08 PM
http://wiki.pixelpost.org/index.php/Migrating_using_PHPMyAdmin#Backup

LynnR
04-30-2006, 05:14 PM
Exactly what I wanted ... thanks SO much. :)

LynnR
04-30-2006, 05:58 PM
ooooooooooooops!
Parse error: parse error, unexpected T_VARIABLE in /home/dgr/public_html/photoblog/includes/pixelpost.php on line 3

Still there JL? .... anyone then?

LynnR
04-30-2006, 06:01 PM
is: $pixelpost_db_pass = "replace_me"; // database user password ...
line 3?

LynnR
04-30-2006, 06:10 PM
hello ... anyone around that can help? ... sorry, my "A-type" personality is seeping through ... :(

LynnR
04-30-2006, 06:29 PM
I went to a php forum, ... and found my (the) error. lacking a space. :)

All fixed. :)

Joe[y]
04-30-2006, 06:34 PM
haha. just returned in time to see you solve your own crisis. well done.

LynnR
04-30-2006, 07:35 PM
.... actually ... it's not all fixed. I can get to my admin, ... but I got nothin' else. The index.php is blank, ... and the thumbnails from my regular blog, come up empty as well (http://digitalgladrags.com/blog/index.php)

I have to leave for a bit, but I shouldn't be too long ... I'm beside myself...

GeoS
04-30-2006, 08:04 PM
What have you changed since it was working fine?

LynnR
04-30-2006, 08:18 PM
At first I couldn't get to my admin/install page, .. then I fixed a php spacing error in my pixelpost.php file I uploaded it, and was able to get into my admin page. I looked around, everything looked fine on the "inside" and so I tried to view my index.php page of my blog and there is nothing there, just a blank white page. I went to my journal blog to see if the thumbnails would go anywhere, and I get the same, just blank white pages. No errors ... just nothing. *shrug*

blinking8s
04-30-2006, 10:21 PM
what version were you updating from?

start with this...

1. download pixelpost again, reupload all the files (should be the 1-5cr1-2 package)

2. check to make sure the images path in the admin is set to ../images/

did you make a backup of your original database?

LynnR
04-30-2006, 10:33 PM
yeppers, I made a back-up, not that I'd know what to do with it if I needed to use it. I had the 1.4.2 version

LynnR
04-30-2006, 10:56 PM
Warning: Cannot modify header information - headers already sent by (output started at /home/dgr/public_html/photoblog/includes/create_tables.php:38) in /home/dgr/public_html/photoblog/admin/install.php on line 44


I tried, ... and now I have this error.

LynnR
04-30-2006, 11:00 PM
OK so maybe since tearing my hair out is too painfull, and waiting is too stressfull .... I'll just abandon the other p-blog I had, and do a whole new install.

Maybe wordpress has an add-on that's easier ...?

Joe[y]
04-30-2006, 11:00 PM
Warning: Cannot modify header information - headers already sent by (output started at /home/dgr/public_html/photoblog/includes/create_tables.php:38) in /home/dgr/public_html/photoblog/admin/install.php on line 44


I tried, ... and now I have this error.

i assume this means you have already run the install script before. am i right?

is your front page the only thing not working? if so try changing line 34 of index.php from error_reporting(0); to //error_reporting(0);

hopefully this will display any errors.

Joe[y]
04-30-2006, 11:02 PM
OK so maybe since tearing my hair out is too painfull, and waiting is too stressfull .... I'll just abandon the other p-blog I had, and do a whole new install.

Maybe wordpress has an add-on that's easier ...?

nah. don't do that quite yet! if you'd like you could email me your ftp/database details to joey {at} pixelpost {dot} org and i could have a crack at fixing it for you. it's past midnight here though so it would have to wait til the morning. of course - this relies on you placing some trust in me...

LynnR
04-30-2006, 11:04 PM
oh my, ... there is god!!! ... details coming right up!!!

I guess I should ask what details you need. I kinda got all excited there. :rolleyes:

LynnR
04-30-2006, 11:06 PM
I did what Will suggested ...

1. download pixelpost again, reupload all the files (should be the 1-5cr1-2 package)

2. check to make sure the images path in the admin is set to ../images/

Joe[y]
04-30-2006, 11:11 PM
I did what Will suggested ...

1. download pixelpost again, reupload all the files (should be the 1-5cr1-2 package)

2. check to make sure the images path in the admin is set to ../images/

and?

LynnR
04-30-2006, 11:17 PM
and then I got the error I quoted above:

Warning: Cannot modify header information - headers already sent by (output started at /home/dgr/public_html/photoblog/includes/create_tables.php:38) in /home/dgr/public_html/photoblog/admin/install.php on line 44


I looked at line 44, but I'm not very good with php to begin with ... :(

GeoS
05-01-2006, 07:32 AM
Did you upload all files in ASCII mode (by FTP)??

How did you edit /includes/pixelpost.php - by cPanel (or other such product) or on local computer with normal text editor and then uploaded it??

It means that you are sending some chars just before script start to work with session headers and so on. It can be a reason of additional spaces at beginning of files which you were editing and many other things.

LynnR
05-01-2006, 10:05 AM
I did the upload properly
I used notepad to edit

.... and joe[y] is looking into all this for .... I think.

Thanks :)

LynnR
05-01-2006, 10:27 AM
Here's an error (I hadn't noticed before) from my admin pages:

Fatal error: Cannot redeclare category_list_as_table_noecho() (previously declared in /home/dgr/public_html/photoblog/addons/copy_folder_1_4.php:175) in /home/dgr/public_html/photoblog/addons/copy_folder.php on line 181


If this helps any?

Connie
05-01-2006, 10:39 AM
Here's an error (I hadn't noticed before) from my admin pages:

Fatal error: Cannot redeclare category_list_as_table_noecho() (previously declared in /home/dgr/public_html/photoblog/addons/copy_folder_1_4.php:175) in /home/dgr/public_html/photoblog/addons/copy_folder.php on line 181


If this helps any?


yes, this is of help. Please take off the addon copy_folder_1_4.php from your addon-folder. You only need one copy_folder-addon and that should be the one which comes with the package

it is of no help just to rename some Addons in the addon-folder, they are still read and interpreted, so there is a collision

LynnR
05-01-2006, 10:47 AM
That did it Connie, ... thank you so much. :)

Looks like I'm back in business. I was in the process of creating a whole new photoblog. *LOL* .... oh well, maybe I'll create a new one anyway. Thanks again. :)

Connie
05-01-2006, 11:15 AM
great! I am glad.. sometimes it's just a small reason for a big problem ;=)

blinking8s
05-01-2006, 12:36 PM
congrats...glad its working now

LynnR
05-01-2006, 12:38 PM
congrats...glad its working now

Thanks Will.

greentraveler
05-03-2006, 10:06 PM
What a harrowing read...congratulations on your recovery! :D