Mailing List Archive

Am 08.04.2015 um 11:15 schrieb Ralph Ballier:
> Hello,
>
> I still use the version 2.2.18 because I have seen on the previous
> computer only MySQL 4 and not MySQL 5. A switch to the new version of
> MySQL is too risky to me.
>
> Now I would instead run dbmail on a new computer. I have the file
> "dbmail.conf" viewed from version dbmail3. Since I do not understand
> even the first line:
>
> dburi = sqlite: ///var/tmp/dbmail.db
>
> What do you mean with that? Where now is the user ID and password? Is
> "sqlite" at all correct for MySQL ???

no

dburi =
mysql://dbmail:***@localhost/dbmail?unix-socket=/var/lib/mysql/mysql.sock&charset=utf8

Hello Harald,

many thanks for the answer. dburi I understand now.

Now I am planning to move from the previous computer with dbmail 2 to
the new computer with dbmail 3. The database has a size of about 30 GB.

Can I do the following now?

1. I stop on the old machine all dbmail-demons.
2. I create with 'mysqldump' a file with the existing data in the
database 'dbmail'.
3. I read the file on the new computer into an empty database without
tables. When reading all tables are created.
4. I run the update script from dbmail 3.
5. I take care of /etc/dbmail.conf and start the dbmail-demons.

Thanks
Ralph

----------------ursprüngliche Nachricht-----------------
Von: Reindl Harald [h.reindl@thelounge.net ]
An: dbmail@dbmail.org Datum: Wed, 08 Apr 2015 11:45:48 +0200
-------------------------------------------------


>
> Am 08.04.2015 um 11:15 schrieb Ralph Ballier:
> [.....]
> Since I do not understand
>> even the first line:
>>
>> dburi = sqlite: ///var/tmp/dbmail.db
>>
>> What do you mean with that? Where now is the user ID and password? Is
>> "sqlite" at all correct for MySQL ???
>
> no
>
> dburi = mysql://dbmail:***@localhost/dbmail?unix-socket=/var/lib/mysql/mysql
> .sock&charset=utf8
>
>


_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Am 08.04.2015 um 15:20 schrieb Ralph Ballier:
> Hello Harald,
>
> many thanks for the answer. dburi I understand now.
>
> Now I am planning to move from the previous computer with dbmail 2 to
> the new computer with dbmail 3. The database has a size of about 30 GB.
>
> Can I do the following now?
>
> 1. I stop on the old machine all dbmail-demons.
> 2. I create with 'mysqldump' a file with the existing data in the
> database 'dbmail'.
> 3. I read the file on the new computer into an empty database without
> tables. When reading all tables are created.
> 4. I run the update script from dbmail 3.
> 5. I take care of /etc/dbmail.conf and start the dbmail-demons.
>

Don't forget to run dbmail-util to migrate mimeparts :)

Regards

On 08-04-15 11:15, Ralph Ballier wrote:
> I still use the version 2.2.18 because I have seen on the previous
> computer only MySQL 4 and not MySQL 5. A switch to the new version of
> MySQL is too risky to me.
I know I'm not answering you question, but this needs to be said:

You have your priorities screwed. Upgrade MySQL first!

MySQL 4.1.25 stopped getting updates in 2009! Here is a list of Security
issues for MySQL:
http://www.cvedetails.com/vulnerability-list/vendor_id-185/product_id-316/Mysql-Mysql.html

There is no risk in running MySQL 5.5. It's much faster. Much more
stable and a better support ecosystem with live backups and such.

The innodb file format hasn't changed much and the upgrade should be
very smooth. I've upgraded all of my MySQL servers through the years and
never experienced big issues, except for configuration file changes that
stopped MySQL from starting. Build a staging server, create your
configuration file, then upgrade your MySQL 4 server using that config file.
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Hello and sorry for the long delay.

Now I have time to occupy myself with the transition from 2 to dbmail
dbmail 3.

I've discovered that mysql 5 (and not mysql 4) runs on the computer.
In addition, I managed with some problems to compile dbmail 3.2.3. So
I do not need to change the computer.

To update from 2 to 3 I have a few questions:
- Which SQL file I need to use for the move? I now have the version
2.2.18 dbmail and there in the SQL directory not a file that fits
exactly.
- Do I have to use another file?
- Do I have to use additional dbmail-utils to bring data up to date?

Why always comes the answer

"This is mhash 0.99"

if I "dbmail-util -V" or "dbmail-imapd -V" enter?

Thank you very much

Ralph


_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail