Bug #65563 Add a ndb_show_databases utility
Submitted: 7 Jun 2012 20:01 Modified: 8 Jun 2012 10:22
Reporter: Hartmut Holzgraefe Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any
Tags: Contribution

[7 Jun 2012 20:01] Hartmut Holzgraefe
Description:
Add a ndb_show_databases utility to print the names of all distinct databases of the tables stored in cluster ...

... with a --sql-output option to work around bug #46064

How to repeat:
Right now working around bug #46064 needs a shell script like:

for db in `ndb_show_tables | grep UserTable | awk '{print $5}' | sort | uniq`
do
  mysql ... -e "CREATE DATABASE IF NOT EXISTS $db;"
done

With the proposed tool it could be solved using a simpe

  ndb_show_databases --sql-output | mysql ...

Suggested fix:
https://code.launchpad.net/~hartmut-php/mysql-server/cluster-7.2-showdbs
[8 Jun 2012 10:22] Valeriy Kravchuk
Thank you for the feature request.