How to upgrade database from 4.7.0 to 4.7.1

By chaos21in on 27 May 2006 at 10:22 UTC

I just patched my old 4.7.0 version of drupal with the 2 patches as mentioned in http://drupal.org/drupal-4.7.1 .It is also written that i need to upgrade my database. I can see the difference in database . But dont know how to apply it, i mean upgrade my existing database with the new one.

the diff of two versions are:

< -- $Id: database.4.1.mysql,v 1.1.2.1 2006/05/23 18:45:47 killes Exp $
---
> -- $Id: database.4.1.mysql,v 1.1 2006/04/10 13:45:28 unconed Exp $
443,444c443
<   PRIMARY KEY  (nid, vid),
<   UNIQUE KEY vid (vid),
---
>   PRIMARY KEY (nid),
446c445
<   KEY node_title_type (title, type(4)),
---
>   KEY node_title_type (title,type(4)),
448a448
>   KEY vid (vid),
453,454c453
<   KEY node_status_type (status, type, nid),
<   KEY nid (nid)
---
>   KEY node_status_type (status, type, nid)
509d507
<   autocomplete tinyint(1) DEFAULT '0' NOT NULL,
683c681
<   nid int(10) NOT NULL default '0',
---
>   nid int(11) NOT NULL default '0',

Also let me know, if there any harm if i choose not to upgarde this database.

--rafi

Comments

It's a breeze!

marcoBauli commented 27 May 2006 at 10:28

just go to URL www.yoursite.com/upgrade.php

to run the upgrade script. it's pretty automatic, if you see no errors than that's should be it =)

Marco

didnt happen

chaos21in commented 27 May 2006 at 10:42

Hi
Thanks for reply. I did go to http://www.msite.com/upgrade.php . And then clicked on http://www.mysite.com/update.php?op=selection link. It gives a list of modules to be upgarded. And in options to each ..just say "no updates available".

I also did try anyway to click upgarde after putting the new database.4.1.mysql of 4.7.1 in the existing database folder of drupal after backing up old version of the same. But when tried to see the database in mysql through phpmyadmin ..its still show me old version of database and not new. I found out by seeing "nid" int size in table node_counter which is 10 in new version but was 11 in old.

any idea what mistake i am making ..or what else i should do.

regards,
--rafi

...

marcoBauli commented 27 May 2006 at 11:01

yep, that was too easy..

did you try following the other upgrade option, replacing all drupal core files?

I guess there is a file that tells which tables are to be updated, and this could be a file in the "/includes" folder (database.inc, database.mysql.inc, install.inc ...)

this is all i can imagine.

...

chaos21in commented 27 May 2006 at 14:15

yes i manually patched all these files rather than replacing whole core directory, as i assume there are minor changes in only 3-4 files, which works easily with patch. I also put new database.4.1.mysql file in database folder and did run update.php script as i mentioned in my previous posting...but nothing happend in dataabase. Dont know why?

as far as i can see in patch files , the patches are only for :
database.mysqli.inc, database.mysql.inc, database.pgsql.inc, file.inc and INSTALL.txt and not for install.inc file.

--rafi