SciBit Free Mascon (ver 2001.2.2.48) MySQL Admin Utility. Description =========== Mascon is a powerful Win32 GUI for the administering MySQL server databases. Mascon's features include visual table design, connections to multiple servers, data and blob editing of tables, security setting, SQL colour coding, dump functionality and much more. The dump facility is also available from the command line which makes it possible to schedule dumps. The newest feature to Mascon is its ability to let you create you own reports. The reports can contain text and charts that are generated from the data in your database. These reports can be saved for later use. Mascon is suitable for developers, administrators, system engineers, DBA's and general clients using MySQL server. Ordering Mascon =============== Mascon can ordered directly from its About Box by clicking on Buy It. This will take you to our online order page where you can submit your order. Under normal circumstances you will receive your full version Release Code within 24 hours if ordered by credit card. With other payment methods, delivery of the Release Code depends on when we can confirm payment. You can now also order Mascon through Share-It by following the link below: https://secure.element5.com/register.html?productid=134724&language=English After you have submitted your order on Share-It we will send your registration details to you by e-mail. Contact Information =================== http://www.scibit.com Mascon@scibit.com Version History =============== 2001.2.2.49/48 (23 April 2001) * Server side result sets. This makes Mascon more responsive when working with large result sets * Support for FULLTEXT index creation in the visual table designer (MySQL 3.23.23 and later) * Support for sub-part indexes creation in the visual table designer * Support for FULLTEXT and sub-part indexes in Mascon dump. Mascon will now properly dump table structures & data for tables that contains FULLTEXT and/or sub-part indexes * Import Tab delimited text files directly into a table * Inline display of TEXT fields in data grids * Option to always ask for a password when connecting to a server * Result code for command line dump. The result code indicates whether the dump operation was successful * Optionally log dump progress and errors to a text file * If a dump operation fails while sending statements to the target server, Mascon will show the statement that failed * Disable sorting of columns while in edit mode of a record * Fixed column sizing error 2001.2.1.15/14 (26 February 2001) * Add full support for using MySQL reserved words as database, table and column names (reserved words are automatically enclosed with '`' quotes) * Added support for opening more than one SQL Window at a time * Report Builder was updated and includes an easier way to create master/detail reports * Fix: Record navigator will now be visible if a window is opened in maximised state * Fix: Table Designer now notice changes you make to the table option while closing the window and will prompt for saving the table 2000.1.10.48/47 (8 January 2001) * Add OPTIMIZE table feature (3.22.8 and later, only MyISAM) * Add CHECK TABLE feature (3.23.13 and later, only MyISAM) * Add REPAIR TABLE feature (3.23.13 and later, only MyISAM) * Add ANALYZE TABLE feature (3.23.22 and later, only MyISAM) * New Server Monitor allows you to view multiple MySQL server process lists, varaibles and status information * New Advanced Connection properties allows you to 1. Show only a selected set of databases in the Server Navigator 2. Auto Open a selected set of databases upon connection to server 3. Allow different username/password for a selected set of databases * Change Report & Query file save routine to allow normal file naming conventions * Fix: Join syntax error in Report Builder * Fix: Record updates are now done when closing table/updatable query * Fix: ALTER TABLE statement. Version 3.23.28 and above only accepts comma delimited table options 2000.1.9.25/24 (9 November 2000) * Added printing of reports to Lotus, Quattro, Excel, Bitmap, JPEG, CSS2, HTML, PDF, TIF and RTF formats * Bug fix: odd behaviour of scroll bars in table and SQL windows * Bug fix: Table Designer now allows a varchar default value up to the full length of the field * Bug fix: Security Window now allows you to continue in it even if you tried to add a duplicate user/host combination 2000.1.8.19/18 (20 October 2000) * Fixed some problems when using Mascon with older MySQL servers * Reworked the dumping routines to be more stable 2000.1.7.37/36 (16 October 2000) * Mascon now uses libmySQL.dll version 3.22.34 2000.1.6.35/34 (13 October 2000) * Added Master/Detail support in Reporting * New and improved help file * Fixed the bug that disabled the DEL key in the SQL Editor Windows * You don't have to click Apply in the Options dialog anymore if you changed the colour coding defaults and then close the Optione dialog * Fixed the error that sometimes crashed Mascon when pasting data into the Table Window 2000.1.5.19/18 (6 October 2000) * Complete new SQL editor with lots of configurable options * Advanced options in table designer * Customisable code templates for SQL editing * Find & Replace functions in SQL windows * Edit records in a table even if no primary key is defined 2000.1.4.11/10 (19 June 2000) * Added support for database, table and column names that contains non alpha-numeric characters. * Added support for graphs in a report that contains series that must plot large integer values. * The placement of database, table and sql windows are saved and restored when they are opened and closed. * Bug Fix: When saving a table design and Cancel is selected on the SQL window Mascon raised an error. This error was fixed with this release. * Bug Fix: When designing a table a fields properties would only be displayed when the type of the field is entered in lower case. This error was fixed in this release of Mascon. 2000.1.3.37/38 (31 May 2000) * Added crosstab wizard to end-user reporting. * Fixed a bug when connecting through proxy server. 2000.1.3.35/36 (29 May 2000) * End User Reporting. Design your own reports in Mascon from your database. Reporting supports text, graphics and charts. * Fixed a bug in the Security Settings window of Mascon. 2000.1.2.31/32 (15 May 2000) * Mascon now is compliant with MySQL servers running in ANSI mode * Server connection passwords are stored in an encrypted form in the Windows registry. 2000.1.2.17/18 (6 May 2000) * Fixed bug when dumping only to a file. Mascon always tried to connect to the target server * Fixed and optimized some of the data editing code. 2000.1.2.14/15 * Added dump feature which allows you to save dump profiles and execute them from the command line making it possible to schedule dump operations using Mascon's dump You can now refresh the table list in the database window. This is useful in multi-user scenarios * Mascon now allows you to set your own colour and font style for the SQL colour coding. The coding can also be turned off completely. 2000.1.1.24/25 * Added Copy & Paste of data to and from the Table Data Editor * Added Import & Export of data to and from the Table Data Editor in a CSV like format * Added searching capabilities to the Table Data Editor * Enhanced Data Editor for ENUM and SET field types * Fixed minor bug when creating tables 2000.1.0.32/33 * Added additional data editing capabilities for VARCHAR,TIMESTAMP,DATETIME,DATE,TIME,TEXT and BLOB fields. * Added record count and SQL statement view on Data Editor * Made compliant with MySQL 3.21.xx. * Fixed a few minor bugs. 2000.1.0.13 * Fixed data entry in a table on a varchar or char field when entering quotes (" or ') * The Filter option in table view allows you to enter your own expression for the where clause * Fixed double refresh of result set in the Table View window when removing sorting or filtering on a grid * Fixed some nuisance bugs in the Table Design windows. 2000.1.0.7 * Fixed Security Settings for older versions of MySQL * Changed Security Settings form layout and made it more robust * Now the database console will not open if the user does not have privileges to open it. 2000.1.0.3 * Made Security Settings compatible with older versions of MySQL server that does not have tables_priv and columns_priv tables in the mysql database * Fixed bug when trying to add a new connection. 2000.0.1.75 * Fixed bug with some case sensitive servers. Fixed some minor problems when updating a table directly in a Mascon data grid. 2000.0.1.72 * First release.