New DBManager 2.3.0 is Released
We are pleased to announce the release of the new DBManager 2.3.0. This versions is not only a bug fix but it has new features which make the application more powerful. Starting in this version it's possible to manage MySQL servers through webservices (and soon for other engines). If you have a database hosted on an ISP and for security reasons the ISP doesn't allow remote connections, this feature is for you. With the setup we are distributing the webservice scripts in CGI/C (binary and sources) and PHP so it will be possible to choose the one that fits for each case. The connection is made through HTTP protocol, so it will only require a TCP/IP connection between your workstation and the webserver. All the usual operations are available. So you can, - Manage the structure and data of databases, tables, indexes, columns, etc - Create and Execute Queries graphically - Import Data from MSAccess, MSExcel, ODBC, Paradox, Xbase, Text Files and XML files (through disk file, web server or script on a web) - Export data to a lot of formats - etc. What's new in this version? - New XML Import Wizard which can be useful to import XML data from a disk file, webserver, or script on a webserver using parameters. - New MySQL Webservices management (soon for PostgreSQL and SQLite engines) - Filter and Order now remembers the last options used - Insert NULL values to columns in the Datasheet View - The application can be minimized to the System Tray - It now uses User Profiling allowing for users of the same computer to share the same installation without sharing the catalog information - And a lot of improvements and fixes For more details about the DBManager check http://www.dbtools.com.br/EN/dbmanagerpro.php For more details about the changes please check http://www.dbtools.com.br/EN/article.php?id=00035. To download this version http://www.dbtools.com.br/EN/downloads.php Best Regards, Crercio O. Silva DBTools Software -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
New DBTools Manager 2.2.0
We are pleased to announce the new release 2.2.0 of the DBManager Professional. It is a major bug fix bringing stability and performance to the application. Also it adds support to SQLite databases and Xbase Tables which you can manage using the same way you do for MySQL and PostgreSQL. In next version support for Interbase/Firebird will be available. Here is the list of changes: a.. Added support for SQLite Databases b.. Added support for Xbase Tables (Experimental) c.. Added filtering and ordering capabilities to the datasheet when editing table data d.. The DAO wizard can export data to a MSAccess Database e.. Fixed crash at startup (see message in the forums=Bug Reports) f.. Fixed datasheet refreshing and drawing problems and some things were reimplemented to make things a little easier g.. Fixed database dump (was generating NULLs instead of the real data) h.. Fixed Table Editor (was showing TEXT instead of MEDIUMTEXT/LONGTEXT column type) i.. Removed MSAccess/DAO engine as catalog database holder. We are using the SQLite engine which doesn't require any extra driver j.. Added more compatibilities with older versions of mysql and newer versions of PostgreSQL k.. Fixed bug when closing a query, datasheet or the application with queries opened. This caused crashes in some systems l.. Fixed the setup, which was installing an incorrect MFC version and creating a wrong key in the registry m.. Fixed a bug when converting data using the DAO Import Wizard, it didn't create the database and the process was stopped because the database didn't exist in the server n.. Fixed bug when creating users, sometimes it shows an empty error message box o.. Fixed drag and drop for tables and added drag and drop for databases p.. Added column sort on click in the datasheet when editing data q.. Fixed crash when connecting to a server at startup without passwords The new setup is quite smaller compared to old versions, since it doesn't install the DAO drivers anymore. Due to this, you need to install the drivers manually if you plan to import/export to MSAccess databases. Remember: when downloading the setup use the mirror already updated. You can use our forums to report bugs and give suggestions or request new features. What is DBTools Manager Professional? DBTools manager Professional is a FREE Windows application to manage MySQL, PostgreSQL, SQLite and Xbase Tables, full of features. Information get be found at http://www.dbtools.com.br. Support / DBTools Software == DBTools Forums can easily give you access to bug reports and feature requests. User registration is free. Anonymous users are allowed to browse all messages. http://www.dbtools.com.br/EN/forums == -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
New DBManager 2.1.1
The release 2.1.1 is a major bug fix and a few new features. If you are using an older Professional version, please consider updating it. Bellow, you can see the list of changes: NEW FEATURES -Added support to load/export binary data into/from a table (for blob fields). From now on BLOB fields will be marked as 'Blob' and TEXT fields will be marked as 'Memo'. -Added option to Preferences=Security to use active connection to the server -Added option to Preferences=Query to choose the default font face to be used in the Datasheet View Grid -Added support to drag and drop a entire database from one server to another -Enabled Copy to Clippboard (CTRL+C) for selected rows in the Datasheet View -Added option to the Import Data Wizard: you can select to log error messages and/or SQL statements -Added option to the Import Data Wizard: you can choose not to create integer fields as AUTO INCREMENT -The Import Data Wizard can now import Binary Data from MSAccess -The Import Data Wizard imports the Relationships directly to the database if using MySQL/InnoDB Tables or PostgreSQL -Added support for Foreign Keys in the Query Designer. Now it uses the default tables relationships (Foreign Keys) instead of the internal DBManager relationships -Servers can be marked as auto connect at startup -In MySQL newer versions you can drop Foreign Keys FIXES -Fixed Table quoting for MySQL versions older than 3.23.6 -Added full support for MySQL 3.22 versions -Fixed Datasheet View Grid refreshing -Fixed Active Transaction bug for PostgreSQL -Fixed bug when Importing tables from MSAccess. Data failed to be imported if the original field name was renamed due to reserved words in the CREATE TABLE -Fixed problem with Query Designer and AutoMap fields in Import Text Wizard: the dialogs didn't come up when using the DBLang.DLL -Fixed Index selection in the Table Preferences: the fields didn't match the selected index -Fixed minor bugs in the Table Editor -When editing table data the size of the edit doesn't change overriding the next cell -Fixed blank error message box when creating an user. -Database API for PostgreSQL was improved to add better support to the use of Namespaces (for PostgreSQL 7.3 or newer) In a few days we will release the source code of the DBLang.DLL and the HTML documentation. Anyone willing to translate the application to other native languages will need to use the Visual Studio 6.0 to compile and link the DLL and the Microsoft HTML Help Workshop (can be downloaded for free at www.microsoft.com) to compile the HTML Help manual. For those who doesn't have any of these softwares you may download the package for translation and send it back to me to create the DLL and CHM required. I would like to thank you all who sent me bug reports, documentation and website revisions. It wouldn't be possible without your help. PS: Before downloading the new version remember that the mirrors is being updated at the moment, but we expect to have everything working in a few hours. Also have in mind that not all mirrors are automatically updated, please use those marked with (*). If you have problems with a mirror, please send me a note telling the problem you are having and which mirror you have downloaded the setup from. This will help me to fix eventual problems. What is the DBManager? The DBManager is a FREE database manager for MySQL and PostgreSQL and runs only on Windows platforms. Supports managing all objects in a database server. It also includes wizards to help you with moving data from MSAccess, ODBC, MSExcel, Text Files, DBF, Paradox, create PHP scripts, etc. The complete list of features and additional information can be found at http://www.dbtools.com.br Best Regards, DBTools Software -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Migrating Microsoft Access to MySQL
Hi Edward, Use DBTools Manager 2.0.1 (http://www.dbtools.com.br). It imports structure, data, indexes, queries and relationships from MSAccess and it's totally free. []s Crercio - Original Message - From: Edward Kim [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 11, 2003 4:54 PM Subject: Migrating Microsoft Access to MySQL I am with a small business in Southern California that would like to migrate our MS Access databases to MySQL server. Are their any computer service companies who can help me? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
New DBTools Manager 2.0.1
Hi, We are pleased to announce the DBManager Professional 2.0.1. Starting in this version it is also available in Portuguese language. Bellow a list of the changes: New Features -Foreign Keys listing in MySQL/InnoDB -Enabled Metadata View -Enabled DAO Import for queries and relationships -Support for drag and drop tables from one database to another Bugs fixed -Fixed Relationship Editor call in the Query Designer. Application freezes and present high consume of the CPU time -Fixed DAO import data when boolean fields with Yes/No/False/True as default -Added a better error message when creating foreign keys in InnoDB Tables -Copy and Rename table brigs up the old table name as default -Changed the DHTML code to make it easier to handle the TreeView selections -Fixed the Import Dumped Filed when the char ';' is found inside a field string. Now it checks if the char ';' is preceeded by an escape char '\' -Added messages in the Import Dumped Files process -The table names in PostgreSQL are now treated correctly and enclosed with quotes -The query editor keeps the previous connections if it is the same. Now it's possible to run separated statements like CREATE TEMP TABLE and execute select, insert, etc -Fixed the export results, one row of data was missing -Fixed the problem with float types in MySQL (length/decimals being changed) Other - Some GUI adjustments to make the application more confortable to work with The new version is available for download at http://www.dbtools.com.br DBTools Software Development - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
New DBTools Manager Release
Hi all, We are pleased to announce the new DBTools Manager Professional 2.0. This version is not a bug fixed, but a brend new application with much more features and still easier to use. This version has been developed for almost a year, and now with a new and improved GUI, really cool new features and better support for data manipulation. Here is a simple list of the features available - New GUI which makes possible to explorer a server or a database in a easier way. This version uses a professional library which allow us to create a GUI similar to MSOffice XP and Windows XP. - Complete database management (dbs, tables, indexes, foreign keys, check constraints, etc) - New DAO Import Data Wizard, with more options (to import queries and relationships) - New Text Import Wizard - New Dump Wizard - New PHP Web Script Generator - New Data Viewer - New Query Editor with syntax coloring and codesense and function hilight - New Query Designer with drag and drop support to create relationships on the fly - and more, much more You can get detailed information at http://www.dbtools.com.br/EN/dbmanagerpro.php and download it at http://www.dbtools.com.br/EN/downloads.php. Have fun and a very nice Christmas to all. []s Crercio O. Silva / DBTools Software - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: access-mysql
DBTools works great on this matter. You find it at http://www.dbtools.com.br/EN and is totally free. []s Crercio - Original Message - From: Sandeep Murphy [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Wednesday, December 04, 2002 12:39 PM Subject: access-mysql Hi, Can anyone please suggest a simple and effective method for converting a huge database i hv in Access xp to MySQL ?? hv tried various methods, including using dsns , a small script available at http://www.cynergi.net/exportsql/ etc.. they all work but not deliver a clean result... any tried and trusted method?? thnx in adv, sands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to port MS Access to MySQL ??
Hi, Use DBTools DBManager. It import/converts from MSAccess, DBF (Dbase, CLipper, FoxPro), Paradox, ODBC e MSExcel into MySQL with just a few clicks. Of course it only works in Windows. http://www.dbtools.com.br []s Crercio O. Silva - Original Message - From: tmb [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 08, 2002 10:17 AM Subject: How to port MS Access to MySQL ?? Is there a tool for doing a quick port from MS Access to MySQL? Or must you manually create all the tables sql statements in MySQL and then export the MS Access data to a comma delimited file... then import it into MySQL? Thanks for any help - tmb __ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Utility for importing Paradox tables to MYSQL
Hi Nick, If you don't mind about the OS, yes there is. DBTools can handle Access, ODBC, Excel, Paradox, FoxPro, ClipperDBase. You can get it from http://www.dbtools.com.br. []s Crercio - Original Message - From: Nick Lazidis [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 20, 2002 6:52 AM Subject: Utility for importing Paradox tables to MYSQL Hi, I wonder if there is a utility for transferring Paradox tables to MySQL. Nickos - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
New DBTools Version (1.0.15)
I'm glad to announce that the new version 1.0.15 is now available. Before downloading it be aware that some of the mirrors are not yet updated and it may take some time. You may use the ZEON Host mirror which has a large bandwidth and is automatically updated. The list of changes and new features is big. a.. Added support for PostgreSQL. Now you can manage PostgreSQL the same way you do with MySQL databases b.. The Grid View was changed a lot. It now is a tabview where you can edit one or more queries at the same time. Also added Syntax Color Editor to the Grid View. c.. New Database Object API which is now a DLL loaded dynamically d.. New dumping code, which is now handled by the database API e.. New Type Manager. Although not visible to the user it is used for type convertion between the servers (MySQL PostgreSQL). In the next version you will be able to edit these types to fit your needs f.. New MSDAO API for MSAccess, Xbase, paradox, ODBC and MSExcel convertions, it is now faster and more reliable. Also in the next version will be possible to export to these formats. g.. Added support for version checking. Now DBTools can handle server version. A option was added to the server manager and it can be filled in case DBTools doesn't detect the server version correctly. h.. Lot's of new features: Table Editor is now the only way to create and manage tables. You will find the Table Properties which will give all the options you need to change any table object: triggers, foreign key constraints, check contraints, indexes, table type, description. i.. DHTML object is now fixed to avoid the annoying problems. This has been tested in Win9x,ME,NT,2000 with success. j.. Added printing support for any kind of view: HTML, Grid View, Syntax Color Editor. k.. Added support for User Objects: Views, Functions and Types. l.. The Web Script Generator can now handle scripts for PostgreSQL as well m.. Known bugs fixed You can find the new version at http://www.dbtools.com.br, and soon will be releasing the documentation set in other languages. Thanks, Crercio O. Silva / DBTools Development - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
BUG: SHOW TABLE STATUS InnoDB Tables
Hi, I have just noticed that SHOW TABLE STATUS is returning different number of rows each time you execute the query. This seams to affect only InnoDB Tables (Although I have tested only with ISAM/MyISAM/InnoDB Tables). I'm using MySQL 3.23.49Max on WIN2K. How to repeat the problem: Execute the statement SHOW TABLE STATUS many times. In some times (not all) it will return different number of rows for the same table. Have anyone else experienced this with other versions? PS: SELECT COUNT(*) FROM table is working just fine, but on InnoDB tables with large number of rows (my tables have -+ 30 records each) it take a few seconds to get the results. This is not a big issue for me, but I'd like to confirm that. Thanks, []'s Crercio O. Silva - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
New Release
Hi, The long awaited version 1.0.13 is now available for downloading. The list of changes and new features is too long, so I will give you a short description of what we changed: - New relationship editor ( now it can handle add new, update and delete and shows the SQL statement as an example) - New integrated User Manager (Add, Drop and Change all the privileges) - New Table Editor (Quick Editor, looks like MSAccess table design) - Fixed BLOB/TEXT fields when exporting results - Multiple statements is now back - Created format toolbar in the grid view to help cell formatting - Import Wizard and Import Text Wizard now saves the definitions, and these can be run at any time by clicking on the menu options - PHP-WSG now handles updates - Run External SQL now parses big SQL files - Added option to empty a table - Fixed bugs in the Export Data - Text Editor now uses a RichEdit Control, without size limitation - Added copy function in the Table Manager - Added support for FULLTEXT index - Fixed bug when exporting multiple files to text files - Query Editor now starts with the selected database as default - Added option to Go/ Don't Go full screen when starting - Import Wizard was improved a lot, now it can handles some data types better and it is quite faster for XBase tables - Removed the List View, now DBTools uses the HTML View to show object's data The new version can be download at http://www.dbtools.com.br as also all information about it. I'd like to thank all people envolved in the test fase and those who sent suggestions and bug-reports. Crercio O. Silva / DBTools Development - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
New DBTools Release (1.0.10)
After being tested for a week, he new version is finally available for downloading. This new version has some bugs fixed and a totally new Server Manager. Here is the list of the changes: - New Server Manager integrated, you can add, delete or change the parameters at any time you want. You can also set the connection startup option for the server choosing between automatic or manual. Also, the servers information won't stored into the windows registry anymore. Because of that you will need to insert your servers information again. - Removed the number of servers limit, 5 until version 1.0.9. Now is unlimited you can create as many server configuration as you want and choose between automatic or manual connection. - The Query Editor has been redesigned to make it more comfortable to work with and to be more useful. Now DBTools will stores all your queries in only one file, but you can import and export the statements to single SQL files - Added support for CROSS TABLE QUERIES, see the documentation for more details - Replaced the character @ in use for parameters, that was causing some confusing when inserting records with email addresses. Now the parameters can be described as @@param@@ and you can turn it off in the options menu of the Query Editor - Complete Help System, describing all the features in the formats: HTML Help, Manual on Line and PDF - Some minor bugs fixed More information can be found at http://dbtools.vila.bol.com.br []s Crercio O. Silva - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php