Msql-Mysql-modules

 view release on metacpan or  search on metacpan

ChangeLog  view on Meta::CPAN

	  _NumRows have been removed.
	* dbd/dbd.xs.in: $dbh->func('_ListDBs') was closing the socket.
	  Thanks to Lars Kellogg-Stedman <lars@wolery.bu.edu>.
	* dbd/dbd.pm.in: $drh->func('_ListDBs' was documented wrong.
	  Thanks to Lars Kellogg-Stedman <lars@wolery.bu.edu>.

1998-11-06  Jochen Wiedmann  <joe@ispsoft.de> (1.21_06)

	* dbd/dbdimp.c: Changed isspace(c) to c == ' ' in ChopBlanks
	  handling.
	* dbd/dbdimp.c: Added $dbh->{'mysql_read_default_file'} and
	  $dbh->{'mysql_read_default_group'}.
	* dbd/dbdimp.c: Added $dbh->{'mysql_insertid'}.

1998-10-23  Jochen Wiedmann  <joe@ispsoft.de> (1.21_05)

	* dbd/dbd.xs.in: Fixed bug in $dbh->quote($n, SQL_INTEGER).
	* Makefile.PL (CheckForLibGcc()): Disabled linking against
	  libgcc.a under NetBSD. (Curt Sampson, cjs@portal.com)
	* Forgot to remove the warning for experimental software.
	* Added Monty's patches for use of mysqlclients.

README  view on Meta::CPAN

        mysql_compression
                As of MySQL 3.22.3, a new feature is supported: If your DSN
                contains the option "mysql_compression=1", then the
                communication between client and server will be compressed.

        mysql_connect_timeout
                If your DSN contains the option "mysql_connect_timeout=##",
                the connect request to the server will timeout if it has not
                been successful after the given number of seconds.

        mysql_read_default_file
        mysql_read_default_group
                These options can be used to read a config file like
                /etc/my.cnf or ~/.my.cnf. By default MySQL's C client
                library doesn't use any config files unlike the client
                programs (mysql, mysqladmin, ...) that do, but outside of
                the C client library. Thus you need to explicitly request
                reading a config file, as in

                    $dsn = "DBI:mysql:test;mysql_read_default_file=/home/joe/my.cnf";
                    $dbh = DBI->connect($dsn, $user, $password)

                The option mysql_read_default_group can be used to specify
                the default group in the config file: Usually this is the
                *client* group, but see the following example:

                    [perl]
                    host=perlhost

                    [client]
                    host=localhost

                If you read this config file, then you'll be typically
                connected to *localhost*. However, by using

                    $dsn = "DBI:mysql:test;mysql_read_default_group=perl;"
                        . "mysql_read_default_file=/home/joe/my.cnf";
                    $dbh = DBI->connect($dsn, $user, $password);

                you'll be connected to *perlhost*. Note that if you specify
                a default group and do not specify a file, then the default
                config files will all be read. See the (missing :-)
                documentation of the C function mysql_options() for details.

        mysql_socket
                As of MySQL 3.21.15, it is possible to choose the Unix
                socket that is used for connecting to the server. This is

dbd/dbd.pm.in  view on Meta::CPAN

As of MySQL 3.22.3, a new feature is supported: If your DSN contains
the option "mysql_compression=1", then the communication between client
and server will be compressed.

=item mysql_connect_timeout

If your DSN contains the option "mysql_connect_timeout=##", the connect
request to the server will timeout if it has not been successful after
the given number of seconds.

=item mysql_read_default_file

=item mysql_read_default_group

These options can be used to read a config file like /etc/my.cnf or
~/.my.cnf. By default MySQL's C client library doesn't use any config
files unlike the client programs (mysql, mysqladmin, ...) that do, but
outside of the C client library. Thus you need to explicitly request
reading a config file, as in

    $dsn = "DBI:mysql:test;mysql_read_default_file=/home/joe/my.cnf";
    $dbh = DBI->connect($dsn, $user, $password)

The option mysql_read_default_group can be used to specify the default
group in the config file: Usually this is the I<client> group, but
see the following example:

    [perl]
    host=perlhost

    [client]
    host=localhost

If you read this config file, then you'll be typically connected to
I<localhost>. However, by using

    $dsn = "DBI:mysql:test;mysql_read_default_group=perl;"
        . "mysql_read_default_file=/home/joe/my.cnf";
    $dbh = DBI->connect($dsn, $user, $password);

you'll be connected to I<perlhost>. Note that if you specify a
default group and do not specify a file, then the default config
files will all be read.  See the (missing :-) documentation of
the C function mysql_options() for details.

=item mysql_socket

As of MySQL 3.21.15, it is possible to choose the Unix socket that is

dbd/dbdimp.c  view on Meta::CPAN

		if ((svp = hv_fetch(hv, "mysql_connect_timeout", 21, FALSE))
		    &&  *svp  &&  SvTRUE(*svp)) {
		  int to = SvIV(*svp);
		  if (dbis->debug >= 2)
		    PerlIO_printf(DBILOGFP,
				  "imp_dbh->MyConnect: Setting" \
				  " connect timeout (%d).\n",to);
		  mysql_options(*sock, MYSQL_OPT_CONNECT_TIMEOUT,
				(const char *)&to);
		}
		if ((svp = hv_fetch(hv, "mysql_read_default_file", 23,
				    FALSE))  &&
		    *svp  &&  SvTRUE(*svp)) {
		    char* df = SvPV(*svp, lna);
		    if (dbis->debug >= 2)
		        PerlIO_printf(DBILOGFP,
				      "imp_dbh->MyConnect: Reading" \
				      " default file %s.\n", df);
		    mysql_options(*sock, MYSQL_READ_DEFAULT_FILE, df);
		}
		if ((svp = hv_fetch(hv, "mysql_read_default_group", 24,

mysql/lib/DBD/mysql.pm  view on Meta::CPAN

As of MySQL 3.22.3, a new feature is supported: If your DSN contains
the option "mysql_compression=1", then the communication between client
and server will be compressed.

=item mysql_connect_timeout

If your DSN contains the option "mysql_connect_timeout=##", the connect
request to the server will timeout if it has not been successful after
the given number of seconds.

=item mysql_read_default_file

=item mysql_read_default_group

These options can be used to read a config file like /etc/my.cnf or
~/.my.cnf. By default MySQL's C client library doesn't use any config
files unlike the client programs (mysql, mysqladmin, ...) that do, but
outside of the C client library. Thus you need to explicitly request
reading a config file, as in

    $dsn = "DBI:mysql:test;mysql_read_default_file=/home/joe/my.cnf";
    $dbh = DBI->connect($dsn, $user, $password)

The option mysql_read_default_group can be used to specify the default
group in the config file: Usually this is the I<client> group, but
see the following example:

    [perl]
    host=perlhost

    [client]
    host=localhost

If you read this config file, then you'll be typically connected to
I<localhost>. However, by using

    $dsn = "DBI:mysql:test;mysql_read_default_group=perl;"
        . "mysql_read_default_file=/home/joe/my.cnf";
    $dbh = DBI->connect($dsn, $user, $password);

you'll be connected to I<perlhost>. Note that if you specify a
default group and do not specify a file, then the default config
files will all be read.  See the (missing :-) documentation of
the C function mysql_options() for details.

=item mysql_socket

As of MySQL 3.21.15, it is possible to choose the Unix socket that is