Can you use the -w/--where option in mysqldump to dump only the records you want?
-----Original Message----- From: Tucker, Gabriel To: Mysql General (E-mail) Sent: 8/20/04 8:07 AM Subject: Remotely dumping data to a file Hi All I would like to dump certain data remotely from a table. I am unable to use mysqldump because I do not want to dump the entire table. The "select into outfile" will not work when the connection is remote. I saw in the manual that "mysql -e" would do what I want. However, that is not true. The output from this is formatted, I want it unformatted, like the mysqldump command. I could take the output from the "mysql -e" command and formatted the way I would like. Before doing this, I wanted to know if there is another option. Thanks! <><><><><><><><><><><><><><><><><><><><><> "There are no problems, only solutions." Gabe Tucker Bloomberg LP (609) 750 6668 - P (646) 268 5681 - F <><><><><><><><><><><><><><><><><><><><><> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
