Re: [CSCMail-Users] MySQL

[Daniel S. <np...@gm...>]

I think this is what I searched for, thanks.
The command filled my addresses-table with 50 empty entries instead of 50
addresses and it produced the following output on the console.

npfdd.addresses: Records: 50  Deleted: 0  Skipped: 0  Warnings: 200

I finally figured out that the command should have been

mysqlimport -l -p --fields-terminated-by=, databasename addresses

Daniel

PS: How do I export from mysql? (for a backup for example)


On Tue, 15 Aug 2000 22:22:39 -0400 (EDT), Mark Neill MIDTIER wrote:

> OK, I found the info I needed without the book....
>  
>  Move the addressbook to a file named "addresses", and in that
>  directory,
>  run the following command (I think, I haven't tried it...)
>  
>  mysqlimport -L -p=password --fields-enclosed-by=, databasename
>  addresses
>  
>     Where password is (of course) your password
>  
>     Where databasename is your username on your system, 
>     assuming you set up the CSCMail/MySQL interface by the books
>  
>  
>  Hope this is right....
>  
>  --Mark
>  
>  
>  Mark Neill
>  Enterprise Backup &
>    UNIX Administrator
>  CSX Technology
>  Mar...@cs...
>  
>  On 15 Aug 2000, Dr. Shreger wrote:
>  
>  > 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