mysqlhotcopy v1.14 problem with RAID regular expression

How-To-Repeat: create a database with a name like 'riponk12', then run mysqlhotcopy. You will see an error from 'cp'.

Using mysqlhotcopy v1.14 I started seeing errors like this:

> cp: missing destination file
> Try `cp --help' for more information.
> cp: missing destination file
> Try `cp --help' for more information.


investigating led to this code:

sub copy_files {
[...]
my @non_raid = grep { $_ !~ m:\d\d/: } @$files;


being triggered by a database name like 'riponk12'.

Not knowing more about the "forthcoming MySQL ``RAID'' table subdirectory
layouts" (quoted from the change log), I can't say whether a more specific
regular expression could be used, or whether this should be addressed via
a command line option, or just better documentation warning users to avoid
database names ending in a pair of digits. Regardless, the existing code
will run into problems if users happen upon database names that match the
regular expression.

-Tom

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

Re: mysqlhotcopy v1.14 problem with RAID regular expression

On Thu, 2003-02-20 at 18:52, Tom Metro wrote:
> How-To-Repeat: create a database with a name like 'riponk12', then run mysqlhotcopy. You will see an error from 'cp'.
>
> Using mysqlhotcopy v1.14 I started seeing errors like this:
>
> > cp: missing destination file
> > Try `cp --help' for more information.
> > cp: missing destination file
> > Try `cp --help' for more information.
>
>
> investigating led to this code:
>
> sub copy_files {
> [...]
> my @non_raid = grep { $_ !~ m:\d\d/: } @$files;
>
>
> being triggered by a database name like 'riponk12'.
>
Hi Tom,

This bug has already been fixed in later versions.

However, checking out your report led me to discover
a new minor bug - ie. we get the same 'cp' warnings
if the database contains only raid tables.

==
Martin


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