upgrade a 1.8.3 database to 1.8.6

renehaentjens · 01-04-2005, 07:53 AM

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...

jmitchell · 01-04-2005, 09:31 AM

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

vinyl-junkie · 01-04-2005, 07:25 PM

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.

renehaentjens · 01-05-2005, 01:19 AM

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...

vinyl-junkie · 01-05-2005, 09:08 PM

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.

renehaentjens · 01-06-2005, 07:34 AM

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.

vinyl-junkie · 01-06-2005, 06:22 PM

That's great news! Let us know when you've totally completed the upgrade and how everything went.

01-04-2005, 07: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

01-04-2005, 09: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

01-05-2005, 01: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 02:18 AM.

01-06-2005, 07: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

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

01-05-2005, 09: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.

01-06-2005, 06: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.