Hi,
> Is there a way to redirect the output of a MySQL statement like SHOW
> VARIABLES to a file?
This is extremely easy. On the command line, simply do the following:
$ mysql -u youruser -p --execute="show variables" > yourfile.txt
For info on various command line arguments (including alternative output
formatting) consult the application's help, by entering:
$ mysql --help
Regards,
Basil Hussain
---------------------------------------
Internet Developer, Kodak Weddings
E-Mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php