Bug #4287 for DBD-mysql: mysqlhotcopy don't work in 2.9002 and 2.9003

Tue Nov 04 08:14:03 2003 Guest - Ticket created

Subject:

mysqlhotcopy don't work in 2.9002 and 2.9003

Hi, mysqlhotcopy 1.19 don't work anymore after upgrade to version 2.9002 and 2.9003. 2.1028 works normally. debug: --2.9003-- Filtering tables with '(?-xism:.*)' $VAR1 = [ { 'index' => [], 'src' => 'email', 'raid_dirs' => [], 'tables' => [], 'files' => [ 'alias.MYD', 'alias.MYI', 'alias.frm', 'usuarios.MYD', 'usuarios.MYI', 'usuarios.frm' ], 't_regex' => '.*', 'target' => '/root/lixo//email' } ]; No tables to hot-copy at /usr/bin/mysqlhotcopy line 379. ---- --2.1028-- Filtering tables with '(?-xism:.*)' $VAR1 = [ { 'index' => [], 'src' => 'email', 'raid_dirs' => [], 'tables' => [ '`email`.`alias`', '`email`.`usuarios`' ], 'files' => [ 'alias.MYD', 'alias.MYI', 'alias.frm', 'usuarios.MYD', 'usuarios.MYI', 'usuarios.frm' ], 't_regex' => '.*', 'target' => '/root/lixo//email' } ]; Locked 2 tables in 0 seconds. Flushed tables (`email`.`alias`, `email`.`usuarios`) in 0 seconds. Copying 6 files... Executing 'cp -p '/grupos/mysql/email/alias.MYD' '/grupos/mysql/email/alias.MYI' '/grupos/mysql/email/alias.frm' '/grupos/mysql/email/usuarios.MYD' '/grupos/mysql/email/usuarios.MYI' '/grupos/mysql/email/usuarios.frm' '/root/lixo//email'' Copying indices for 0 files... Unlocked tables. mysqlhotcopy copied 2 tables (6 files) in 0 seconds (0 seconds overall). ---- Regards.

Tue Nov 04 08:17:48 2003 Guest - Correspondence added

From:

Marcus grando

[guest - Tue Nov 4 08:14:03 2003]: The system is FreeBSD 4.9-RELEASE. p5-DBI-1.37 installed with ports and p5-DBD-mysql too Show quoted text

> Hi, > > mysqlhotcopy 1.19 don't work anymore after upgrade to version 2.9002 > and 2.9003. 2.1028 works normally. > > debug: > --2.9003-- > Filtering tables with '(?-xism:.*)' > $VAR1 = [ > { > 'index' => [], > 'src' => 'email', > 'raid_dirs' => [], > 'tables' => [], > 'files' => [ > 'alias.MYD', > 'alias.MYI', > 'alias.frm', > 'usuarios.MYD', > 'usuarios.MYI', > 'usuarios.frm' > ], > 't_regex' => '.*', > 'target' => '/root/lixo//email' > } > ]; > No tables to hot-copy at /usr/bin/mysqlhotcopy line 379. > ---- > --2.1028-- > Filtering tables with '(?-xism:.*)' > $VAR1 = [ > { > 'index' => [], > 'src' => 'email', > 'raid_dirs' => [], > 'tables' => [ > '`email`.`alias`', > '`email`.`usuarios`' > ], > 'files' => [ > 'alias.MYD', > 'alias.MYI', > 'alias.frm', > 'usuarios.MYD', > 'usuarios.MYI', > 'usuarios.frm' > ], > 't_regex' => '.*', > 'target' => '/root/lixo//email' > } > ]; > Locked 2 tables in 0 seconds. > Flushed tables (`email`.`alias`, `email`.`usuarios`) in 0 seconds. > Copying 6 files... > Executing 'cp -p '/grupos/mysql/email/alias.MYD' > '/grupos/mysql/email/alias.MYI' '/grupos/mysql/email/alias.frm' > '/grupos/mysql/email/usuarios.MYD' > '/grupos/mysql/email/usuarios.MYI' > '/grupos/mysql/email/usuarios.frm' '/root/lixo//email'' > Copying indices for 0 files... > Unlocked tables. > mysqlhotcopy copied 2 tables (6 files) in 0 seconds (0 seconds > overall). > ---- > > Regards.

Tue Nov 04 08:25:16 2003 jwied [...] cpan.org - Status changed from 'new' to 'open'

Tue Nov 04 08:26:16 2003 jwied [...] cpan.org - Status changed from 'open' to 'resolved'

Tue Nov 04 08:44:11 2003 Guest - Correspondence added

From:

Marcus grando

[guest - Tue Nov 4 08:14:03 2003]: The system is FreeBSD 4.9-RELEASE. p5-DBI-1.37 installed with ports and p5-DBD-mysql too Show quoted text

> Hi, > > mysqlhotcopy 1.19 don't work anymore after upgrade to version 2.9002 > and 2.9003. 2.1028 works normally. > > debug: > --2.9003-- > Filtering tables with '(?-xism:.*)' > $VAR1 = [ > { > 'index' => [], > 'src' => 'email', > 'raid_dirs' => [], > 'tables' => [], > 'files' => [ > 'alias.MYD', > 'alias.MYI', > 'alias.frm', > 'usuarios.MYD', > 'usuarios.MYI', > 'usuarios.frm' > ], > 't_regex' => '.*', > 'target' => '/root/lixo//email' > } > ]; > No tables to hot-copy at /usr/bin/mysqlhotcopy line 379. > ---- > --2.1028-- > Filtering tables with '(?-xism:.*)' > $VAR1 = [ > { > 'index' => [], > 'src' => 'email', > 'raid_dirs' => [], > 'tables' => [ > '`email`.`alias`', > '`email`.`usuarios`' > ], > 'files' => [ > 'alias.MYD', > 'alias.MYI', > 'alias.frm', > 'usuarios.MYD', > 'usuarios.MYI', > 'usuarios.frm' > ], > 't_regex' => '.*', > 'target' => '/root/lixo//email' > } > ]; > Locked 2 tables in 0 seconds. > Flushed tables (`email`.`alias`, `email`.`usuarios`) in 0 seconds. > Copying 6 files... > Executing 'cp -p '/grupos/mysql/email/alias.MYD' > '/grupos/mysql/email/alias.MYI' '/grupos/mysql/email/alias.frm' > '/grupos/mysql/email/usuarios.MYD' > '/grupos/mysql/email/usuarios.MYI' > '/grupos/mysql/email/usuarios.frm' '/root/lixo//email'' > Copying indices for 0 files... > Unlocked tables. > mysqlhotcopy copied 2 tables (6 files) in 0 seconds (0 seconds > overall). > ---- > > Regards.

Tue Nov 04 08:44:12 2003 The RT System itself - Status changed from 'resolved' to 'open'

Mon Jan 19 20:40:35 2004 Guest - Correspondence added

What version of MySQL are you using? I've tested this with both MySQL 4.1(mysqlhotcopy 1.20) and 3.23 (mysqlhotcopy 1.15) using DBD::mysql 2.9003 , and it works fine. I would possibly suggest getting a newer copy of mysqlhotcopy. [guest - Tue Nov 4 08:14:03 2003]: Show quoted text

> Hi, > > mysqlhotcopy 1.19 don't work anymore after upgrade to version 2.9002 > and 2.9003. 2.1028 works normally. > > debug: > --2.9003-- > Filtering tables with '(?-xism:.*)' > $VAR1 = [ > { > 'index' => [], > 'src' => 'email', > 'raid_dirs' => [], > 'tables' => [], > 'files' => [ > 'alias.MYD', > 'alias.MYI', > 'alias.frm', > 'usuarios.MYD', > 'usuarios.MYI', > 'usuarios.frm' > ], > 't_regex' => '.*', > 'target' => '/root/lixo//email' > } > ]; > No tables to hot-copy at /usr/bin/mysqlhotcopy line 379. > ---- > --2.1028-- > Filtering tables with '(?-xism:.*)' > $VAR1 = [ > { > 'index' => [], > 'src' => 'email', > 'raid_dirs' => [], > 'tables' => [ > '`email`.`alias`', > '`email`.`usuarios`' > ], > 'files' => [ > 'alias.MYD', > 'alias.MYI', > 'alias.frm', > 'usuarios.MYD', > 'usuarios.MYI', > 'usuarios.frm' > ], > 't_regex' => '.*', > 'target' => '/root/lixo//email' > } > ]; > Locked 2 tables in 0 seconds. > Flushed tables (`email`.`alias`, `email`.`usuarios`) in 0 seconds. > Copying 6 files... > Executing 'cp -p '/grupos/mysql/email/alias.MYD' > '/grupos/mysql/email/alias.MYI' '/grupos/mysql/email/alias.frm' > '/grupos/mysql/email/usuarios.MYD' > '/grupos/mysql/email/usuarios.MYI' > '/grupos/mysql/email/usuarios.frm' '/root/lixo//email'' > Copying indices for 0 files... > Unlocked tables. > mysqlhotcopy copied 2 tables (6 files) in 0 seconds (0 seconds > overall). > ---- > > Regards.

Sun Jan 25 19:09:49 2004 Guest - Correspondence added

From:

Marcus Grando <marcus [...] sbh.eng.br>

[guest - Mon Jan 19 20:40:35 2004]: MySQL is 4.0.17. I think that problem is in regexp. Regards. Show quoted text

> What version of MySQL are you using? I've tested this with both MySQL > 4.1(mysqlhotcopy 1.20) and 3.23 (mysqlhotcopy 1.15) using DBD::mysql > 2.9003 , and it works fine. I would possibly suggest getting a newer > copy of mysqlhotcopy. > > [guest - Tue Nov 4 08:14:03 2003]: >

> > Hi, > > > > mysqlhotcopy 1.19 don't work anymore after upgrade to version 2.9002 > > and 2.9003. 2.1028 works normally. > > > > debug: > > --2.9003-- > > Filtering tables with '(?-xism:.*)' > > $VAR1 = [ > > { > > 'index' => [], > > 'src' => 'email', > > 'raid_dirs' => [], > > 'tables' => [], > > 'files' => [ > > 'alias.MYD', > > 'alias.MYI', > > 'alias.frm', > > 'usuarios.MYD', > > 'usuarios.MYI', > > 'usuarios.frm' > > ], > > 't_regex' => '.*', > > 'target' => '/root/lixo//email' > > } > > ]; > > No tables to hot-copy at /usr/bin/mysqlhotcopy line 379. > > ---- > > --2.1028-- > > Filtering tables with '(?-xism:.*)' > > $VAR1 = [ > > { > > 'index' => [], > > 'src' => 'email', > > 'raid_dirs' => [], > > 'tables' => [ > > '`email`.`alias`', > > '`email`.`usuarios`' > > ], > > 'files' => [ > > 'alias.MYD', > > 'alias.MYI', > > 'alias.frm', > > 'usuarios.MYD', > > 'usuarios.MYI', > > 'usuarios.frm' > > ], > > 't_regex' => '.*', > > 'target' => '/root/lixo//email' > > } > > ]; > > Locked 2 tables in 0 seconds. > > Flushed tables (`email`.`alias`, `email`.`usuarios`) in 0 seconds. > > Copying 6 files... > > Executing 'cp -p '/grupos/mysql/email/alias.MYD' > > '/grupos/mysql/email/alias.MYI' '/grupos/mysql/email/alias.frm' > > '/grupos/mysql/email/usuarios.MYD' > > '/grupos/mysql/email/usuarios.MYI' > > '/grupos/mysql/email/usuarios.frm' '/root/lixo//email'' > > Copying indices for 0 files... > > Unlocked tables. > > mysqlhotcopy copied 2 tables (6 files) in 0 seconds (0 seconds > > overall). > > ---- > > > > Regards.

> >

Fri Mar 04 14:02:14 2005 rlippan [...] remotelinux.com - Status changed from 'open' to 'resolved'