Easily remove unused MySQL databases

Posted by Sander_Marechal on Sep 20, 2011 7:07 PM EDT
Lone Wolves; By Sander Marechal
Mail this story
Print this story

I use PHPUnit and the DbUnit extension for my unit tests. Because I use InnoDB tables with foreign keys I cannot use an SQLite database or temporary tables to run my unittests on. So, I have set up a separate MySQL server to run all my unittests on. The only downside is that after a while, you get a bunch of unused databases on the server. So, I have written a simple bash cronjob that deletes all databases from the server that have not been used for some time.

Full Story

  Nav
» Read more about: Story Type: Tutorial; Groups: Debian, Linux, MySQL

« Return to the newswire homepage

This topic does not have any threads posted yet!

You cannot post until you login.