Fwd: mysqlhotcopy ignores --host or -h option

He's right. GetOptions doesn't list host|h, even though other code
in the script assumes that option can be used.

This is true in the 3.23, 4.0, and 4.1 trees.

How-To-Repeat:

>Mailing-List: contact mysql-help@lists.mysql.com; run by ezmlm
>(http://www.ezmlm.org)
>Delivered-To: mailing list mysql@lists.mysql.com
>From: Holger.Manthey@Bertelsmann.de
>To: mysql@lists.mysql.com
>Subject: mysqlhotcopy ignores --host or -h option
>Date: Wed, 13 Nov 2002 17:31:48 +0100
>
> >Description:
> mysqlhotcopy ignores --host -h option
>>How-To-Repeat:
> call mysqlhotcopy with a host differs from localhost
>>Fix:
> Add "host|h=s" to GetOptions
>
>>Submitter-Id:
>>Originator:
>>Organization:
>
>>MySQL support: none
>>Synopsis:
>>Severity: non-critical
>>Priority: low
>>Category: mysql
>>Class: sw-bug
>>Release: mysql-3.23.53 (Source distribution)
>
>>Environment:
>
>System: Linux debmu401 2.4.19 #1 SMP Tue Sep 10 09:00:50 CEST 2002 i686
>unknown
>Architecture: i686
>
>Some paths: /DBA/public/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
>/usr/bin/cc
>GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
>gcc version 2.96 20000731 (Red Hat Linux 7.2 2.96-108.7.2) Compilation info:
>CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS=''
>LIBC:
>lrwxrwxrwx 1 root root 13 Sep 2 15:53 /lib/libc.so.6 ->
>libc-2.2.4.so
>-rwxr-xr-x 1 root root 5735106 Aug 7 13:03 /lib/libc-2.2.4.so
>-rw-r--r-- 1 root root 27336078 Aug 7 12:56 /usr/lib/libc.a
>-rw-r--r-- 1 root root 178 Aug 7 12:57 /usr/lib/libc.so
>Configure command: ./configure --prefix=/DBA/mysql/SQL/3.23.53
>--enable-thread-safe-client
>
>----------------------------------------------------------- ----------
>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
>To unsubscribe, e-mail
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


------------------------------------------------------------ ---------
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 bugs-thread12979@lists.mysql.com
To unsubscribe, e-mail

Re: Fwd: mysqlhotcopy ignores --host or -h option

At 14:26 +0300 11/14/02, Peter Zaitsev wrote:
>On Wednesday 13 November 2002 19:44, Paul DuBois wrote:
>> He's right. GetOptions doesn't list host|h, even though other code
>> in the script assumes that option can be used.
>>
>> This is true in the 3.23, 4.0, and 4.1 trees.
>
>
>The reason is - mysqlhotcopy works by copying files which does not really work
>with databases on non local host.

That's not the reason for --host with mysqlhotcopy. As mysqlhotcopy --help
says:

-h, --host=# Hostname for local server when connecting over TCP/IP

The reason for --host is to allow you to specify 127.0.0.1 or the actual
host name of the *local* host, so that you can establish a connection over
TCP/IP (rather than through the UNIX socket). Otherwise the --port option
can't have any effect.

The help message includes --host, and the script includes code to handle
the option:

my $dsn;
$dsn = ";host=" . (defined($opt{host}) ? $opt{host} : "localhost");
$dsn .= ";port=$opt{port}" if $opt{port};
$dsn .= ";mysql_socket=$opt{socket}" if $opt{socket};

But the GetOptions() call doesn't list host|h, so the option cannot
be used! It's a one-line fix, needs to be made in all trees.

>
>One may extend it to use scp/rcp but This still requires some work.
>
>
>--
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Mr. Peter Zaitsev
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
> /_/ /_/\_, /___/\___\_\___/ Moscow, Russia
> <___/ www.mysql.com M: +7 095 725 4955

filter fodder:
How-To-Repeat:

------------------------------------------------------------ ---------
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 bugs-thread12989@lists.mysql.com
To unsubscribe, e-mail

Re: Fwd: mysqlhotcopy ignores --host or -h option

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thursday 14 November 2002 15:52, Paul DuBois wrote:

> That's not the reason for --host with mysqlhotcopy. As mysqlhotcopy --=
help
> says:
>
> -h, --host=3D# Hostname for local server when connecting ove=
r
> TCP/IP
>
> The reason for --host is to allow you to specify 127.0.0.1 or the actua=
l
> host name of the *local* host, so that you can establish a connection o=
ver
> TCP/IP (rather than through the UNIX socket). Otherwise the --port opt=
ion
> can't have any effect.
>
> The help message includes --host, and the script includes code to handl=
e
> the option:
>
> my $dsn;
> $dsn =3D ";host=3D" . (defined($opt{host}) ? $opt{host} : "localhost")=
;
> $dsn .=3D ";port=3D$opt{port}" if $opt{port};
> $dsn .=3D ";mysql_socket=3D$opt{socket}" if $opt{socket};
>
> But the GetOptions() call doesn't list host|h, so the option cannot
> be used! It's a one-line fix, needs to be made in all trees.

Thanks for spotting this - I added the missing option to the 3.23 tree
and it will be propagated to the other trees with the next merge.

Bye,
=09LenZ
- --=20
For technical support contracts, visit https://order.mysql.com/?ref=3Dmlg=
r
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Lenz Grimmer
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer
/_/ /_/\_, /___/\___\_\___/ Hamburg, Germany
<___/ www.mysql.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.0 (GNU/Linux)

iD8DBQE91EWqSVDhKrJykfIRAsKPAJ9/pYTzjauLSUcCMAHSqZNttQrgwQCd EOT+
42pthj/M4SreGJs9YcRdV44=3D
=3DNGXN
-----END PGP SIGNATURE-----

------------------------------------------------------------ ---------
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 bugs-thread12997@lists.mysql.com
To unsubscribe, e-mail