Re: [CSCMail-Users] MySQL

[Olli <obi...@gm...>]

Daniel,
 I did the same and also like the speed :-)
I got my adressbook from CSV with the migration-script dbswitch.pl from
the <cscmail-dir>/migration-scripts directory. How ever I had to change
the line

$conn=&open_db_conn;

to something like

$conn=DBI->connect("DBI:mysql:database=databasename;host=localhost",
"dbuser", "dbpassword",{'RaiseError' => 1});

Also I commented out the following line:

# &create_database;

After creating a database and putting the proper permissions to it (I
used xmysqladmin), this script would then setup all the neccessary
tables, e.g. messages, adressbook, accounts ...
At least, I was successful. Hope that helps

Oliver

On 15 Aug 2000 21:37:54 CEST, Dr. Shreger said:

> I recently changed to MySQL and I love the speed improvement.
>  But now I have a little question: is there a possibility to import my
>  old
>  (CSV) Adressbook?
>  I'm using CSCMail 1.6.1
>  
>  Daniel
>  
>  _______________________________________________
>  | Be sure to read the CSCMail FAQ:
>  | http://www.cscmail.net/cscmail.faq
>  |
>  | CSCMail Home Page:
>  | http://www.cscmail.net
>  |
>  | To unsubscribe or change your preferences:
>  | http://lists.sourceforge.net/mailman/listinfo/cscmail-users
>  
>  

-- 
Dulce et decorum
est pro patria mori

Olli B.
Fon: 030-47475624
Mail: obi...@gm...
--