If you are using a MySQL server and have the appropriate privileges, Track Magic has a special dialog that allows you to view the databases and tables on the server, and to create and remove databases.
The Databases & Tables Dialog
To open this dialog, first open the Favorite Hosts dialog (Track menu) and select a MySQL host. Then press the Databases & Tables button.
This will open a new dialog that will list all of the databases on the selected server (assuming that you have the appropriate permissions).
Click on a database to see a list of the tables in that database, if any.
Manually Adding a MySQL Database
To add a new SQL database on this server, press the + button (in upper right hand corner of the list of databases). Track Magic will prompt you for the name of the new database. Simply enter the name and press Create Database(s) to create a single database on the specified server.
You can also specify one or more suffixes for the database name. If more than one suffix is specified then multiple databases will be created. For example if the specified database name is acme and the suffixes are development and test, then two databases will be created — acme_development and acme_production.
Note: Track Magic can also automatically create MySQL databases for you when you create the Rails application. See the Host Connection dialog.
Deleting a MySQL Database
To delete a MySQL database, press the - button to the left of the database name. Track Magic will ask you for confirmation before actually deleting the database. Be careful! Once a database is deleted there is no way to get it back.