Description:
When using mysqlhotcopy for database backups, it fails to backup a Database or Table
with a minus ("-") or blanks in its name,
for example when using "mydb.user-table", "mydb.user table", "my db.usertable" or
"my-db.usertable" and says "You have an error in your SQL Syntax"
How-To-Repeat:
Create a Table or Database with a minus or Blank in its name, for example "my
db.user-list", then run mysqlhotcopy on the corresponding database
Fix:
?
Submitter-Id: <submitter ID>
Originator: Simon Pabst
Organization: Siemens Business Services
MySQL support: none
Synopsis: mysqlhotcopy Problems with Databases/Tables with minus or blanks in name
Severity: serious
Priority: high
Category: mysql
Class: sw-bug
Release: mysql-3.23.49 (Official MySQL binary)
Environment:
System: SunOS 5.8 Generic_108528-08 sun4u sparc SUNW,Ultra-Enterprise-10000
Architecture: sun4
Some paths: /usr/bin/perl /usr/local/bin/make /usr/local/bin/gcc /usr/ucb/cc
GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/2.95.3/specs
gcc version 2.95.3 20010315 (release)
Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' CXX='gcc'
CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti'
LDFLAGS=''
LIBC:
-rw-r--r-- 1 root bin 1749356 Jul 20 2000 /lib/libc.a
lrwxrwxrwx 1 root root 11 Mar 6 2001 /lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 root bin 1135056 Jul 20 2000 /lib/libc.so.1
-rw-r--r-- 1 root bin 1749356 Jul 20 2000 /usr/lib/libc.a
lrwxrwxrwx 1 root root 11 Mar 6 2001 /usr/lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 root bin 1135056 Jul 20 2000 /usr/lib/libc.so.1
Configure command: ./configure --prefix=/lvol1/mysql '--with-comment=Official MySQL
binary' --with-extra-charsets=complex --with-server-suffix=
--enable-thread-safe-client --enable-local-infile --enable-assembler --disable-shared
Perl: This is perl, v5.6.1 built for sun4-solaris-multi
Sincerely
Simon Pabst
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
