Having migrated from SQLite to MySQL, and not being a big fan of command-line consoles, I wanted a nice windows graphical interface to the OpenSim database being used by MySQL. Fortunately, an excellent interface to MySQL databases is provided, free of charge, from Quest Software, Toad for MySQL, available for download from here.
After downloading the Toad zip package, unzip the contents and launch the Toad for MySQL Freeware exe file. Accept the License Agreement, and when you get to the Register File Extensions page ensure that all boxes are ticked, including the .sql box.
When the installation is complete, leave the 'Start Toad when installation is complete' box checked, and click on Finish.
Toad should then start, and open in the Connections window. Ensure that the options are set as follows:
Connection Type: TCP
User: root (or the user name if you changed it from root)
Password: (your MySQL password)
Database: opensim (if this was the name you used when creating a database for OpenSim)
Check the Save Password box, then click on Connect.
You are now inside your Opensim database and free to explore. I strongly suggest you read the Release notes first, and join the Toad MySQL forum to get tips on how to use Toad and get the most out of it.
- Creating More Regions
- Terrain File to Cover Multiple Regions
- Using Toad for MySQL
- Upgrading OpenSim
- Running two Instances of OpenSim
- Choosing a Server
- Got my own Server
- Tips and Tricks
- Moving a MySQL Database
- Updating the World Map
- Renaming a Region or Estate
- Deleting A Region
- Performing an Automatic Daily Database Backup
- Using Streaming Audio
- ▼ November (14)