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:
None 
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 
Description:
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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.053 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.