Removing Databases from GreenSQL? |

Database Security. Database Auditing. Database Caching. Database Masking. Get it now

Removing Databases from GreenSQL?

Posted November 3rd, 2009 by buswellj

General

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

Comments

Looks like the only way to

On November 3rd, 2009 buswellj says:

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

On November 4th, 2009 yuli says:

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

GreenSQL