How do I enable the sample Travel database for MySQL in NetBeans IDE 6.0?

One approach is to upgrade to NetBeans 6.1. NetBeans 6.1 has new MySQL support, including the ability to easily create the NetBeans sample databases, including travel.

1. If you do not see a MySQL Server node under the Databases folder on the Services tab, right click on Databases and choose Register MySQL Server. Fill in the information for how to connect to the server. Now you should see a node, and if you entered the connection information correctly, it should be connected.
2. Right click the MySQL Server node and choose "Create Database..."
3. From the drop-down pick 'travel' and press "OK
4. NetBeans will create the database, create a connection for the database (you may need to enter the password) and then load the travel database tables.

Instructions for NetBeans 6.0

The Travel database is used in several tutorials that demonstrate Visual Web functionality. This database is bundled with the full installation of NetBeans IDE 6.0 for use with Java DB and the GlassFish application server. To make the Travel database available to the IDE:

1. Download the create-travel-derby.sql script from the NetBeans Documents and Files page and unzip it to a local directory.
2. If you have not already done so, install and configure the MySQL database server.
3. Register the database server with your application server.
4. In MySQL, create a database instance called Travel.
5. In the IDE, connect to the Travel database in the Services window. For more information, see the tutorial Connecting to a MySQL Database in NetBeans IDE.
6. Right-click the node for the connection and choose Execute Command to open the SQL Command query editor.
7. In the main menu, choose File > Open File.
8. Browse to and select create-Travel-derby.sql, then click Open.
9. In the Connection drop down list, select the MySQL Travel database you created in step 4.
10. Click Run SQL in the editing toolbar to create and populate the tables in the Travel database.
11. In the Services window, expand the node for the travel database connection to view the tables.