As I promised in an earlier post, I have created a plugin that makes it very easy for you to load the MySQL Sakila sample database from NetBeans. Sakila is a serious sample database, with tons of data, and a number of views, stored procedures, triggers and functions to allow you to really explore and test all the various features of MySQL.
If you tried in the past to load Sakila from NetBeans, you were probably quickly dissatisfied. The editor currently can't handle such a large file, and it didn't handle the delimiters correctly, and it also completely barfed when the script tried to insert a raw PNG file.
So, I fixed all those, and now you simply have to install the plugin, then choose Create Database from your MySQL node in the Database Explorer, and you're off and running.
Here are the steps you need to follow.
First of all, you need to get a recent 6.5 development build, this does not work with NetBeans 6.5 beta. Go to http://bits.netbeans.org/dev/nightly/latest/ and get the nightly build from there.
Then you go to Tools->Plugins->Available and choose Sakila Sample Database. To filter the list, type in Sakila in the matchbox. Check the install checkbox and choose Install
Now open the Services tab, expand Databases, and connect to your MySQL server through the MySQL node. If you don't have this node, right-click on Databases and choose Register MySQL Server.
Once you are connected, right-click on the node and choose Create Database...
This brings up a little dialog with a drop-down list of sample names. Note that sakila is on the list - that was added by the plugin.
Choose sakila and click OK.
You are then presented with a dialog to create a new connection for the new database.
Type in the appropriate user and password, press OK, and then press OK when asked to choose a schema (I really should fix this, you don't choose schemas in MySQL as a schema and a database are the same thing).
At this point the plugin merrily creates all the tables, views, stored procedures and triggers for Sakila and then loads up all the data. One thing I need to fix is to add a progress bar so you know when it's done, but just keep your eye on the output window(s). (Another thing to fix: don't have multiple output windows. But hey, this is still in beta :)).
Now you should have all of Sakila loaded up, easy as pie.
Please let me know if you have any feedback, particularly by logging issues.