Re: using of mysqldump V 8.22 and table names with special character #

Hi!

On Mar 22, Rik van Druten wrote:
> >You should use --quote-names in mysqldump (unless your server is at
> >least 4.1.2) if you have non-alphanumeric characters in identifiers.
> 
> CREATE TABLE `test` ( `klant_id` int(11) NOT NULL default '0',
> `#i` bigint(21) NOT NULL default '0',
> `#d` bigint(21) NOT NULL default '0' ) TYPE=MyISAM;
> 
> When using for example phpmysql it's possible to create a table like this. 
> Also with mysqldump and options --opt -Q > test.sql.
> But when restoring with mysql < test.sql (mysqld ver. 4.0.10-gamma). I 
> still get this error. I yust think that its strange when you can create 
> table names with the `#` but can't restore.

First - please, ALWAYS cc: [email protected], or better if you feel
you found a bug, use http://bugs.mysql.com to report it.

Then - unfortunately, I failed to repeat the bug.
I created a table with `#'i` field. mysqldump dumped it correctly,
then I loaded it back - no error, dumped again - and I got absolutely
the same dump, so the table was restored ok.

4.0.10 is too old version, try the latest 4.0.18

Regards,
Sergei

-- 
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <[email protected]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, Senior Software Developer
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
       <___/  www.mysql.com

-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]