Re: exporting mysql table into csv file

[Charles Menzes <charles@lunarmedia.net>]

I'm dealing with some fairly large tables, so I'd like to just use a 
cron'd mysqldump routine to create the .txt file that can be statically 
linked to using an ssl encrypted and htaccess protected webpage.

 mysqldump -T --fields-terminated-by=',' db_name table_name

I'm guessing that my -T field is missing some param, but I'm not sure 
what. The option name, --tab, doesnt really imply anything to me, but I'm 
new to databases. I'm just using it to shove data pulled via snmp into.

I need a csv file so that I can allow other users to import the data into 
excel or access databases.

thanks -c

On Wed, 25 Sep 2002, Benjamin Story wrote:

> I've never used mysqldump, but phpmyadmin does a nice job of this.
> On Wed, Sep 25, 2002 at 03:59:53PM -0500, Charles Menzes wrote:
> > I've been struggling all afternoon with trying to get a table's contents 
> > exported into a csv file using mysqldump. Can anyone give me proper syntax 
> > to do this? I keep trying various combinations of --fields-terminated-by 
> > and --fields-escaped-by, but to no luck.
> > 
> > Any help is appreciated.
> > 
> > Thanks -c
> > 
> > 
> > -
> > To unsubscribe, send email to majordomo@luci.org with
> > "unsubscribe luci-discuss" in the body.
> 
> 


-
To unsubscribe, send email to majordomo@luci.org with
"unsubscribe luci-discuss" in the body.