Bug #55392 database name is not auto-discovered during ndb_restore
Submitted: 20 Jul 2010 9:50 Modified: 20 Jul 2010 10:56
Reporter: Oli Sennhauser Email Updates:
Status: Verified Impact on me:
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S1 (Critical)
Version:mysql-5.1-telco-7.0 OS:Any
Assigned to: CPU Architecture:Any
Tags: 7.1.4b and 7.0, ndb_restore, schema

[20 Jul 2010 9:50] Oli Sennhauser
When we do a ndb_restore the restored schema names are not automatically shown in the sql nodes. We have to create the schema names manually in the sql nodes.

How to repeat:
ndb_mgm> start backup
mysql> drop schema test;
shell> ndb_restore ...
mysql> show databases;
mysql> create schema test;
mysql> use test; 
mysql> show tables;

Suggested fix:
This should happen automatically.
[20 Jul 2010 10:56] Sveta Smirnova
Thank you for the report.

Verified as described.
[29 Jul 2010 13:42] Jørgen Austvik
Workaround: mysqldump/ndb_show_tables for create statements.
[12 Dec 2014 11:27] Daniël van Eeden
This is a duplicate of Bug #46064
[31 Jul 2015 16:14] The Bunker The Bunker
Affects mysql-5.6.25 ndb-7.4.7 also