Marten Lehmann [EMAIL PROTECTED] wrote:
what are the defaults for the following options?
net_read_timeout
30 seconds.
net_write_timeout
60 seconds.
See http://dev.mysql.com/doc/mysql/en/Server_system_variables.html for details.
--
For technical support contracts, goto
/etc/my.cnf: Global options
DATADIR/my.cnf: Server-specific options
defaults-extra-file: The file specified with --defaults-extra-file=#
~/.my.cnf: User-specific options
By default, data is in /var/lib/mysql.
Jon Miller wrote:
Can someone tell me how do I find the default settings in MySQL.
You can just add DEFAULT keyword followed by the default value in the column
definition and use it either when creating a new table or altering a table
to add/set a default value to its column(s)..
See: http://www.mysql.com/doc/C/R/CREATE_TABLE.html