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

[18 Sep 2009 13:19] Rajakumar Velu
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
[19 Sep 2009 10:23] Sveta Smirnova
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.
[19 Oct 2009 23:00] Bugs System
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".