Thanks, but this not work to
(output with --debug)
$VAR1 = [];
No tables to hot-copy at /usr/local/bin/mysqlhotcopy line 390.
/usr/local/bin/mysqlhotcopy Ver 1.22
mysql-4.1.16
perl, v5.8.5 built for i586-linux-thread-multi
Linux camel 2.6.8-24.16-default
> You should just be doing
>
> mysqlhotcop
You should just be doing
mysqlhotcopy ...connect-options... --regexp /~^db_name$/
or
mysqlhotcopy ...connect-options... --regexp /~^db_name$/ /path/to/new/dir
On 5/25/06, MF <[EMAIL PROTECTED]> wrote:
Hi, how to write pattern for backup all datases except one?
I try this, but not work as exp
Hi, how to write pattern for backup all datases except one?
I try this, but not work as expecting.
mysqlhotcopy ...connect-options... --regexp /~^db_name$/./.*/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTE
In the last episode (Jun 05), Pabst Simon said:
> Description:
>
> When using mysqlhotcopy 1.15 for database backups with --regexp='.*' and
> having 640 or more Databases produces the following error:
>
> DBD::mysql::db do failed: File '/lvol1/mysql/data/mydatabase/mytable640.MYD' not
>found (
r with 640 or more Tables
Syntax:
mysql/bin/mysqlhotcopy --regexp='.*' /somedir
Fix:
?
Submitter-Id:
Originator:Simon Pabst
Organization: Siemens Business Services
MySQL support: none
Synopsis: mysqlhotcopy regexp problem with 640 and more Databases
Severity: s
On Fri, Jul 20, 2001 at 01:25:22AM -0700, Jeremy Zawodny wrote:
> >
> > If I specify just one database, I still get the "deprecated"
> > warning, but the hotcopy works...
>
> There are two bugs.
>
> (1) The "depricated" message. I'm submitting a patch for that.
>
> (2) The fact that if yo
On Wed, Jul 18, 2001 at 09:57:00AM -0800, Chris Lott wrote:
>
> Using the mysqhotcopy that came with the most recent MySQL (3.23.39)
> on a RedHat 7.1 box with perl 5.6.0, I am getting the following
> errors when trying to back up all databases:
>
> mysqlhotcopy --password="foo" --allowold --reg
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Using the mysqhotcopy that came with the most recent MySQL (3.23.39) on a
RedHat 7.1 box with perl 5.6.0, I am getting the following errors when
trying to back up all databases:
mysqlhotcopy --password="foo" --allowold --regexp=".*" /usr/backups/ \
