MySQL Bugs: #52732: Cannot copy from one database to another

Bug #52732	Cannot copy from one database to another
Submitted:	9 Apr 2010 22:24	Modified:	11 Apr 2010 13:18
Reporter:	frann leach	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	4.1.22	OS:	Linux
Assigned to:		CPU Architecture:	Any

Description:
The command 

CREATE TABLE `tiggsy_iphone.backup_arn` SELECT * FROM `tiggsy_availabl.coupons

fails, though the database names are correct, the existing table name is also correct.

As Mysql is on a cpanel system, the database names have underscores in them. This is standard on cpanel and cannot be changed without moving to a different host. I would say probably a majority of users are on cpanel hosts, in any case, so it's not really an option.

How to repeat:
You shouldn't have any problem. There are people having the same problem all over the net, from what I can see.

What exact error message do you get? Please, copy and paste it. 

In general (and in newer versions) this syntax works:

mysql> create table test.users select * from mysql.user;
Query OK, 7 rows affected (0.06 sec)
Records: 7  Duplicates: 0  Warnings: 0

mysql> select version();
+-----------+
| version() |
+-----------+
| 5.1.37    | 
+-----------+
1 row in set (0.00 sec)

#1103 - Incorrect table name 'tiggsy_iphone.backup_arn'

sorry, I should have done this in the first place. Updating version isn't an option, it's all down to the hosting company.

Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

`tiggsy_iphone.backup_arn` is really not correct name. See http://dev.mysql.com/doc/refman/4.1/en/identifier-qualifiers.html for how to quote identifiers.

This is completely illogical. All i did was to take the mysql from the manual (yes, i already read the page you pointed me to, and others more apposite), and change the names of the databases/tables to real ones