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