PhpDig.net

Go Back   PhpDig.net > PhpDig Forums > How-to Forum

Reply
 
Thread Tools
Old 01-04-2005, 06:53 AM   #1
renehaentjens
Orange Mole
 
Join Date: Nov 2003
Posts: 69
Can I easily upgrade a 1.8.3 database to 1.8.6 without loosing the data? Should I wait a bit, are more DB changes foreseen?

Agree with Slider - forgive me if I grumble every now and then in this forum...
__________________
René Haentjens, Ghent University
renehaentjens is offline   Reply With Quote
Old 01-04-2005, 08:31 AM   #2
jmitchell
Orange Mole
 
Join Date: Dec 2004
Location: Tennessee
Posts: 60
renehaentjens, I think you posted this in the wrong forum.

might try in the how to forum next time because this really looks out of place amid the other posts.

jmitchell
__________________
60,000 pages indexed!!!!! http://www.sharemylink.com
jmitchell is offline   Reply With Quote
Old 01-04-2005, 06:25 PM   #3
vinyl-junkie
Purple Mole
 
Join Date: Jan 2004
Posts: 694
Quote:
Originally Posted by renehaentjens
Can I easily upgrade a 1.8.3 database to 1.8.6 without loosing the data? Should I wait a bit, are more DB changes foreseen?
I was able to upgrade to 1.8.6 with no difficulty or lost data. Given the fact that a code exploit is the reason for this newest version, I'd say the sooner you upgrade the better off you'll be.
vinyl-junkie is offline   Reply With Quote
Old 01-05-2005, 12:19 AM   #4
renehaentjens
Orange Mole
 
Join Date: Nov 2003
Posts: 69
jmitchell: I shall be more than happy to see your answer to my question appearing in the how to forum. Most recent posts there are of a general nature, not related to upgrades, while quite some technical info about upgrades appears here...

vinyl-junkie: Thanks for comforting me. Did you just apply the update_db_to_1_8_4.sql, update_db_to_1_8_5.sql, and update_db_to_1_8_6.sql one after the other? So, in your opinion, could I simply merge these three, store the result in update_db.sql, and run the install.php script, selecting 'Update existing database'?

As the 1.8.6 code still changes every day, I'll wait a bit with re-applying my customizations. I am discussing with the system team whether we should temporarily close down the 1.8.3 site...
__________________
René Haentjens, Ghent University

Last edited by renehaentjens; 01-05-2005 at 01:18 AM.
renehaentjens is offline   Reply With Quote
Old 01-05-2005, 08:08 PM   #5
vinyl-junkie
Purple Mole
 
Join Date: Jan 2004
Posts: 694
I think I was having a senior moment when I posted in this thread earlier. I had forgotten that I rebuilt my database and version of phpdig from scratch. Sorry about that. I didn't want to leave the impression that I had just upgraded from 1.8.3 to 1.8.6. I have a lot of customized code in mine so it's just easier for me to rebuild from the ground up to make sure all code changes are applied. Even so, I don't think upgrading would result in any lost data for you.

One of the things you might consider if you don't already have it in place is a mirror of phpdig on a test server, or at least a test folder so when upgrades like this come along, you're able to ensure that any changes you apply won't clobber your production application.

I should also mention that one of the things I did while performing the upgrade was to replace my phpdig search page with one that basically said that search was unavailable pending the upgrade. I think it's a nice way of not leaving visitors in the lurch.
vinyl-junkie is offline   Reply With Quote
Old 01-06-2005, 06:34 AM   #6
renehaentjens
Orange Mole
 
Join Date: Nov 2003
Posts: 69
I did a first try on my test server, proceeding as follows:

# - saved a copy of includes/connect.php, config.php
# - made the PhpDig 1.8.3 directory inaccessible
# - restored the 1.8.6 backup to a new directory .../phpdig-1.8.6
# - replaced phpdig-1.8.6/sql/update_db.sql by the merge of update_db_to_1_8_4.sql, update_db_to_1_8_5.sql, and update_db_to_1_8_6.sql, as explained in a reply above
# - ran phpdig-1.8.6/admin/install.php, selecting "Update existing database", and providing the parameters from the old connect.php
# - adapted config.php (cfr. my old config.php)
# - re-applied customizations

Seems to work... no data lost... I'll do more tests and report here when needed.
__________________
René Haentjens, Ghent University
renehaentjens is offline   Reply With Quote
Old 01-06-2005, 05:22 PM   #7
vinyl-junkie
Purple Mole
 
Join Date: Jan 2004
Posts: 694
That's great news! Let us know when you've totally completed the upgrade and how everything went.
vinyl-junkie is offline   Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Upgrade and Update histrenact How-to Forum 2 06-01-2007 03:53 AM
Upgrade probs Dave A Script Installation 1 01-20-2006 04:44 AM
bug? upgrade to 1.8.4 zaartix How-to Forum 2 12-12-2004 06:52 AM
New Upgrade CrazyCanuck Script Installation 9 07-26-2004 05:23 PM
Upgrade xiodaos Script Installation 1 07-19-2004 01:01 PM


All times are GMT -8. The time now is 10:24 PM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright © 2001 - 2005, ThinkDing LLC. All Rights Reserved.