Humberto Valiente wrote:
> We are actually running and "very" but "very old version" of dbmail
> More specifically, we are running version 1.105.2.3 <http://1.105.2.3>
> 2004/12/27 21:41:07 paul Exp $
That looks like a CVS version, and I know I never worked on the 1.2
series (unless you're running debian packages). The switch to SVN took
place during the very early 2.0 releases.
>
> It is working perfectly but we want to change it to the latest stable
> version 2.0.10
>
> Could be problems doing the upgrade? or the precedure is the same than
> older versions?
You need to confirm you're running 2.0. Do you have a physmessages
table? Show us your table layout. You will probably need to fix some
small things here and there. The fool-proof way I use is to use diff.
1 $> mysqldump -d dbmail > current_schema.sql
2 %> mysqladmin create dbmail2
3 %> mysql dbmail2 < dbmail-2.0.10/sql/mysql/create_tables.mysql
4 %> mysqldump -d dbmail2 > new_schema.sql
5 %> diff current_schema.sql new_schema.sql
6 %> vi migration.sql
7 %> cat dbmail-2.0.10/sql/mysql/create_tables.mysql \
migration.sql | mysql dbmail2
go back to step 4 and tweak migration.sql untill the diff is empty. You
now have a safe migration script to lauch against you main db (after
making a backup).
Also check your cron scripts.
--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
