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

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to