Oracle VM Consulting
view counter

When is a database schema not a database schema?

Thanks to Ronald Bradford for this story
view counter
mysql> show schemas; +--------------------+ | Database | +--------------------+ | information_schema | | innodb | | mysql | | performance_schema | +--------------------+ 4 rows in set (0.00 sec)
mysql> drop schema innodb;
ERROR 1010 (HY000): Error dropping database (can't rmdir './innodb/', errno: 17)

This is an additional schema that is included in an AWS RDS installation. You should not put directories in the MySQL data directory.

Read the entire article at its source

view counter