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]
