Skip Menu |
 

This queue is for tickets about the DBD-mysql CPAN distribution.

Report information
The Basics
Id: 4287
Status: resolved
Priority: 0/
Queue: DBD-mysql

People
Owner: Nobody in particular
Requestors: marcus [...] corp.grupos.com.br
Cc:
AdminCc:

Bug Information
Severity: Critical
Broken in: 2.9002
Fixed in: 2.1028



Subject: mysqlhotcopy don't work in 2.9002 and 2.9003
Download (untitled) / with headers
text/plain 1.8k
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.
From: Marcus grando
Download (untitled) / with headers
text/plain 2.1k
[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.
From: Marcus grando
Download (untitled) / with headers
text/plain 2.1k
[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.
Download (untitled) / with headers
text/plain 2.2k
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.
From: Marcus Grando <marcus [...] sbh.eng.br>
Download (untitled) / with headers
text/plain 2.5k
[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.
> >


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.