I mean look at the --suffix
- Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 -->-----Original Message----- -->From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED] -->Sent: Monday, September 22, 2003 1:26 PM -->To: 'Gilmore, Jason'; [EMAIL PROTECTED] -->Subject: RE: Mysqlhotcopy and incorrect database name error - We must be -->dense --> -->Your not using mysqlhotcopy correctly. --> -->/usr/bin/mysqlhotcopy db_name[./table_regex/] [new_db_name | directory] --> --> -->The problem is this -->mysqlhotcopy -u root --suffix=091703 staff /backups -->look at -u --> --> -->here is a format from inside mysqlhotcopy --> -->mysqlhotcopy --method='scp -Bq -i /usr/home/foo/.ssh/identity' -->--user=root --password=secretpassword \ --> db_1./^nice_table/ [EMAIL PROTECTED]:~/path/to/new_directory --> --> --> --> -->- Dathan Vance Pattishall --> - Sr. Programmer and mySQL DBA for FriendFinder Inc. --> - http://friendfinder.com/go/p40688 --> --> -->-->-----Original Message----- -->-->From: Gilmore, Jason [mailto:[EMAIL PROTECTED] -->-->Sent: Monday, September 22, 2003 4:35 AM -->-->To: [EMAIL PROTECTED] -->-->Subject: FW: Mysqlhotcopy and incorrect database name error - We must -->be -->-->dense -->--> -->-->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: -->--> -->-->%> -->--> -->-->The error is: -->-->"DBI -->-->connect('../backups/wjgilmore/;host=localhost;mysql_read_default_g rou -->p=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] --> --> --> --> -->-- -->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]