cgiscriptshop.com

 

Contact usOrderAccountManualDemoScreenshotProducts 

 

Mysql Data Manager

Previous

TOC

Next

 

 

CHANGELOG

VERSION

DESCRIPTION

1.73

- Minor improvements: Javascripts added to a few functions (Select all), inner functions improvement.

- A few features supported by Mysql 5.xx were added. Interface was not affected.

All <TEXTAREA> fields were set to display fixed font.

1.72

-The following bugs were fixed:

  • Search Records could give wrong result if searched record contained non-alphanumeric characters
  • Backup screen could appear corrupted id Download checkbox was selected

-Improvements:

  • Backup subroutine was optimized to operate with big tables
  • Interface of Alter/Create Table was improved.
  • Error handling was improved.

1.70

- Facilities, based on new features of MySQL 4.x.x server were added
- Some functions were enhanced
- Minor bugs were fixed

ALTER/CREATE function was improved to operate more safe and handy:

  1. Disabled options non-supported by current settings
  2. PROOF button was added
  3. ENABLE/DISABLE KEYS action was added
  4. ORDER BY action was added
  5. IGNORE keyword was added
  6. Table Options were added:
    • AVG_ROW_LENGTH
    • AUTO_INCREMENT
    • CHECKSUM
    • COMMENT
    • DELAY_KEY_WRITE
    • MAX_ROWS
    • MIN_ROWS
    • PACK_KEYS
    • ROW_FORMAT

GRANT/REVOKE privilege and Create New account functions were improved:

  1. REQUIRE clause and Recourse options were added to utilize new feature Mysql 4.x.x
  2. Variable `{user}’ now works as `?’ variable (to create Name based accounts)
  3. GRANT/REVOKE query generator was optimized

New forms of SHOW statement was added.

New options of FLUSH statement was added.

RESET QUERY CACHE statement was added as a new command to Administration page.

 

1.60

Interface improvements: Some functions now are implemented on separate pages. Navigation was optimized to be more intuitive.
New features: SQL script now can be sorted by name, date and size  and renamed. Table type can be assigned when a table is being created.  Backup and DDL now can distinguish different table types. More options were added to Administrative functions.
Minor bugs were fixed

1.53

Major bugs was fixed in Search/Modify function:  When multiple rows were edited modifying of search criterion caused wrong rows selection (reported by Paul Eckert http://www.architecturalengineers.com )
Error handling of SELECT function was optimised
Resolved compatibility issue with older versions of Perl module  DBD::mysql

1.52a

Minor bugs were fixed: (Characterset, Import)
Minor improvements: Downloading of backup files was optimized, Compatibility with older versions of CGI and DBI modules was provided.

1.52

Minor improvement:
- Error handling was corrected.
- Character Set option was added to Setup. (Default value is ISO-8859-1)

1.51

Minor bugs were fixed:
- FreeBSD compatibility issue on file operations.

Minor improvement:
`Import file' function was improved for better cross platform compatibility.

1.50a

 

Minor bugs were fixed:
- Crossplatform compatibility of exported ASCII files was improved
- IMPORT function was corrected

Minor improvement:
- "Abort on errors" choice was added to SQL scripting  (for multiple SQL queries only)

1.50

Major improvements
- IMPORT function was added to insert data into Mysql tables from  plain text files
- EXPORT function was added. This function exports data from mysql tables, query and search results into plain text files of different formats.
Minor improvements and bugfixing:
- improved error handling in Alter and Create Table functions
- optimized Backup downloading
- error handling of Access Control was corrected
- queries separation bug corrected when multiple queries are submitted.
- REPLACE option was added to INSERT functions
- The bug of Delete function was fixed
- An attempt to edit deleted record caused error - fixed
- Now the logo can be provided with a hyperlink.

1.45

Banner colors, fonts and image customization

1.44c

Minor improvement of Error handling and interface.

 

 

1.44b

Interface improvement. Minor bugfixes. (function DELETE sql script was buggy)

1.44a

Minor bugfixes. Executed SQL script error handling was incorrect.

1.44

 

  1. Added the ability to apply the selected SQL file or backup directly  to a database on another host without disconnecting from the current location.
  2. Improved Backup/Restore pages.
  3. Optimized the Restore procedure

1.43a

Analysis of HTTP_USER_AGENT environment variable was added in order to optimize the html form size for different web browsers. (This affects mostly the users of Netscape)

1.43
  1. Logical operator OR/AND was added to the "Search and Modify" function
  2. FULLTEXT option was added to ALTER function

1.42
  1. "Save as" option was added to the ALTER function
  2. SQL scripting was optimized.
  3. Backup and Restore functions were were significantly optimized.
  4. Major bug was fixed in the "Search and Modify" function. ("Start" row and "Row numbers" could take wrong values in some cases.)

1.41b
  1. CREATE and ALTER functions were optimized.
  2. Button "Cancel"  was added to the Interface "ACCOUNT ACCESS".

1.41a

"Search Table" algorithm was corrected. Numeric arguments  comparison was optimized.

1.41

  1. SETUP screen was created. Now all parameters are stored in config  file and can be edited on the server, using SETUP interface.
  2. Background image is not longer used. All colors are created  using table background colors.
  3. Minor improvements.

1.40b
  1. Interface optimization.
  2. Error handling bug was fixed. (Execution of empty string was handled incorrectly)

1.40a

Download function was optimized for compatibility with all browser.

1.40
  1. Access Control function was added (Administration page)
  2. Minor corrections of performance.

1.32
  1. Added tooltips (MSIE, Opera).
  2. Performance improvement.
  3. Fixed minor bug (Update options corrected).

1.31

  1. "Print Result" button added to Search, Select and SQL Script pages.
  2. "HELP" link added.
  3. Added search options.
  4. Fixed minor bugs  ("Select All" function displayed multiple selection corrupted)
  5. "Error log" is not used any more because in most cases it duplicates system error logs.
  6. Fixed incorrect handling of errors when a user is granted Table  or Column privileges.

1.30b
  1. Fixed minor bugs ("Search" function displayed corrupted  table in Netscape)
  2. Optimized "Search" function (corrected resulting "SELECT"  query)

1.30a
  1. Fixed interface bugs (Search result displayed "garbage").
  2. Corrected error handling ("Insert" function )

1.30

  1. Added Search/Modify page. (Due to requests of many users)
  2. INSERT function now is integrated into SEARCH/MODIFY.
  3. Added option "Unquoted data" to INSERT page allowing to operate  with SQL functions.
  4. Changed behavior of error handling on some pages. The functions, that only display information from more than one table simultaneously  do not abort on errors if an error occurred because of wrong input.
  5. Improved 'SELECT' page functionality. Now the it allows to select  any expressions (not only columns) and select from more than one table in one statement, joining them using comma or 'JOIN' clause
  6. Fixed bugs of DELETE/UPDATE functions when a table without primary keys could not be updated.
  7. Added <textarea> and pull down menu forms to INSERT page for Blobs and Enums.
  8. Text form substituted with pull down menu for 'Enum' column  type on UPDATE page. (Upon many requests)
  9. Some minor bugs fixed
  10. Improved 'look and feel' of some pages

1.22
  1. Changed name of user directory.
  2. Fixed bugs ("Preview" with Update and Delete functions now works correctly )
  3. Optimized Alter and Create functions.
  4. Corrected Zoom.

1.21
  1. Added query/script editor.
  2. The backup procedure is extended with the options allowing to  include only table structure, only data or both of them into backup file.
  3. Fixed some bugs.
  4. Changed the location of backup directory (see Installation)

1.20

  1. Added Drop/Create Database commands
  2. Added administrative function:
    FLUSH (hosts, logs, privileges, tables, status),
    SHOW (status, variables, processlist, grants, table status),
    OPTIMIZE, ANALYZE, CHECK, REPAIR,
    BACKUP - the program creates backup files on selected tables as  SQL scripts in plain text, zip, gzip format,
    RUN SCRIPT/RESTORE - the program executes SQL scripts (including backup files) stored on the server.
  3. Added file manipulation functions:
    UPLOAD, DOWNLOAD, DELETE, COMPRESS,
  4. Added error log feature,
  5. Optimized some internal procedures.
  6. Improved error handling facilities.
  7. Fixed some interface bugs.

1.01

  1. Improved navigation.
  2. Added Zoom for Text and Blob columns
  3. Added options Ignore/Delay/Low Priority because of using  in production environment.
  4. Fixed some bugs

1.00

  1. Added command bar and Column bar in Select and Update pages
  2. Persistence for Command and Column bars selections ( It uses hidden inputs.)
  3. "Look and feel" created using CCS
  4. Alter/Create Table function
  5. Improved error handling
  6. The text of the program rewritten in more or less normal way
  7. Optimized data quoting
  8. Fixed some bugs.

 

 

 

 

Previous

TOC

Next

 
 

 

 

 [Home] [Products] [Screenshots] [Demo] [Manual] [Account] [Order] [Contact us]

Copyright © 2003 cgiscriptshop.com