PDA

View Full Version : mysqldump with -T [path]?


rsh
11-13-2000, 06:28 PM
Is it possible to use the -T [path] option with mysqldump to send data to a tab-delimied text-file on FutureQuest?

If I use mysqldump from the shell without -T [path] all is well, but if I add -T [path] to the same statement,[nbsp][nbsp]I get "Got Error: 1045: Access denied for user: '[username]@qbert.futurequest.net' (Using password: Yes)".[nbsp][nbsp][path] is a valid path to my directory.

If the -T option isn't available, does anybody have any other solutions for exporting a tab-delimited text file from a MySQL database?

Justin
11-14-2000, 02:21 AM
Taken from </font><font face="Courier" size="3">mysqldump --help</font><font face="Verdana, Arial" size="2">:
</font><font face="Courier" size="3">
-T, --tab=...[nbsp][nbsp][nbsp][nbsp]Creates tab separated textfile for each table to
[nbsp][nbsp][nbsp][nbsp][nbsp][nbsp][nbsp][nbsp][nbsp][nbsp][nbsp][nbsp][nbsp][nbsp][nbsp][nbsp] given path. (creates .sql and .txt files).
[nbsp][nbsp][nbsp][nbsp][nbsp][nbsp][nbsp][nbsp][nbsp][nbsp][nbsp][nbsp][nbsp][nbsp][nbsp][nbsp] NOTE: This only works if mysqldump is run on
[nbsp][nbsp][nbsp][nbsp][nbsp][nbsp][nbsp][nbsp][nbsp][nbsp][nbsp][nbsp][nbsp][nbsp][nbsp][nbsp] the same machine as the mysqld daemon.</font><font face="Verdana, Arial" size="2">
I don't know of any other way to accomplish this, other than to possibly write a script that will log in, select the appropriate information, and format the output as you would like it... SELECT INTO OUTFILE will also not work for the same reasons...

------------------
Justin Nelson
FutureQuest (http://www.FutureQuest.net/index.php) Support