Hi there,
I have been attempting to use mysqlhotcopy to make a backup
copy of all of the databases on a server. It wasn't completely
self-evident from the Mysql manual how best to do this, so I
tried the following:
mysqlhotcopy -u blah -p blah "--regexp=.*" --flushlog /blah/blah/blah/destdir
This resulted in the following error messages:
Use of uninitialized value in transliteration (tr///) at
/usr/local/mysql/bin/mysqlhotcopy line 230.
Use of uninitialized value in regexp compilation at /usr/local/mysql/bin/mysqlhotcopy
line 231.
Filtering tables with '(?-xism:)'
Use of uninitialized value in transliteration (tr///) at
/usr/local/mysql/bin/mysqlhotcopy line 230.
[similar stuff repeated many times ...]
No tables to hot-copy at /usr/local/mysql/bin/mysqlhotcopy line 322.
I found that the following patch solves the problem:
diff -c mysqlhotcopy.orig mysqlhotcopy
*** mysqlhotcopy.orig Sun Nov 4 18:03:49 2001
--- mysqlhotcopy Sun Nov 4 17:53:35 2001
***************
*** 227,232 ****
--- 227,233 ----
## generate regex for tables/files
my $t_regex = $rdb->{t_regex}; ## assign temporary regex
+ $t_regex = ".*" if !defined $rdb->{t_regex}; ## MTC 2001.11.04
my $negated = $t_regex =~ tr/~//d; ## remove and count negation operator:
we don't allow ~ in table names
$t_regex = qr/$t_regex/; ## make regex string from user regex
This occurred using MySQL 3.23.37 with Linux 2.4.0. I hope
this is of use to someone. If this is not the preferred method
for making a copy of a database, I would be grateful for
enlightenment.
Thanks.
--
Matthew Clegg | OKbridge -- The #1 Online Bridge Club
[EMAIL PROTECTED] | http://www.okbridge.com
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
