"Gilmore, Jason" <[EMAIL PROTECTED]> wrote:
>
> 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
If you use --suffix option you should not specify location, because in this case
mysqlhotcopy create a new database, f.e. staff091703, in the MySQL data dir. That is
why you get "incorrect database name" error.
>
> 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.
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
