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:
Category:MySQL Server Severity:S2 (Serious)
Version:4.1.22 OS:Linux
Assigned to: CPU Architecture:Any

[9 Apr 2010 22:24] frann leach
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.
[10 Apr 2010 7:40] Valeriy Kravchuk
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)
[10 Apr 2010 16:14] frann leach
#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.
[10 Apr 2010 19:23] Sveta Smirnova
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.
[11 Apr 2010 13:18] frann leach
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