Re: export from mysql to csv file

On Friday 11 June 2004 10:16 pm, Dustin Krysak wrote: > Can anyone point me to an existing script or > tutorial to learn this? > > Thanks in advance! > > d There is a mysql utility that does this: mysqldump -p mypassword -T mytargetdirectory mydatabasename [mytablenames] (The "-T" tells it to dump the data in tab-limited format. Otherwise it generates a series of insert statements.) See: http://dev.mysql.com/doc/mysql/en/mysqldump.html One pointer: the mysql daemon does the writing so the mysql user must have write permission on the target directory. Hope this helps. John --------------------------------------- John Hicks Gulfbridge, Inc. "Putting the Web to work for your business." http://gulfbridge.com 561-586-8116