MySQL Bugs: #47441: DB restore as duplicate database

Bug #47441	DB restore as duplicate database
Submitted:	18 Sep 2009 13:19	Modified:	19 Oct 2009 10:23
Reporter:	Rajakumar Velu	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	5.0.85	OS:	Linux (Redhat ES 5.1)
Assigned to:		CPU Architecture:	Any
Tags:	issue while creating duplicate database

Description:
Hi

I have a dump of db5.dmp it has full dump of db5 database, on the test server i have to restore it. as db5 and db51 database.

took dump using "mysqldump -p --opt db5 > db5.dmp

db5 restored as db5 on the test server that fine,
when i restore the same dump to db51 after finish the db51 is only working the old successful restore of db5 is not working it show's

mysql> select count(*) from address;
ERROR 1146 (42S02): Table 'bemusic.address' doesn't exist

actually table is there,

some of the table has index and mostly INNODB tables. 

Please tread this as high priority as give good fix

Regards,
Rajakumar
866 257 2321 Ext 6638

How to repeat:
tried with

* table by table

cat db5.dmp | sed s/db5/db51/g | mysql -u root --password='pass' db51

but still any one of the db only working

Thank you for the report.

> mysql> select count(*) from address;
> ERROR 1146 (42S02): Table 'bemusic.address' doesn't exist
>
> actually table is there,

How database bemusic related to databases db5 and db51 you are trying to restore?

> some of the table has index and mostly INNODB tables. 

This can be error in InnoDB dictionary. Please send us full error log file.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".