Good morning,

We're still battling with this; haven't heard back from anyone on the
list... Resending one more time in the hopes that it catches somebody's
eye.

Thanks so much,
Jason

-----Original Message-----
From: Gilmore, Jason 
Sent: Wednesday, September 17, 2003 1:36 PM
To: [EMAIL PROTECTED]
Subject: Mysqlhotcopy and incorrect database name error - We must be
dense


Hi there,

A mysqlhotcopy issue has stumped no less than three of us here today at
work, ensuring that the solution is glaringly obvious. We're trying to
use mysqlhotcopy to copy a few databases. We want to make a local copy,
nothing exotic, just want to move the database backups to the directory
/backups/.

In particular, we're attempting to make use of the following syntax:

mysqlhotcopy db_name [/path/to/new_directory] 

However, we receive an error when executing the following:

%>mysqlhotcopy -u root --suffix=091703 staff  /backups

The error is:
"DBI
connect('../backups/wjgilmore/;host=localhost;mysql_read_default_group=m
ysqlhotcopy','root',...) failed: Incorrect database name '/backups/' at
./mysqlhotcopy line 747"

In short, what's happening is that mysqlhotcopy thinks that /backups/ is
a database that we'd like backed-up. Which, according to the following
syntax form (shown in the mysqlhotcopy page of the MySQL manual):

mysqlhotcopy db_name_1 ... db_name_n /path/to/new_directory

Interestingly, when using a regular expression, the destination
directory is recognized immediately:

%>mysqlhotcopy jan-2003./^sales/ /backups/

The Juicy details:
* Redhat 7.2
* Perl 5.6.1
* Mysql 4.0.9-gamma (although we've tried mysqlhotcopy on three
different mysql versions, with no luck)
* Yes, the user has permission to write to /backups/
* Yes, the user has select and reload permissions.

Thanks for any insight. This is driving all of us crazy. Also looked all
over the newsgroups regarding this, a few individuals have posted
similar questions, however none were answered.

Best,
Jason

======================
Jason Gilmore
Systems Developer
The Fisher College of Business

340 Mason Hall
250 W. Woodruff Ave.
Columbus, Ohio 43210
The Ohio State University

e: [EMAIL PROTECTED]
t: 614-292-9754 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to