Re: Database access in version 3

Ralph Ballier <[email protected]>
Newsgroups gmane.mail.imap.dbmail
Message-ID <20150408152019.EGroupware.mhtndhqAW2oUf_b6LfXgCA5@egroupware.osz-lise-meitner.eu>
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 [[email protected]  ]
An: [email protected]  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
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.