MySQL Bugs: #15051: can't restore database with new schema name

Bug #15051	can't restore database with new schema name
Submitted:	18 Nov 2005 13:11	Modified:	21 Aug 2006 13:40
Reporter:	Tolis Evagelopoulos	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.1.5	OS:	Windows (windows xp)
Assigned to:	Mike Lischke	CPU Architecture:	Any
Tags:	Backup

Description:
when i try to restore a database from a backup script created from MySQL Administrator but with a new name for the schema(i.e. 'testnewschema') i got this error:

The MySQL Server returned this Error:
MySQL Error Nr.1049-Unknown database 'testnewschema'

The restoration failed

So,i cant create the database with new schema name

That problem was not exist at 1.0.20 version

How to repeat:
backup a database from MySQL administrator;
try to restore the database but at the "Target Schema" choose the "new Schema..." option
give the new name and push "start restore" button

Suggested fix:
this works fine at 1.0.20 version

Thank you for a bug report. Verified just as described on XP on a sample test database, with 5.0.15-nt server. 

Backup was created successfully, but when I tried to restore it as test4, I've got:

The MySQL Server returned this Error:
MySQL Error Nr.1049-Unknown database 'test4'

Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html