Re: [CSCMail-Users] Change of Database

[Count Z. <cou...@cy...>]

PRW was overheard mumbling something about this on 13 Sep 2000 02:40:41 MST

>  I've been working with the CSV database but now want to change to MySql. 
>  How do I do this so CSC 1.7.8 will recognize the database.
>  
>  Thanks
>  Paul

There is a script in cscmail/migration-scripts called dbswitch.pl that will
handle this for you...

Step one:

install DBD::mysql via CPAN or tarball so that you have the correct perl
drivers for MySQL

Step Two:

make an empty DB that is the same as your username.

Step Three:

cd to the cscmail directory
./migration-scripts/dbswitch.pl CSV mysql

This MUST be run from your cscmail base directory (where csclib.pl is sitting)
since it uses csclib.pl to figure out the most current db structure.

Then edit ~/.cscmailrc and change DatabaseDriver: CSV to DatabaseDriver: mysql

(You may need to put in a username and password too....)

-CZ