GreenSQLRemoving Databases from GreenSQL?
Tue, 11/03/2009 - 21:14
Hi,
I'm doing some cleanup on our GreenSQL server and I'm trying to remove some old databases. I cannot however find an option in the GreenSQL console that allows you to remove a database from GreenSQL. I cannot find any documentation on how to do this either.
Do I simply drop the database from MySQL directly and it will disappear or is there some procedure I need to do on the command line to remove the database from GreenSQL. I have about a dozen or so test databases that I would like to clean out from the system.
Thanks
Looks like the only way to do this is from the MySQL cli tool:
mysql> connect my_green_db;
mysql> select * from db_perm;
mysql> DELETE from db_perm WHERE dbpid='XX';
replace XX with the database pid for the database you want to remove from GreenSQL.
Then drop the database from MySQL.
Hello
Currently we do not support for removing databases from GreenSQL management console. The only method to do it using the method you described above.
Thank you for providing this tip explaining how to remove database from GreenSQL configuration from MySQL.
Yuli