Ronald Bradford
MySQL Expert

MySQL Expert Ronald Bradford shares valuable input in MySQL Performance Tuning, MySQL Scalability and general MySQL Help from his two decades of working with MySQL, Oracle, Ingres and development technologies.

«
»

When is a database schema not a database schema?

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.

This entry was posted on Wednesday, April 18th, 2012 at 3:21 pm and is filed under Databases, MySQL, Professional. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “When is a database schema not a database schema?”

  1. Justin Rovang says:
    April 18, 2012 at 10:35 pm

    Even more a reason to not spend time checking RDS out

  2. Daniël van Eeden says:
    April 19, 2012 at 2:03 pm

    It reminds me of the lost+found and #.snapshot databases.

Leave a Reply