By heisters on

Hi all,

I've got a crufty Drupal installation (4.5) that my predecessor didn't document at all, and I've finally decided that it's hopeless trying to upgrading it. So I've decided to start from scratch with a new installation of 4.6. However, it is necessary that I keep the users' old content. Is there any way I can upgrade the database on its own to 4.6's schema, then install 4.6 from scratch and overwrite its database with the upgraded db? I'm fine throwing out any data that doesn't have to do with the core functionality--all I really want is the blogs and comments.

Furthermore, I'm no stranger to MySQL or PHP, so if there's somewhere I could just get the SQL statements in order to do it by hand, I'd be fine with that.

Thanks much.

⋅ Categories: Drupal 4.5.x or older, Drupal 4.6.x

Comments

heisters’s picture

heisters commented

Well, I sort of figured it out. I dumped the old database into a new one on the new server, called it drupal_old. Then ran the following to load the data into the new drupal's db (drupal). It seems to work for the moment. If someone sees a flaw that might get me at some later date, please give me a heads up.

insert into users select distinct \
uid, name, pass, mail, mode, sort, threshold, theme, signature, created, \
changed, status, timezone, language, picture, init, data \
from drupal_old.users where drupal_old.users.uid > 1;

insert into drupal.node \
(nid, type, title, uid, status, created, changed, comment, \
 promote, moderate, teaser, body, revisions, sticky) \
select nid, type, title, uid, status, created, changed, comment, \
 promote, moderate, teaser, body, revisions, sticky
from drupal_old.node;

insert into drupal.comments \
(cid, pid, nid, uid, subject, comment, hostname, timestamp, score, \
status, thread, users) \
select cid, pid, nid, uid, subject, comment, hostname, timestamp, score, \
status, thread, users \
from drupal_old.comments;

update sequences set id=1015 where name='users_id';
update sequences set id=768 where name='node_nid';
update sequences set id=1169 where name='comments_cid';

insert into sequences select * from drupal_old.sequences;