Changes from pre-1.0 to 1.0-final were many. Table layout didn't change
very much, but many fields were renamed, fields were added, some tables
were added and dropped, indexes were a total mess.... iirc.
So you would first have to update to 1.x. After that there are some very
complete conversion sql files for moving from 1.x to 2.x. Those latter
changes are far from trivial.
As far as 0.x to 1.x is concerned what I did:
mysqldump -d dbmail > dbmail.0.x.sql
mysqladmin create dbmailold
mysql dbmailold < dbmail.0.x.sql
mysqladmin create dbmailnew
mysql dbmailtest < sql/mysql/create_tables.mysql
mysqldump -d dbmailnew > dbmail-1.2
Now start changing dbmailold until diffing the mysqldumps gives you none
but trivial differences.
When I updated a pre 1.0 installation to 1.0 I ended up with sql as
attached. Should give you a good start.
Guy Redwood wrote:
Hi
We've been running dbmail for a long time - version 0.9, it worked well for
us so we never needed to upgrade to newer versions. Anyway, we've got a new
server so I'm going to install the latest v2 and then keep it up-to-date
with releases. As far as transfering email from the old db to the new I
think I've got two options:
1. Work out the table differences between 0.l9 and 2rc7, then run a few
lines of sql to copy mailboxes etc across.
2. drag the imap folders across for each account from the old server to the
new server using an imap client.
Does anybody know how feasible option 1 is?
Guy
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
--
________________________________________________________________
Paul Stevens mailto:[EMAIL PROTECTED]
NET FACILITIES GROUP PGP: finger [EMAIL PROTECTED]
The Netherlands________________________________http://www.nfg.nl
alter table aliases change client_id client_idnr bigint(21) DEFAULT '0' NOT
NULL;
alter table aliases drop index alias_idnr;
alter table aliases add index alias (alias);
rename table mailbox to mailboxes;
alter table mailboxes change mailboxidnr mailbox_idnr bigint(21) DEFAULT '0'
NOT NULL auto_increment;
alter table mailboxes change owneridnr owner_idnr bigint(21) DEFAULT '0' NOT
NULL;
rename table message to messages;
alter table messages change messageidnr message_idnr bigint(21) DEFAULT '0' NOT
NULL auto_increment;
alter table messages change mailboxidnr mailbox_idnr bigint(21) DEFAULT '0' NOT
NULL;
alter table messages add rfcsize bigint(21) DEFAULT '0' NOT NULL;
alter table messages drop index messageidnr_2;
alter table messages add unique message_idnr_2 (message_idnr);
alter table messages drop index messageidnr;
alter table messages add index message_idnr (message_idnr);
rename table messageblk to messageblks;
alter table messageblks change messageblknr messageblk_idnr bigint(21) DEFAULT
'0' NOT NULL auto_increment;
alter table messageblks change messageidnr message_idnr bigint(21) DEFAULT '0'
NOT NULL;
alter table messageblks drop index messageblknr_2;
alter table messageblks add unique key messageblk_idnr_2 (messageblk_idnr);
alter table messageblks drop index messageblknr;
alter table messageblks add index messageblk_idnr (messageblk_idnr);
rename table user to users;
alter table users change useridnr user_idnr bigint(21) DEFAULT '0' NOT NULL
auto_increment;
alter table users change clientid client_idnr bigint(21) DEFAULT '0' NOT NULL;
alter table users add encryption_type varchar(20) DEFAULT '' NOT NULL;
alter table users add last_login DATETIME DEFAULT '1979-11-03 22:05:58' NOT
NULL;
alter table users add UNIQUE userid_2 (userid);
alter table users drop index useridnr;
alter table users add index user_idnr(user_idnr,userid);
CREATE TABLE auto_notifications (
auto_notify_idnr bigint(21) default '0' not null auto_increment,
user_idnr bigint(21) DEFAULT '0' NOT NULL,
notify_address VARCHAR(100),
PRIMARY KEY (auto_notify_idnr)
);
CREATE TABLE auto_replies (
auto_reply_idnr bigint(21) DEFAULT '0' NOT NULL auto_increment,
user_idnr bigint(21) DEFAULT '0' NOT NULL,
reply_body mediumtext,
PRIMARY KEY (auto_reply_idnr)
);
CREATE TABLE tmpmessage (
message_idnr bigint(21) DEFAULT '0' NOT NULL auto_increment,
mailbox_idnr int(21) DEFAULT '0' NOT NULL,
messagesize bigint(21) DEFAULT '0' NOT NULL,
seen_flag tinyint(1) default '0' not null,
answered_flag tinyint(1) default '0' not null,
deleted_flag tinyint(1) default '0' not null,
flagged_flag tinyint(1) default '0' not null,
recent_flag tinyint(1) default '0' not null,
draft_flag tinyint(1) default '0' not null,
unique_id varchar(70) NOT NULL,
internal_date datetime default '0' not null,
status tinyint(3) unsigned zerofill default '000' not null,
PRIMARY KEY (message_idnr),
KEY message_idnr (message_idnr),
UNIQUE message_idnr_2 (message_idnr)
);
CREATE TABLE tmpmessageblk (
messageblk_idnr bigint(21) DEFAULT '0' NOT NULL auto_increment,
message_idnr bigint(21) DEFAULT '0' NOT NULL,
messageblk longtext NOT NULL,
blocksize bigint(21) DEFAULT '0' NOT NULL,
PRIMARY KEY (messageblk_idnr),
KEY messageblk_idnr (messageblk_idnr),
KEY msg_index (message_idnr),
UNIQUE messageblk_idnr_2 (messageblk_idnr)
);
