MySQL Bugs: #65563: Add a ndb_show

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

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

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

Thank you for the feature request.