Sun Rise, Sun Set - Josh Berkus leaves Sun.NetBeans Wiki: Best Practices With JPA And BeansBi.MySQL Workbench 5.1 Alpha for Linux in Less Than 3.Engineering Facebook : How We Scale Out.Please let me know if you have any feedback, particularly by logging issues. Now you should have all of Sakila loaded up, easy as pie. (Another thing to fix: don't have multiple output windows. 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). 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).Īt this point the plugin merrily creates all the tables, views, stored procedures and triggers for Sakila and then loads up all the data. You are then presented with a dialog to create a new connection for the new database. Note that sakila is on the list - that was added by the plugin. This brings up a little dialog with a drop-down list of sample names. Once you are connected, right-click on the node and choose Create Database. If you don't have this node, right-click on Databases and choose Register MySQL Server. Now open the Services tab, expand Databases, and connect to your MySQL server through the MySQL node. Check the install checkbox and choose Install To filter the list, type in Sakila in the matchbox. Then you go to Tools->Plugins->Available and choose Sakila Sample Database. Go to and get the nightly build from there. 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.įirst of all, you need to get a recent 6.5 development build, this does not work with NetBeans 6.5 beta. 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. If you tried in the past to load Sakila from NetBeans, you were probably quickly dissatisfied. 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. 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 demo database