Bug #44008 ndb restore to push create table events for auto discovery of table MySQLD
Submitted: 1 Apr 2009 7:52
Reporter: Jonathan Miller Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Cluster: Replication Severity:S4 (Feature request)
Version:mysql-5.1-telco-7.0 OS:Any
Assigned to: CPU Architecture:Any

[1 Apr 2009 7:52] Jonathan Miller
Description:
If a user restores all the meta data and data through a ndb restore rather then restoring schema through SQL and data through restore, then the use is forced to do a "show tables" through SQL for the mysqld to a discovery.

It would be more desirable to be able to restore all using ndb restore and having an event for the mysqld to auto discover rather then having to restore schema through SQL or having to do a show tables.    

How to repeat:
Bug #43838  	Missing step when using ndb_restore to set up circular replication
http://bugs.mysql.com/bug.php?id=43838

Suggested fix:
The suggested fix is to use the same create table event code in the handler and create a lib for restore so that an event can be generated during restore for the mysqld to auto discover the table.