Toadâ„¢ for MySQL is a freeware development tool that enables you to rapidly create and execute queries, automate database object management, and develop SQL code more efficiently. It provides utilities to compare, extract, and search for objects; manage projects; import/export data; and administer the database. Toad for MySQL dramatically increases productivity and provides access to an active user community.
The internal ftp client.
The internal editor (used primarily for editing .sql files, but works with any ascii file).
Once you configure it as indicated in extra comments below, it will connect to a server and let you manipulate the tables. You can modify structure, edit indexes, etc.
What does not
Analyze table - causes crash.
Optimize table - causes crash.
Database diagram tool - eventually crashes.
What was not tested
Any features not listed above. I got tired of the constant crashes and quit testing.
The installer requires dotnet 4.0, which can be installed via winetricks: winetricks dotnet40. The application generates an error on startup, but this can be prevented by going to the options and deselecting "Open toad homepage" on startup, and deselecting "Check for updates on startup". When you save the settings, it enters an endless error loop. Terminate the wine server, and when you start the application again, no error is displayed. The settings appear to have been saved. When saving changes to files (setup, sql, etc), it sometimes enters into an endless error display loop, or crashes. The file appears to have been saved, but the program has to be terminated if it didn't already crash. It has a tendency to crash without warning. Most features will cause a crash. Because of the crashes and the endless error loops, it is not very reliable, hence the bronze rating.
|Operating system||Test date||Wine version||Installs?||Runs?||Used|
|Show||Mac OS X 10.9 "Mavericks"||Feb 18 2014||1.7.12||No, but has workaround||Yes||Garbage||Simon|
|Current||Slackware64 14.0||Nov 25 2013||1.7.7||Yes||Yes||Bronze||Zootal|