Benetl, a free ETL tool for MySQL, out in version 4.9
Dear all, Benetl, a free ETL tool for MySQL, is out in version 4.9. This new version is providing some code optimizations, tests coverage improvement. This version supports Java 1.8 and providesone bug correction (dist function now returns result as double type). You should really update. Benetl is freely dowloadable at:https://www.benetl.net You can learn more about ETL tools at: http://en.wikipedia.org/wiki/Extract,_transform,_load Thanks for your interest. Regards, -- Benoît Carpentier https://www.benetl.net Founder of Benetl and Java project manager
Re: How to get the MySQL Command-Line Tool to display Unicode properly?
Probably the dumbest suggestion yet, but have you tried "set names utf8" in the client? On 20 March 2018 20:50:08 CET, Roger House <rho...@sonic.net> wrote: > > >On 03/15/2018 02:06 PM, Roger House wrote: >> >> >> On 03/15/2018 11:30 AM, shawn l.green wrote: >>> Hi Roger, >>> >>> (please note, this is a bottom-post forum) >>> >>> On 3/13/2018 7:54 PM, Roger House wrote: >>> > >>> > On 03/13/2018 03:11 PM, Reindl Harald wrote: >>> >> >>> >> >>> >> Am 13.03.2018 um 22:59 schrieb Roger House: >>> >>> In all respects except one, the treatment of Unicode works just >>> fine. >>> >>> I can write Unicode to database tables, read it, display it, >etc., >>> >>> with no problems. The exception is mysql, the MySQL Command-Line >>> >>> Tool. When I execute a SELECT statement to see rows in a table >>> >>> containing the Venus and Mars Unicode characters, here is what I >see >>> >>> on the screen: >>> >>> >>> >>> || Venus | ♀ | | Mars | ♂ | | >>> >>> >>> >>> What I should see in the right column are the standard glyphs >for >>> >>> Venus and Mars. >>> >>> >>> >>> Any ideas about how to get the MySQL Command-Line Tool to >display >>> >>> Unicode properly? >>> >> what operating system >>> >> what terminal >>> >> >>> >> all recent Linux systems have UTF8 as default >>> >> >>> > >>> > >>>> I am running Ubuntu MATE 16.04. I have the problem also on Windows >7 >>>> and on Mac OS Version 10.11.6. I do not think that the problem has >to >>>> do with the operating system nor the terminal. Everything about >the >>>> Unicode text works fine in all tools such as editors, the cat >command, >>>> etc. It is only when I am running mysql and I issue a SELECT >>>> command to >>>> see what is in a row. Then the UTF-8 is not rendered properly. I >>>> believe the problem is with mysql. >>>> >>>> Roger >>>> >>> >>> If I presume that your terminal has a code page that is >>> utf8-compatible (you say that cat command renders the multibyte >>> characters just fine) then it could be your client-side mysql >>> settings that are rendering those multibyte characters into >>> individual glyphs based on their individual byte values. >>> >>> The next time you are in mysql and have a chance to look at some >utf8 >>> data, please collect and share these two reports: >>> >>> status >>> SHOW GLOBAL VARIABLES like '%haracter%'; >>> >>> (you can obfuscate any sensitive details like server names or >addresses) >>> >>> Yours, >> Here is the requested info: >> >> mysql> status >> -- >> mysql Ver 14.14 Distrib 5.7.21, for Linux (x86_64) using EditLine >> wrapper >> >> Connection id: 5 >> Current database: ephemeris >> Current user: root@localhost >> SSL: Not in use >> Current pager: stdout >> Using outfile: '' >> Using delimiter: ; >> Server version: 5.7.21-0ubuntu0.16.04.1 (Ubuntu) >> Protocol version: 10 >> Connection: Localhost via UNIX socket >> Server characterset: utf8mb4 >> Db characterset: latin1 >> Client characterset: utf8mb4 >> Conn. characterset: utf8mb4 >> UNIX socket: /var/run/mysqld/mysqld.sock >> Uptime: 6 hours 17 min 8 sec >> >> Threads: 1 Questions: 28 Slow queries: 0 Opens: 122 Flush tables: >> 1 Open tables: 41 Queries per second avg: 0.001 >> -- >> >> mysql> show global variables like '%haracter%'; >> +--++ >> | Variable_name | Value | >> +--++ >> | character_set_client | utf8mb4 | >> | character_set_connection | utf8mb4 | >> | character_set_database | utf8mb4 | >> | character_set_filesystem | binary | >> | character_set_results | utf8mb4 | >> | character_set_server | utf8mb4 | >> | cha
Re: How to get the MySQL Command-Line Tool to display Unicode properly?
On 03/15/2018 02:06 PM, Roger House wrote: On 03/15/2018 11:30 AM, shawn l.green wrote: Hi Roger, (please note, this is a bottom-post forum) On 3/13/2018 7:54 PM, Roger House wrote: > > On 03/13/2018 03:11 PM, Reindl Harald wrote: >> >> >> Am 13.03.2018 um 22:59 schrieb Roger House: >>> In all respects except one, the treatment of Unicode works just fine. >>> I can write Unicode to database tables, read it, display it, etc., >>> with no problems. The exception is mysql, the MySQL Command-Line >>> Tool. When I execute a SELECT statement to see rows in a table >>> containing the Venus and Mars Unicode characters, here is what I see >>> on the screen: >>> >>> || Venus | ♀ | | Mars | ♂ | | >>> >>> What I should see in the right column are the standard glyphs for >>> Venus and Mars. >>> >>> Any ideas about how to get the MySQL Command-Line Tool to display >>> Unicode properly? >> what operating system >> what terminal >> >> all recent Linux systems have UTF8 as default >> > > I am running Ubuntu MATE 16.04. I have the problem also on Windows 7 and on Mac OS Version 10.11.6. I do not think that the problem has to do with the operating system nor the terminal. Everything about the Unicode text works fine in all tools such as editors, the cat command, etc. It is only when I am running mysql and I issue a SELECT command to see what is in a row. Then the UTF-8 is not rendered properly. I believe the problem is with mysql. Roger If I presume that your terminal has a code page that is utf8-compatible (you say that cat command renders the multibyte characters just fine) then it could be your client-side mysql settings that are rendering those multibyte characters into individual glyphs based on their individual byte values. The next time you are in mysql and have a chance to look at some utf8 data, please collect and share these two reports: status SHOW GLOBAL VARIABLES like '%haracter%'; (you can obfuscate any sensitive details like server names or addresses) Yours, Here is the requested info: mysql> status -- mysql Ver 14.14 Distrib 5.7.21, for Linux (x86_64) using EditLine wrapper Connection id: 5 Current database: ephemeris Current user: root@localhost SSL: Not in use Current pager: stdout Using outfile: '' Using delimiter: ; Server version: 5.7.21-0ubuntu0.16.04.1 (Ubuntu) Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: utf8mb4 Db characterset: latin1 Client characterset: utf8mb4 Conn. characterset: utf8mb4 UNIX socket: /var/run/mysqld/mysqld.sock Uptime: 6 hours 17 min 8 sec Threads: 1 Questions: 28 Slow queries: 0 Opens: 122 Flush tables: 1 Open tables: 41 Queries per second avg: 0.001 -- mysql> show global variables like '%haracter%'; +--++ | Variable_name | Value | +--++ | character_set_client | utf8mb4 | | character_set_connection | utf8mb4 | | character_set_database | utf8mb4 | | character_set_filesystem | binary | | character_set_results | utf8mb4 | | character_set_server | utf8mb4 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | +--++ 8 rows in set (0.01 sec) Update I noticed that the status command shows Db characterset: latin1 whereas all the other charactersets are utf8mb4. So I looked around to see how to change the Db characterset, and came up with this: ALTER DATABASE ephemeris CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; After which, status shows Db characterset: utf8mb4 So the database characterset has now been changed. But select * from planet_desc; still shows Venus | ♀ Mars | ♂ I shut down the mysql service and restarted it, but this did not change anything. I'm beginning to think that the command line tool mysql does not pay any attention to character sets when the SELECT command displays on the terminal. Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: How to get the MySQL Command-Line Tool to display Unicode properly?
On 03/15/2018 11:30 AM, shawn l.green wrote: Hi Roger, (please note, this is a bottom-post forum) On 3/13/2018 7:54 PM, Roger House wrote: > > On 03/13/2018 03:11 PM, Reindl Harald wrote: >> >> >> Am 13.03.2018 um 22:59 schrieb Roger House: >>> In all respects except one, the treatment of Unicode works just fine. >>> I can write Unicode to database tables, read it, display it, etc., >>> with no problems. The exception is mysql, the MySQL Command-Line >>> Tool. When I execute a SELECT statement to see rows in a table >>> containing the Venus and Mars Unicode characters, here is what I see >>> on the screen: >>> >>> || Venus | ♀ | | Mars | ♂ | | >>> >>> What I should see in the right column are the standard glyphs for >>> Venus and Mars. >>> >>> Any ideas about how to get the MySQL Command-Line Tool to display >>> Unicode properly? >> what operating system >> what terminal >> >> all recent Linux systems have UTF8 as default >> > > I am running Ubuntu MATE 16.04. I have the problem also on Windows 7 and on Mac OS Version 10.11.6. I do not think that the problem has to do with the operating system nor the terminal. Everything about the Unicode text works fine in all tools such as editors, the cat command, etc. It is only when I am running mysql and I issue a SELECT command to see what is in a row. Then the UTF-8 is not rendered properly. I believe the problem is with mysql. Roger If I presume that your terminal has a code page that is utf8-compatible (you say that cat command renders the multibyte characters just fine) then it could be your client-side mysql settings that are rendering those multibyte characters into individual glyphs based on their individual byte values. The next time you are in mysql and have a chance to look at some utf8 data, please collect and share these two reports: status SHOW GLOBAL VARIABLES like '%haracter%'; (you can obfuscate any sensitive details like server names or addresses) Yours, Here is the requested info: mysql> status -- mysql Ver 14.14 Distrib 5.7.21, for Linux (x86_64) using EditLine wrapper Connection id: 5 Current database: ephemeris Current user: root@localhost SSL: Not in use Current pager: stdout Using outfile: '' Using delimiter: ; Server version: 5.7.21-0ubuntu0.16.04.1 (Ubuntu) Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: utf8mb4 Db characterset: latin1 Client characterset: utf8mb4 Conn. characterset: utf8mb4 UNIX socket: /var/run/mysqld/mysqld.sock Uptime: 6 hours 17 min 8 sec Threads: 1 Questions: 28 Slow queries: 0 Opens: 122 Flush tables: 1 Open tables: 41 Queries per second avg: 0.001 -- mysql> show global variables like '%haracter%'; +--++ | Variable_name | Value | +--++ | character_set_client | utf8mb4 | | character_set_connection | utf8mb4 | | character_set_database | utf8mb4 | | character_set_filesystem | binary | | character_set_results | utf8mb4 | | character_set_server | utf8mb4 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | +--++ 8 rows in set (0.01 sec) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: How to get the MySQL Command-Line Tool to display Unicode properly?
Hi Roger, (please note, this is a bottom-post forum) On 3/13/2018 7:54 PM, Roger House wrote: > > On 03/13/2018 03:11 PM, Reindl Harald wrote: >> >> >> Am 13.03.2018 um 22:59 schrieb Roger House: >>> In all respects except one, the treatment of Unicode works just fine. >>> I can write Unicode to database tables, read it, display it, etc., >>> with no problems. The exception is mysql, the MySQL Command-Line >>> Tool. When I execute a SELECT statement to see rows in a table >>> containing the Venus and Mars Unicode characters, here is what I see >>> on the screen: >>> >>> || Venus | ♀ | | Mars | ♂ | | >>> >>> What I should see in the right column are the standard glyphs for >>> Venus and Mars. >>> >>> Any ideas about how to get the MySQL Command-Line Tool to display >>> Unicode properly? >> what operating system >> what terminal >> >> all recent Linux systems have UTF8 as default >> > > I am running Ubuntu MATE 16.04. I have the problem also on Windows 7 and on Mac OS Version 10.11.6. I do not think that the problem has to do with the operating system nor the terminal. Everything about the Unicode text works fine in all tools such as editors, the cat command, etc. It is only when I am running mysql and I issue a SELECT command to see what is in a row. Then the UTF-8 is not rendered properly. I believe the problem is with mysql. Roger If I presume that your terminal has a code page that is utf8-compatible (you say that cat command renders the multibyte characters just fine) then it could be your client-side mysql settings that are rendering those multibyte characters into individual glyphs based on their individual byte values. The next time you are in mysql and have a chance to look at some utf8 data, please collect and share these two reports: status SHOW GLOBAL VARIABLES like '%haracter%'; (you can obfuscate any sensitive details like server names or addresses) Yours, -- Shawn Green MySQL Senior Principal Technical Support Engineer Oracle USA, Inc. - Integrated Cloud Applications & Platform Services Become certified in MySQL! Visit https://www.mysql.com/certification/ for details. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: How to get the MySQL Command-Line Tool to display Unicode properly?
I am running Ubuntu MATE 16.04. I have the problem also on Windows 7 and on Mac OS Version 10.11.6. I do not think that the problem has to do with the operating system nor the terminal. Everything about the Unicode text works fine in all tools such as editors, the cat command, etc. It is only when I am running mysql and I issue a SELECT command to see what is in a row. Then the UTF-8 is not rendered properly. I believe the problem is with mysql. Roger On 03/13/2018 03:11 PM, Reindl Harald wrote: Am 13.03.2018 um 22:59 schrieb Roger House: In all respects except one, the treatment of Unicode works just fine. I can write Unicode to database tables, read it, display it, etc., with no problems. The exception is mysql, the MySQL Command-Line Tool. When I execute a SELECT statement to see rows in a table containing the Venus and Mars Unicode characters, here is what I see on the screen: || Venus | ♀ | | Mars | ♂ | | What I should see in the right column are the standard glyphs for Venus and Mars. Any ideas about how to get the MySQL Command-Line Tool to display Unicode properly? what operating system what terminal all recent Linux systems have UTF8 as default -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: How to get the MySQL Command-Line Tool to display Unicode properly?
Am 13.03.2018 um 22:59 schrieb Roger House: In all respects except one, the treatment of Unicode works just fine. I can write Unicode to database tables, read it, display it, etc., with no problems. The exception is mysql, the MySQL Command-Line Tool. When I execute a SELECT statement to see rows in a table containing the Venus and Mars Unicode characters, here is what I see on the screen: || Venus | ♀ | | Mars | ♂ | | What I should see in the right column are the standard glyphs for Venus and Mars. Any ideas about how to get the MySQL Command-Line Tool to display Unicode properly? what operating system what terminal all recent Linux systems have UTF8 as default -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
How to get the MySQL Command-Line Tool to display Unicode properly?
Five months ago I posted the query shown below on StackOverflow. I got one reply which was not of much help. So I am trying again, hoping a more MySQL-centric forum might be able to solve my problem. Roger House How to get the MySQL Command-Line Tool to display Unicode properly? I use a Python program to write text containing Unicode characters to a MySQL database. As an example, two of the characters are |u'\u2640' a symbol for Venus or female u'\u2642' a symbol for Mars or male | I use utf8mb4 for virtually all character sets involved with MySQL. Here is an excerpt from /etc/mysql/my.cnf |[client] default-character-set=utf8mb4 [mysql] default-character-set=utf8mb4 [mysqld] default-character-set=utf8mb4 character-set-server =utf8mb4 character_set_system =utf8mb4 | In addition, all tables are created with these parameters: |ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci | In all respects except one, the treatment of Unicode works just fine. I can write Unicode to database tables, read it, display it, etc., with no problems. The exception is mysql, the MySQL Command-Line Tool. When I execute a SELECT statement to see rows in a table containing the Venus and Mars Unicode characters, here is what I see on the screen: || Venus | ♀ | | Mars | ♂ | | What I should see in the right column are the standard glyphs for Venus and Mars. Any ideas about how to get the MySQL Command-Line Tool to display Unicode properly? Edit: I have done a fair amount of research into the various MySQL system variables, etc., and I now realize that the my.cnf settings shown above have some serious issues. In fact, the server, mysqld, would not launch with the settings shown. To correct things, remove these from [mysqld]: |default-character-set=utf8mb4 character-set-system=utf8mb4 | I'm not sure that the [client] option does anything, but it doesn't seem to hurt. In Python u'\u2640' represents a single Unicode character, namely "♀". This compiles down to three bytes containing the hex value E29980. I am having no problems at all encoding and decoding Unicode. The correct values are being stored in a MySQL table; they are correctly read from the table, and when displayed by a Python program they show up like this: |♀ Venus ♂ Mars | The program output can be redirected to a file, processed by a text editor, etc., and in all cases the correct Unicode symbol is displayed. There is only one place where the correct Unicode symbol is not displayed, and that is when I am using the MySQL Command Line Tool. When I issue a SELECT statement on the table containing the Unicode symbols I get the junk shown above. This is not a Windows specific issue. I have exactly the same problem with the MySQL Command Line Tool when I run it on Windows, Mac OS X, and Ubuntu.
Re: How to get the MySQL Command-Line Tool to display Unicode properly
2017/10/18 18:32 ... Roger House: I get the same behavior with the MySQL Command Line Tool when I run it on Windows, Mac OS X, and Ubuntu, so I'm pretty sure the problem has to do with mysql itself. What do you know about the displays to which the client is writing? In the case of "cmd" under Windows, see what others had to do for other programs: https://stackoverflow.com/questions/388490/unicode-characters-in-windows-command-line-how -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
How to get the MySQL Command-Line Tool to display Unicode properly
I use a Python program to write text containing Unicode characters to a MySQL database. As an example, two of the characters are u'\u2640' a symbol for Venus or female u'\u2642' a symbol for Mars or male I use utf8mb4 for virtually all character sets involved with MySQL. Here is an excerpt from /etc/mysql/my.cnf [client] default-character-set=utf8mb4 [mysql] default-character-set=utf8mb4 [mysqld] character-set-server =utf8mb4 I'm not sure that the [client] option does anything, but it doesn't seem to hurt. In addition, all tables are created with these parameters: ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci In all respects except one, the treatment of Unicode works just fine. I can write Unicode to database tables, read it, display it, etc., with no problems. The exception is mysql, the MySQL Command-Line Tool. When I execute a SELECT statement to see rows in a table containing the Venus and Mars Unicode characters, here is what I see on the screen: | Venus | ♀ | | Mars | ♂ | What I want to see is this | Venus | ♀ | | Mars | ♂ | I get the same behavior with the MySQL Command Line Tool when I run it on Windows, Mac OS X, and Ubuntu, so I'm pretty sure the problem has to do with mysql itself. Any ideas about how to get the MySQL Command-Line Tool to display Unicode properly? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Benetl, a free ETL tool for MySQL, out in version 4.8
Dear all, Benetl, a free ETL tool for MySQL, is out in version 4.8. This new version is providing some code optimizations, tests coverage improvement. This version supports Java 1.8 and providesone bug correction. You should really update. Benetl is freely dowloadable at:http://www.benetl.net You can learn more about ETL tools at: http://en.wikipedia.org/wiki/Extract,_transform,_load Thanks for your interest. Regards, -- Benoît Carpentier http://www.benetl.net Founder of Benetl and Java project manager
Benetl, a free ETL tool for MySQL, out in version 4.7
Dear all, Benetl, a free ETL tool for MySQL, is out in version 4.7. This new version is providing some code optimizations, performance and tests coverage improvement. This version provides also two corrections : - correcting one bug in debug mode. - correcting one bug in logging system. You should really update. Benetl is freely dowloadable at:http://www.benetl.net You can learn more about ETL tools at: http://en.wikipedia.org/wiki/Extract,_transform,_load Thanks for your interest. Regards, -- Benoît Carpentier http://www.benetl.net Founder of Benetl and Java project manager
Re: database developer tool Database Workbench 5 now available
Hello Jan, list, From: Martijn Tonies (Upscene Productions) m.ton...@upscene.com Database Workbench now comes in multiple editions with different pricing models, there's always a version that suits you! Unless you don't do Winblows. Please put Windows dependency clearly in your announcements and on your website. I couldn't find it anywhere, until I attempted a download, and got a useless .EXE file. The announcement said: ... and works fine under Wine on Linux. Several of our customers are long-time Linux users and are very happy with Database Workbench. See also: http://www.upscene.com/company/support/database_workbench_5_on_wine_ubuntu14 Hope this helps. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
RE: database developer tool Database Workbench 5 now available
From: m.ton...@upscene.com To: j...@ecoreality.org; mysql@lists.mysql.com Subject: Re: database developer tool Database Workbench 5 now available Date: Fri, 5 Sep 2014 07:57:37 +0200 Hello Jan, list, From: Martijn Tonies (Upscene Productions) m.ton...@upscene.com Database Workbench now comes in multiple editions with different pricing models, there's always a version that suits you! Unless you don't do Winblows. Please put Windows dependency clearly in your announcements and on your website. I couldn't find it anywhere, until I attempted a download, and got a useless .EXE file. MGMy development is identical ..Development on Windows..Production on Linux MGWhen google routes me to Vladimir Putins site for Official Windows Mysql Stack you download god knows what MGsolution is to give the customer an in-between solution such as mysqld, mysqladmin and mysql shell scripts that will work under Windows cygwin MGThe Database Workbench version5 MySQL plugin README should detail *a seamless installation* for Windows cygwin MGif I have to make changes to my.ini or etc/init.d the readme should be specific on what those changes should be MGReadme should also be specific on how to successfully test mysql ports (presumably 3306)..i assume netstat -a | grep 3306? MGThanks The announcement said: ... and works fine under Wine on Linux. Several of our customers are long-time Linux users and are very happy with Database Workbench. See also: http://www.upscene.com/company/support/database_workbench_5_on_wine_ubuntu14 Hope this helps. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
Re: database developer tool Database Workbench 5 now available
MGMy development is identical ..Development on Windows..Production on Linux MGWhen google routes me to Vladimir Putins site for Official Windows Mysql Stack you download god knows what MGsolution is to give the customer an in-between solution such as mysqld, mysqladmin and mysql shell scripts that will work under Windows cygwin MGThe Database Workbench version5 MySQL plugin README should detail *a seamless installation* for Windows cygwin MGif I have to make changes to my.ini or etc/init.d the readme should be specific on what those changes should be MGReadme should also be specific on how to successfully test mysql ports (presumably 3306)..i assume netstat -a | grep 3306? MGThanks Martin, I have no idea what the above means -- Database Workbench is a client side Windows based database design and development tool, no need to Cygwin or modify my.ini With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
ANN: database developer tool Database Workbench 5 now available
Upscene releases Database Workbench 5 Upscene Productions is proud to announce the availability of the next major version of the popular multi-DBMS development tool: Database Workbench 5 There have been numerous improvements to existing tools and the new, more consistent user interface is better than ever and works fine under Wine on Linux. Database Workbench now comes in multiple editions with different pricing models, there's always a version that suits you! There is so much new in Database Workbench 5, I don't know where to start, says Martijn Tonies, founder of Upscene Productions. This release adds code editor features, has diagramming improvements, comes in multiple editions, is fully HiDPI aware and offers tunneling for MySQL and MariaDB connections. It all was a lot of work, but it was worth it! We worked closely with out customer and implemented many of their requests and for new users, we offer multiple editions to suit their development needs. From design to productivity, there's new features and improvements in almost everything! For more information, see What's new in Database Workbench 5? ( http://www.upscene.com/database_workbench/whatsnew ) Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server, SQL Anywhere, NexusDB and InterBase, comes in multiple editions and is licensed based on selectable modules. It includes tools for database design, database maintenance, testing, data transfer, data import export, database migration, database compare and numerous other tools. About Database Workbench Database Workbench is a database developer tool, over 10 years in the making and is being used by thousands of developers across the globe who have come to rely on it every day. From database design, implementation, to testing and debugging, it will aid you in your daily database work. About Upscene Productions Based in The Netherlands, Europe, this small but dedicated company has been providing database developers with useful tools for over 12 years. Slowly expanding the product portfolio and gaining recognition amongst InterBase and Firebird database developers, they now offer tools for a whole range of database systems, including Oracle and Microsoft SQL Server.
Re: ANN: database developer tool Database Workbench 5 now available
From: Martijn Tonies (Upscene Productions) m.ton...@upscene.com Database Workbench now comes in multiple editions with different pricing models, there's always a version that suits you! Unless you don't do Winblows. Please put Windows dependency clearly in your announcements and on your website. I couldn't find it anywhere, until I attempted a download, and got a useless .EXE file. The record is clear that left to their own devices, the automobile manufacturers lack the wisdom or the will or both to switch decisively to the production of inexpensive, compact, energy-saving cars appropriate to our present needs. -- Donald E. Weeden Jan Steinman, EcoReality Co-op -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Benetl, a free ETL tool for MySQL, out in version 4.5
Dear all, Benetl, a free ETL tool for MySQL, is out in version 4.5. This version of Benetl is now Java 7 and has been tested on 64 bit systems. This versions is correcting two bugs: Trouble with double parsing when data contains ',' as float separator Divide function now accepts negative operand and shows an error when divide by 0 Part operator brings a new function: fact. New error messages provided. More than 100 tests passed. You should really update. Benetl is freely dowloadable at:http://www.benetl.net You can learn more about ETL tools at: http://en.wikipedia.org/wiki/Extract,_transform,_load Thanks for your interest. Regards, -- Benoît Carpentier http://www.benetl.net Founder of Benetl and Java project manager
Benetl, a free ETL tool for MySQL, out in version 4.4
Dear all, Benetl, a free ETL tool for MySQL, is out in version 4.4. This version brings much better peformances with a new functionality: batch mode. In the GUI you can set the number of lines to be commited in a same transaction. This versions is correcting two bugs: The last line read was forgotten we re-run an EtlTool (bug brought by version 4.3). The last line read was read again if its position in the file is equal to first line to read position, when re-run an EtlTool. Some GUI improvement and new tests added. You should really update. Benetl is freely dowloadable at:http://www.benetl.net You can learn more about ETL tools at: http://en.wikipedia.org/wiki/Extract,_transform,_load Thanks for your interest. Regards, -- Benoît Carpentier http://www.benetl.net Founder of Benetl and Java project manager
Benetl, a free ETL tool for MySQL, out in version 4.3
Dear all, Benetl, a free ETL tool for MySQL, is out in version 4.3. This version brings a new way of reading control_file.xml files, several code corrections. This versions is correcting two bugs: Trouble with entity_id when inserting raw data. Trouble with sql script creation when setting none. Benetl is freely dowloadable at:http://www.benetl.net You can learn more about ETL tools at: http://en.wikipedia.org/wiki/Extract,_transform,_load Thanks for your interest. Regards, -- Benoît Carpentier http://www.benetl.net Founder of Benetl and Java project manager
monitoring tool
Hi, Are there any open source MYSQL rela time monitoring tools available in the market. Aastha
Re: monitoring tool
2012/10/10 Aastha aast...@gmail.com Hi, Are there any open source MYSQL rela time monitoring tools available in the market. Aastha Hello Aastha, You should try to be more specific when asking for stuff. What do you want to monitor? reads/writes? QPS? threads? etc Thanks Manuel.
Re: monitoring tool
it should do the following: 1. give the status of the health of the nodes -Primary concern 2. Give slow queries 3. NO or reads etc 4. No of users logged in 5. Other admin tasks On Wed, Oct 10, 2012 at 1:20 PM, Manuel Arostegui man...@tuenti.com wrote: 2012/10/10 Aastha aast...@gmail.com Hi, Are there any open source MYSQL rela time monitoring tools available in the market. Aastha Hello Aastha, You should try to be more specific when asking for stuff. What do you want to monitor? reads/writes? QPS? threads? etc Thanks Manuel.
Re: monitoring tool
Typical monitoring systems, such as Nagios, Zenoss, etc... for example, provide both a typical configuration model out the box as well as the ability to write any checks you may need for your specific environment. You should have some level of success with any of these. -Garot garotconk...@yahoo.com From: Aastha aast...@gmail.com To: Manuel Arostegui man...@tuenti.com Cc: mysql@lists.mysql.com Sent: Wednesday, October 10, 2012 2:25 PM Subject: Re: monitoring tool it should do the following: 1. give the status of the health of the nodes -Primary concern 2. Give slow queries 3. NO or reads etc 4. No of users logged in 5. Other admin tasks On Wed, Oct 10, 2012 at 1:20 PM, Manuel Arostegui man...@tuenti.com wrote: 2012/10/10 Aastha aast...@gmail.com Hi, Are there any open source MYSQL rela time monitoring tools available in the market. Aastha Hello Aastha, You should try to be more specific when asking for stuff. What do you want to monitor? reads/writes? QPS? threads? etc Thanks Manuel.
Re: monitoring tool
2012/10/10 Aastha aast...@gmail.com it should do the following: 1. give the status of the health of the nodes -Primary concern What do you mean with health of the nodes? mysqld running? master-slaves up and sync'ed? replication not broken? you using NDB?. Still a very vague explanation. 2. Give slow queries You will need to enable slow query log (trying to filter as much as possible to only log what you would consider a slow query in your environment). You'd need to scan it too. You might want to take a look at pt-query-digest. Or use regex over the log if you don't want to use external tools. 3. NO or reads etc You can parse the output of show innodb status for that. 4. No of users logged in Remember you need the SUPER privilege to be able to do this. show processlist will show you the logged users. Again, you'd need to parse its output. 5. Other admin tasks Do you really think we can help you with this description? :-) Manuel.
Benetl, a free ETL tool for MySQL, out in version 4.1
Dear all, Benetl, a free ETL tool for MySQL, is out in version 4.1. This version brings GUI improvement: control of field names and table (EtlTool) name. With this version, it is now possible to use and with if operator on a part formula. This version brings some code correction and improvement. Benetl is freely dowloadable at:http://www.benetl.net You can learn more about ETL tools at: http://en.wikipedia.org/wiki/Extract,_transform,_load Thanks for your interest. Regards, -- Benoît Carpentier http://www.benetl.net Founder of Benetl and Java project manager
Benetl, a free ETL tool for MySQL, is out in version 3.9.
Dear all, Benetl, a free ETL tool for MySQL, is out in version 3.9. This version is correcting two bugs in GUI and brings code improvement. Benetl is freely dowloadable at: http://www.benetl.net You can learn more about ETL tools at: http://en.wikipedia.org/wiki/Extract,_transform,_load Thanks for your interest. Regards, -- Benoît Carpentier http://www.benetl.net Founder of Benetl and Java project manager -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Benetl, a free ETL tool for MySQL, is out in version 3.8.
Dear all, Benetl, a free ETL tool for MySQL, is out in version 3.8. It is now supporting official MySQL (5.x) driver(s), not provided. Benetl is freely dowloadable at: http://www.benetl.net Please read documentation to see how to use the official MySQL driver instead of the provided driver. You can learn more about ETL tools at: http://en.wikipedia.org/wiki/Extract,_transform,_load Thanks for your interest. Regards -- Benoît Carpentier http://www.benetl.net Founder of Benetl and Java project manager -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Benetl a free ETL tool using MySQL is out in version 3.7
Dear all, Benetl, a free ETL tool for files using MySQL, is out in version 3.7. You can freely download it at: www.benetl.net This version brings new controls and messages in the GUI. This version brings improvements and a bug correction in GUI. You should update. You can learn more about ETL tools at: http://en.wikipedia.org/wiki/Extract,_transform,_load Thanks for your interest. Regards, -- Benoît Carpentier http://www.benetl.net Founder of Benetl and Java project manager -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Tool for shifting tables from Mysql to Postgresql
Dear all, I want to convert some tables from Mysql database to Postgresql Database in Linux Systems ( Ubuntu-10.4, CentOS ). Can someone Please tell me tool for it that makes it easier. I am able to done it through FW tools in Windows System but i want to achieve it in Linux ( CentOS ) System. I researched a lot tried below steps : 1. mysqldump --compatible=postgresql wiki20100130 /hdd4-1/wiki20100130_mysql108feb22.sql 2. sed s/\\\'/\'\'/g wiki20100130_mysql108feb22.sql 3. bin/psql -Upostgres wiki20100130 /hdd4-1/wiki20100130_mysql108feb22.sql invalid byte sequence for encoding UTF8: 0xe3ba27 HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by client_encoding. ERROR: invalid byte sequence for encoding UTF8: 0xee6c65 HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by client_encoding. ERROR: invalid byte sequence I think a tool would ease that work. Thanks best Regards, Adarsh Sharma -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Tool for shifting tables from Mysql to Postgresql
2011/3/1 Adarsh Sharma adarsh.sha...@orkash.com: Dear all, I want to convert some tables from Mysql database to Postgresql Database in Linux Systems ( Ubuntu-10.4, CentOS ). [...] invalid byte sequence for encoding UTF8: 0xe3ba27 HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by client_encoding. ERROR: invalid byte sequence for encoding UTF8: 0xee6c65 HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by client_encoding. ERROR: invalid byte sequence This is not a MySQL-specific error. You are using a character set encoding as if it were another. Please, check documentation for the options to export and import database dumps such as: http://dev.mysql.com/doc/refman/5.5/en/mysqldump.html#option_mysqldump_default-character-set -- Jaime Crespo MySQL Java Instructor Software Developer Warp Networks http://warp.es -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Tool for shifting tables from Mysql to Postgresql
By default Postgresql database encoding in UTF8. It seems to me by seeing error that database encoding in mysql is different from it. -- Cheers, Dhaval Jaiswal On 01/03/2011 3:57 PM, Adarsh Sharma wrote: Dear all, I want to convert some tables from Mysql database to Postgresql Database in Linux Systems ( Ubuntu-10.4, CentOS ). Can someone Please tell me tool for it that makes it easier. I am able to done it through FW tools in Windows System but i want to achieve it in Linux ( CentOS ) System. I researched a lot tried below steps : 1. mysqldump --compatible=postgresql wiki20100130 /hdd4-1/wiki20100130_mysql108feb22.sql 2. sed s/\\\'/\'\'/g wiki20100130_mysql108feb22.sql 3. bin/psql -Upostgres wiki20100130 /hdd4-1/wiki20100130_mysql108feb22.sql invalid byte sequence for encoding UTF8: 0xe3ba27 HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by client_encoding. ERROR: invalid byte sequence for encoding UTF8: 0xee6c65 HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by client_encoding. ERROR: invalid byte sequence I think a tool would ease that work. Thanks best Regards, Adarsh Sharma font Face='Arial' style='font-size:9pt'This e-mail, and any attachments are strictly confidential and may also contain legally privileged information. It is intended for the addressee(s) only. If you are not the intended recipient, please do not print, copy, store or act in reliance on the e-mail or any of its attachments. Instead, please notify the sender immediately and then delete the e-mail and any attachments. Unless expressly stated to the contrary, the views expressed in this e-mail are not necessarily the views of Enzen Global Solutions (P) Limited or any of its subsidiaries or affiliates (Group Companies), and the Group Companies, their directors, officers and employees makes no representation and accept no liability for the accuracy or completeness of this e-mail. You are responsible for maintaining your own virus protection and the Group Companies do not accept any liability for viruses. Enzen reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Enzen e-mail system./font -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Benetl a free ETL tool using MySQL is out in version 3.7
Dear all, Benetl, a free ETL tool for files using MySQL, is out in version 3.7. You can freely download it at: www.benetl.net This version brings new controls and messages in the GUI. This version brings improvements and a bug correction in GUI. You should update. You can learn more about ETL tools at: http://en.wikipedia.org/wiki/Extract,_transform,_load Thanks for your interest. Regards, -- Benoît Carpentier www.benetl.net Founder of Benetl and Java project manager -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Which tool to use for developing Pl/Sql on MySQL?
Hi, beginning to work with MySQL I've found there exist two similar tools for browsing the db and developing in Pl/Sql and they are SQL-Front and MySQL Query Browser. Fot not wasting time in learning both can anyone tell me which of these is generally used wordwide? So I make practice with the most used one. Thanks in advance! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Which tool to use for developing Pl/Sql on MySQL?
Go with MySQL Query Browser On Thu, Jul 15, 2010 at 1:14 PM, alba.albetti alba.albe...@libero.itwrote: Hi, beginning to work with MySQL I've found there exist two similar tools for browsing the db and developing in Pl/Sql and they are SQL-Front and MySQL Query Browser. Fot not wasting time in learning both can anyone tell me which of these is generally used wordwide? So I make practice with the most used one. Thanks in advance! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com -- Thanks Suresh Kuna MySQL DBA
Re: Which tool to use for developing Pl/Sql on MySQL?
I use Database Workbench, but might be biased ;-) www.upscene.com - there's a free Lite edition available. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! Database questions? Check the forum: http://www.databasedevelopmentforum.com Hi, beginning to work with MySQL I've found there exist two similar tools for browsing the db and developing in Pl/Sql and they are SQL-Front and MySQL Query Browser. Fot not wasting time in learning both can anyone tell me which of these is generally used wordwide? So I make practice with the most used one. Thanks in advance! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=m.ton...@upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Which tool to use for developing Pl/Sql on MySQL?
I think MySQL Query Browser has been replaced by the tool MySQL Workbench. This combines the features of the old MySQL Workbench, MySQL Administrator and MySQL Query Browser. Big improvement on the old individual tools! You can download it from http://wb.mysql.com/ On 15 July 2010 08:44, alba.albetti alba.albe...@libero.it wrote: Hi, beginning to work with MySQL I've found there exist two similar tools for browsing the db and developing in Pl/Sql and they are SQL-Front and MySQL Query Browser. Fot not wasting time in learning both can anyone tell me which of these is generally used wordwide? So I make practice with the most used one. Thanks in advance! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=john.dais...@butterflysystems.co.uk -- John Daisley Certified MySQL 5 Database Administrator Certified MySQL 5 Developer Cognos BI Developer Telephone: +44 (0)7918 621621 Email: john.dais...@butterflysystems.co.uk
Re: Fixed Connection Diagnostic Tool
Mike, much thanks and I have it fixed! The problem was that I screwed up setting the database permissions. I am really happy that I learned about mysql -h It will be a great help! Michel - Original Message - From: Michael Dykman mdyk...@gmail.com To: michel compu...@videotron.ca Cc: mysql@lists.mysql.com Sent: Tuesday, July 06, 2010 7:15 PM Subject: Re: Fixed Connection Diagnostic Tool C3P0 connection does, indeed work well on remote machines.. In fact, I only deploy it locally on dev servers. My production systems all use c3p0 on remote servers. Again, if you can connect from the command line of your client machine to the server *via TCP* with the same credentials as your DataSource is using, then it will all just work fine. You appear to have specified a bind address which made local TCP connections impossible. Address that, and you sohuld have no trouble at all. - md On Tue, Jul 6, 2010 at 6:45 PM, michel compu...@videotron.ca wrote: Thank you all for the help and info! This error happened because I started MySQL with -bind-address=91.203.57.207; even if Softslate is given the proper IP address and port number is fails on connection pooling. I fixed the problem by setting the MySQL IP address to 127.0.0.1. I am thinking that the reason is that the C3P0 connection pooling cannot work on a 'remote' machine. Michel - Original Message - From: Rob Wultsch wult...@gmail.com To: michel compu...@videotron.ca Cc: mysql@lists.mysql.com Sent: Tuesday, July 06, 2010 1:52 AM Subject: Re: Connection Diagnostic Tool On Mon, Jul 5, 2010 at 3:55 PM, michel compu...@videotron.ca wrote: I have been trying to figure this one out, but I don't have the skill sets here so I can use some help. I tried ' -h 127.0.0.1' in my bash shell and I get a command not found, so I am still really off-the-mark. Is there a place on the net I can look up what it does and how to run it? Thanks! I am pretty sure Michael that meant running the command line mysql client: mysql -uuser -ppass -h127.0.0.1 -e 'select hello world!' -- Rob Wultsch wult...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=compu...@videotron.ca -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=compu...@videotron.ca -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Fixed Connection Diagnostic Tool
Thank you all for the help and info! This error happened because I started MySQL with -bind-address=91.203.57.207; even if Softslate is given the proper IP address and port number is fails on connection pooling. I fixed the problem by setting the MySQL IP address to 127.0.0.1. I am thinking that the reason is that the C3P0 connection pooling cannot work on a 'remote' machine. Michel - Original Message - From: Rob Wultsch wult...@gmail.com To: michel compu...@videotron.ca Cc: mysql@lists.mysql.com Sent: Tuesday, July 06, 2010 1:52 AM Subject: Re: Connection Diagnostic Tool On Mon, Jul 5, 2010 at 3:55 PM, michel compu...@videotron.ca wrote: I have been trying to figure this one out, but I don't have the skill sets here so I can use some help. I tried ' -h 127.0.0.1' in my bash shell and I get a command not found, so I am still really off-the-mark. Is there a place on the net I can look up what it does and how to run it? Thanks! I am pretty sure Michael that meant running the command line mysql client: mysql -uuser -ppass -h127.0.0.1 -e 'select hello world!' -- Rob Wultsch wult...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=compu...@videotron.ca -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Fixed Connection Diagnostic Tool
C3P0 connection does, indeed work well on remote machines.. In fact, I only deploy it locally on dev servers. My production systems all use c3p0 on remote servers. Again, if you can connect from the command line of your client machine to the server *via TCP* with the same credentials as your DataSource is using, then it will all just work fine. You appear to have specified a bind address which made local TCP connections impossible. Address that, and you sohuld have no trouble at all. - md On Tue, Jul 6, 2010 at 6:45 PM, michel compu...@videotron.ca wrote: Thank you all for the help and info! This error happened because I started MySQL with -bind-address=91.203.57.207; even if Softslate is given the proper IP address and port number is fails on connection pooling. I fixed the problem by setting the MySQL IP address to 127.0.0.1. I am thinking that the reason is that the C3P0 connection pooling cannot work on a 'remote' machine. Michel - Original Message - From: Rob Wultsch wult...@gmail.com To: michel compu...@videotron.ca Cc: mysql@lists.mysql.com Sent: Tuesday, July 06, 2010 1:52 AM Subject: Re: Connection Diagnostic Tool On Mon, Jul 5, 2010 at 3:55 PM, michel compu...@videotron.ca wrote: I have been trying to figure this one out, but I don't have the skill sets here so I can use some help. I tried ' -h 127.0.0.1' in my bash shell and I get a command not found, so I am still really off-the-mark. Is there a place on the net I can look up what it does and how to run it? Thanks! I am pretty sure Michael that meant running the command line mysql client: mysql -uuser -ppass -h127.0.0.1 -e 'select hello world!' -- Rob Wultsch wult...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=compu...@videotron.ca -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
re: Connection Diagnostic Tool
I have been trying to figure this one out, but I don't have the skill sets here so I can use some help. I tried ' -h 127.0.0.1' in my bash shell and I get a command not found, so I am still really off-the-mark. Is there a place on the net I can look up what it does and how to run it? Thanks! - Original Message - From: Michael Dykman mdyk...@gmail.com To: michel compu...@videotron.ca Sent: Saturday, July 03, 2010 11:37 PM Subject: Re: Connection Diagnostic Tool You are right.. Java never coonnects on that domain socket, it *always* used TCP. Check your credentials at the command line using -h 127.0.0.1 (or even the LAN ip, depending on how your JDBC connections are configured) which will force your client to connect via TCP, just as Java will. I expect that you will find that there are permission errors preventing the TCP connec which are not obvious when connecting via the domain socket. - michael On Sat, Jul 3, 2010 at 11:14 PM, michel compu...@videotron.ca wrote: Michael, I am able to connect using the socket, so MySQL is working fine. The problem is when 'SoftSlate Commerce' tries to connect as localhost. From what I have been reading I am using the 'mysql.sock', but it's not at the default '/tmp/mysql.sock', it's created in /home/sgdev/mysql; so it may bew that I need a way to specify to 'SoftSlate Commerce' where the socket is. Regards, Michel - Original Message - From: Michael Dykman mdyk...@gmail.com To: michel compu...@videotron.ca Cc: mysql@lists.mysql.com Sent: Saturday, July 03, 2010 2:43 PM Subject: Re: Connection Diagnostic Tool I use c3p0 to manage MySQL connections in my JVM stack and have for years in many installations, I have never had to do anything special. If I can connect to the server through the console at the command line of the client machine using the same credentials, then the stack will just work. Are you using Tomcat's JNDI config? I have always found those to be a pain.. I manage my DataSource via Spring which I find to be much more portable. At the end of the day, if you are able to connect manually as described above but your Tomcat application cannot, it's is not a MySQL problem.. It's more likely a Tomcat/JNDI problem. If you can't connect via the command line (same client, same host, same credentials), then we have a MySQL issue we can address as such. - michael dykman On Sat, Jul 3, 2010 at 8:08 AM, michel compu...@videotron.ca wrote: I am setting up the Softslate web store package that uses Hibernate to connect to MySQL. Softslate fails to connect to MysQL on the c3p0 connection pooling. While I would love to solve this little problem it would be wiser if I learn to diagnose the problem. Is there a tool that can run on the Tomcat server that can help me replicate/diagnose the problem? Softslaste is running on the same box as MySQL. Thank you! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=compu...@videotron.ca -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Connection Diagnostic Tool
On Mon, Jul 5, 2010 at 3:55 PM, michel compu...@videotron.ca wrote: I have been trying to figure this one out, but I don't have the skill sets here so I can use some help. I tried ' -h 127.0.0.1' in my bash shell and I get a command not found, so I am still really off-the-mark. Is there a place on the net I can look up what it does and how to run it? Thanks! I am pretty sure Michael that meant running the command line mysql client: mysql -uuser -ppass -h127.0.0.1 -e 'select hello world!' -- Rob Wultsch wult...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Connection Diagnostic Tool
I am setting up the Softslate web store package that uses Hibernate to connect to MySQL. Softslate fails to connect to MysQL on the c3p0 connection pooling. While I would love to solve this little problem it would be wiser if I learn to diagnose the problem. Is there a tool that can run on the Tomcat server that can help me replicate/diagnose the problem? Softslaste is running on the same box as MySQL. Thank you! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Connection Diagnostic Tool
I use c3p0 to manage MySQL connections in my JVM stack and have for years in many installations, I have never had to do anything special. If I can connect to the server through the console at the command line of the client machine using the same credentials, then the stack will just work. Are you using Tomcat's JNDI config? I have always found those to be a pain.. I manage my DataSource via Spring which I find to be much more portable. At the end of the day, if you are able to connect manually as described above but your Tomcat application cannot, it's is not a MySQL problem.. It's more likely a Tomcat/JNDI problem. If you can't connect via the command line (same client, same host, same credentials), then we have a MySQL issue we can address as such. - michael dykman On Sat, Jul 3, 2010 at 8:08 AM, michel compu...@videotron.ca wrote: I am setting up the Softslate web store package that uses Hibernate to connect to MySQL. Softslate fails to connect to MysQL on the c3p0 connection pooling. While I would love to solve this little problem it would be wiser if I learn to diagnose the problem. Is there a tool that can run on the Tomcat server that can help me replicate/diagnose the problem? Softslaste is running on the same box as MySQL. Thank you! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Benetl, a free ETL tool for files using mySQL, is out in version 3.5.
Dear all, Benetl, a free ETL tool for files using mySQL, is out in version 3.5. You can freely download it at: www.benetl.net This version brings bugs correction and if operator for conditions in part formula. You should update. You can learn more about ETL tools at: http://en.wikipedia.org/wiki/Extract,_transform,_load Thanks for your interest. Regards -- Benoît Carpentier www.benetl.net Founder of Benetl and Java project manager -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Benetl, a free ETL tool for files using MySQL, is out in version 3.3
Dear all, Benetl, a free ETL tool for files using MySQL, is out in version 3.3. You can freely download it at: www.benetl.net This version brings two new improvements, you should update. You can learn more about ETL tools at: http://en.wikipedia.org/wiki/Extract,_transform,_load Thanks for your interest. Regards -- Benoît Carpentier www.benetl.net Founder of Benetl Java project manager -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Specific benchmarking tool
Johan, Yes, there are built in parsers for different formats, for example I was using the general log. mk-log-player --split Thread_id --type genlog (genlog was added the other day and is only in trunk so far) http://www.maatkit.org/doc/mk-log-player.html --type type: string; group: Split The type of log to --split (default slowlog). The permitted types are binlog Split a binary log file. slowlog Split a log file in any varation of MySQL slow-log format. Cheers, Ewen On Tue, Nov 24, 2009 at 2:41 PM, Johan De Meersman vegiv...@tuxera.be wrote: Ewen, Do you need a specific log format or setting ? I'm debugging the tool, and it uses ;\n# as record separator, which is entirely not consistent with the log format I get out of the mysql log. Does it perchance try to parse zero-execution-time slowlogs instead of the regular log ? On Sat, Nov 14, 2009 at 1:23 AM, Johan De Meersman vegiv...@tuxera.be wrote: hmm, I got segfaults. i,ll check after the weekend. On 11/13/09, ewen fortune ewen.fort...@gmail.com wrote: Johan, What does? mk-log-player? - I just used it to split and play back 8G, no problem. Ewen On Fri, Nov 13, 2009 at 6:20 PM, Johan De Meersman vegiv...@tuxera.be wrote: It seems to have a problem with multi-gigabyte files :-D On Fri, Nov 13, 2009 at 5:35 PM, Johan De Meersman vegiv...@tuxera.be wrote: Ooo, shiny ! Thanks, mate :-) On Fri, Nov 13, 2009 at 4:56 PM, ewen fortune ewen.fort...@gmail.com wrote: Johan, The very latest version of mk-log-player can do that. If you get the version from trunk: wget http://www.maatkit.org/trunk/mk-log-player mk-log-player --split Thread_id --type genlog Cheers, Ewen On Fri, Nov 13, 2009 at 4:33 PM, Johan De Meersman vegiv...@tuxera.be wrote: Hey all, I'm looking for a Mysql benchmarking/stresstesting tool that can generate a workload based on standard Mysql full query log files. The idea is to verify performance of real production loads on various database setups. Does anyone know of such a tool, free or paying ? Thx, Johan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Specific benchmarking tool
Yeah, I figured that out in the mean time :-) I was putting the log type right after --split, and the damn thing doesn't think of throwing an 'unknown field' error :-) It's working now, thanks a lot ! On Tue, Nov 24, 2009 at 8:27 PM, ewen fortune ewen.fort...@gmail.comwrote: Johan, Yes, there are built in parsers for different formats, for example I was using the general log. mk-log-player --split Thread_id --type genlog (genlog was added the other day and is only in trunk so far) http://www.maatkit.org/doc/mk-log-player.html --type type: string; group: Split The type of log to --split (default slowlog). The permitted types are binlog Split a binary log file. slowlog Split a log file in any varation of MySQL slow-log format. Cheers, Ewen On Tue, Nov 24, 2009 at 2:41 PM, Johan De Meersman vegiv...@tuxera.be wrote: Ewen, Do you need a specific log format or setting ? I'm debugging the tool, and it uses ;\n# as record separator, which is entirely not consistent with the log format I get out of the mysql log. Does it perchance try to parse zero-execution-time slowlogs instead of the regular log ? On Sat, Nov 14, 2009 at 1:23 AM, Johan De Meersman vegiv...@tuxera.be wrote: hmm, I got segfaults. i,ll check after the weekend. On 11/13/09, ewen fortune ewen.fort...@gmail.com wrote: Johan, What does? mk-log-player? - I just used it to split and play back 8G, no problem. Ewen On Fri, Nov 13, 2009 at 6:20 PM, Johan De Meersman vegiv...@tuxera.be wrote: It seems to have a problem with multi-gigabyte files :-D On Fri, Nov 13, 2009 at 5:35 PM, Johan De Meersman vegiv...@tuxera.be wrote: Ooo, shiny ! Thanks, mate :-) On Fri, Nov 13, 2009 at 4:56 PM, ewen fortune ewen.fort...@gmail.com wrote: Johan, The very latest version of mk-log-player can do that. If you get the version from trunk: wget http://www.maatkit.org/trunk/mk-log-player mk-log-player --split Thread_id --type genlog Cheers, Ewen On Fri, Nov 13, 2009 at 4:33 PM, Johan De Meersman vegiv...@tuxera.be wrote: Hey all, I'm looking for a Mysql benchmarking/stresstesting tool that can generate a workload based on standard Mysql full query log files. The idea is to verify performance of real production loads on various database setups. Does anyone know of such a tool, free or paying ? Thx, Johan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=vegiv...@tuxera.be
Specific benchmarking tool
Hey all, I'm looking for a Mysql benchmarking/stresstesting tool that can generate a workload based on standard Mysql full query log files. The idea is to verify performance of real production loads on various database setups. Does anyone know of such a tool, free or paying ? Thx, Johan
Re: Specific benchmarking tool
take a look at mysqlslap: http://dev.mysql.com/doc/refman/5.1/en/mysqlslap.html Walter On Fri, Nov 13, 2009 at 22:33, Johan De Meersman vegiv...@tuxera.be wrote: Hey all, I'm looking for a Mysql benchmarking/stresstesting tool that can generate a workload based on standard Mysql full query log files. The idea is to verify performance of real production loads on various database setups. Does anyone know of such a tool, free or paying ? Thx, Johan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Specific benchmarking tool
Johan, The very latest version of mk-log-player can do that. If you get the version from trunk: wget http://www.maatkit.org/trunk/mk-log-player mk-log-player --split Thread_id --type genlog Cheers, Ewen On Fri, Nov 13, 2009 at 4:33 PM, Johan De Meersman vegiv...@tuxera.be wrote: Hey all, I'm looking for a Mysql benchmarking/stresstesting tool that can generate a workload based on standard Mysql full query log files. The idea is to verify performance of real production loads on various database setups. Does anyone know of such a tool, free or paying ? Thx, Johan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Specific benchmarking tool
I did :-) Maybe I missed it, but I didn't see any option that suggests mysqlslap can easily replay a query log ? On Fri, Nov 13, 2009 at 4:50 PM, Walter Heck - OlinData.com li...@olindata.com wrote: take a look at mysqlslap: http://dev.mysql.com/doc/refman/5.1/en/mysqlslap.html Walter On Fri, Nov 13, 2009 at 22:33, Johan De Meersman vegiv...@tuxera.be wrote: Hey all, I'm looking for a Mysql benchmarking/stresstesting tool that can generate a workload based on standard Mysql full query log files. The idea is to verify performance of real production loads on various database setups. Does anyone know of such a tool, free or paying ? Thx, Johan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=vegiv...@tuxera.be
Re: Specific benchmarking tool
Ooo, shiny ! Thanks, mate :-) On Fri, Nov 13, 2009 at 4:56 PM, ewen fortune ewen.fort...@gmail.comwrote: Johan, The very latest version of mk-log-player can do that. If you get the version from trunk: wget http://www.maatkit.org/trunk/mk-log-player mk-log-player --split Thread_id --type genlog Cheers, Ewen On Fri, Nov 13, 2009 at 4:33 PM, Johan De Meersman vegiv...@tuxera.be wrote: Hey all, I'm looking for a Mysql benchmarking/stresstesting tool that can generate a workload based on standard Mysql full query log files. The idea is to verify performance of real production loads on various database setups. Does anyone know of such a tool, free or paying ? Thx, Johan
Benetl, a free ETL tool for files using postgreSQL, is out in version 3.2
Dear all, Benetl, a free ETL tool for files using MySQL, is out in version 3.2. This new version is now supporting Java SE 6 and using memory arguments for JVM. You can freely download it at : www.benetl.net You can learn more about ETL tools at: http://en.wikipedia.org/wiki/Extract,_transform,_load Thanks for your interest. Regards, -- Benoît Carpentier www.benetl.net Founder of Benetl Java project manager -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Benetl, a free ETL tool for files using postgreSQL, is out in version 3.2
Dear all, Benetl, a free ETL tool for files using postgreSQL and MySQL, is out in version 3.2. You can freely download it at : www.benetl.net This new version is now supporting Java SE 6 and using memory arguments for JVM. You can learn more about ETL tools at: http://en.wikipedia.org/wiki/Extract,_transform,_load Thanks for your interest. Regards, -- Benoît Carpentier www.benetl.net Founder of Benetl Java project manager -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Benetl, a free ETL tool for files using postgreSQL, is out in version 3.1 - update
Dear all, Benetl, a free ETL tool for files using postgreSQL (and now MySQL), is out in version 3.1. A small correction has been done to Benetl 3.1. This is now available online. You can freely download it at : www.benetl.net This new version brings the support of long as date. Benetl will automatically translate the long value into a date according to the date format you have chosen. You can learn more about ETL tools at: http://en.wikipedia.org/wiki/Extract,_transform,_load Thanks for your interest. Regards, -- Benoît Carpentier www.benetl.net Founder of Benetl Java project manager -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
free ETL tool for files using MySQL, Benetl version 3.1
Dear all, Benetl, a free ETL tool for files now using MySQL is out in version 3.1. You can freely download it at : www.benetl.net You can learn more about ETL tools at: http://en.wikipedia.org/wiki/Extract,_transform,_load Thanks for your interest. Regards, -- Benoît Carpentier www.benetl.net Founder of Benetl Java project manager -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
free ETL tool for files using MySQL
Dear all, Benetl, a free ETL tool for files now using MySQL is out in version 3.0. You can freely download it at : www.benetl.net You can learn more about ETL tools at: http://en.wikipedia.org/wiki/Extract,_transform,_load Thanks for your interest. Regards, -- Benoît Carpentier www.benetl.net Founder of Benetl Java project manager -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Any tool convert ibdata1/ib_logfile0/ib_logfile1 files to myisam data offline
At 04:52 PM 7/16/2009, Todd Lyons wrote: On Wed, Jul 15, 2009 at 11:58 AM, mosmo...@fastmail.fm wrote: I have backup all the database files(innodb engine). Now I want to recover it as myisam engine offline. Any suggestions? Why can't you copy the InnoDb files to another machine and open the database with another MySQL server? (You could do it on your current server but it will be CPU disk intensive). Then do a: create table MyTable1 engine=MYISAM select * from InnoTable1; If these tables are large, then you could use: create table MyTable1 engine=MYISAM select * from InnoTable1 limit 0; insert into MyTable1 select * from InnoTable1 limit 0,10; insert into MyTable1 select * from InnoTable1 limit 10,10; to import just 100k rows at a time. Now build the indexes for MyTable1. Could do it easier I would think: ALTER TABLE t1 ENGINE = MyISAM Yes, I had thought of that but I find it is safer if he copies the data from an InnoDb table to a MyISAM table. That way he can abort the operation without any fear of having his InnoDb table corrupted. With the Limit clause he can also do it in sections and it gives him more control of the operation. At least that's the way I'd do it. Mike Repeat for each table. Script it if it's more than a few tables. Note that foreign keys will break if your InnoDB table uses them. -- Regards... Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Any tool convert ibdata1/ib_logfile0/ib_logfile1 files to myisam data offline
On Wed, Jul 15, 2009 at 11:58 AM, mosmo...@fastmail.fm wrote: I have backup all the database files(innodb engine). Now I want to recover it as myisam engine offline. Any suggestions? Why can't you copy the InnoDb files to another machine and open the database with another MySQL server? (You could do it on your current server but it will be CPU disk intensive). Then do a: create table MyTable1 engine=MYISAM select * from InnoTable1; If these tables are large, then you could use: create table MyTable1 engine=MYISAM select * from InnoTable1 limit 0; insert into MyTable1 select * from InnoTable1 limit 0,10; insert into MyTable1 select * from InnoTable1 limit 10,10; to import just 100k rows at a time. Now build the indexes for MyTable1. Could do it easier I would think: ALTER TABLE t1 ENGINE = MyISAM Repeat for each table. Script it if it's more than a few tables. Note that foreign keys will break if your InnoDB table uses them. -- Regards... Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Any tool convert ibdata1/ib_logfile0/ib_logfile1 files to myisam data offline
hi all, I have backup all the database files(innodb engine). Now I want to recover it as myisam engine offline. Any suggestions? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Any tool convert ibdata1/ib_logfile0/ib_logfile1 files to myisam data offline
At 07:53 AM 7/15/2009, you wrote: hi all, I have backup all the database files(innodb engine). Now I want to recover it as myisam engine offline. Any suggestions? Why can't you copy the InnoDb files to another machine and open the database with another MySQL server? (You could do it on your current server but it will be CPU disk intensive). Then do a: create table MyTable1 engine=MYISAM select * from InnoTable1; If these tables are large, then you could use: create table MyTable1 engine=MYISAM select * from InnoTable1 limit 0; insert into MyTable1 select * from InnoTable1 limit 0,10; insert into MyTable1 select * from InnoTable1 limit 10,10; to import just 100k rows at a time. Now build the indexes for MyTable1. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Any tool convert ibdata1/ib_logfile0/ib_logfile1 files to myisam data offline
Or you could just do an export with mysqldump --single-transaction backup.sql Then replace all the ENGINE=InnoDB with ENGINE=MyIsam in the .sql file. -Original Message- From: mos [mailto:mo...@fastmail.fm] Sent: Wednesday, July 15, 2009 11:58 AM To: mysql@lists.mysql.com Subject: Re: Any tool convert ibdata1/ib_logfile0/ib_logfile1 files to myisam data offline At 07:53 AM 7/15/2009, you wrote: hi all, I have backup all the database files(innodb engine). Now I want to recover it as myisam engine offline. Any suggestions? Why can't you copy the InnoDb files to another machine and open the database with another MySQL server? (You could do it on your current server but it will be CPU disk intensive). Then do a: create table MyTable1 engine=MYISAM select * from InnoTable1; If these tables are large, then you could use: create table MyTable1 engine=MYISAM select * from InnoTable1 limit 0; insert into MyTable1 select * from InnoTable1 limit 0,10; insert into MyTable1 select * from InnoTable1 limit 10,10; to import just 100k rows at a time. Now build the indexes for MyTable1. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=gto...@ffn.com The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
MySQL command line remote monitoring tool for 5.0
Hello, I'd like to know if there is a command line tool I can run to collect vital health information for a remote mysql server (just like mysqltop) for 5.0 - I often see mysql swapping to disk and would like to know what causes that. Thanks Hitesh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Recommend a tool for editing data
Dear List, Can someone recommend a web based tool for mass-editing tables in excel like fashion? Preferably view-based (can you even edit a view in mysql, as long as it's 'simple' (sorry, coming from Ora world) We have an application which only allows to edit 'rows' one by one... yes, i know there are app drawbacks to my approach, but it's an inventory db. I am open to other suggestions (e.g. I think something like that might be doable via Access too, but it's obviously not web based) Thanks, -Andrey -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Recommend a tool for editing data
I use http://www.dadabik.org/ since many years, I find it simply great. I do not know if it is exactly what you need, but give it a try! Claudio Andrey Dmitriev wrote: Dear List, Can someone recommend a web based tool for mass-editing tables in excel like fashion? Preferably view-based (can you even edit a view in mysql, as long as it's 'simple' (sorry, coming from Ora world) We have an application which only allows to edit 'rows' one by one... yes, i know there are app drawbacks to my approach, but it's an inventory db. I am open to other suggestions (e.g. I think something like that might be doable via Access too, but it's obviously not web based) Thanks, -Andrey -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL command line remote monitoring tool for 5.0
Innotop can satisfy you demand. On Thu, Apr 16, 2009 at 4:36 PM, Hitesh Shah hrs...@gmail.com wrote: Hello, I'd like to know if there is a command line tool I can run to collect vital health information for a remote mysql server (just like mysqltop) for 5.0 - I often see mysql swapping to disk and would like to know what causes that. Thanks Hitesh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=yueliangdao0...@gmail.com -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
Re: if there're a tool which can replace mysql-proxy?
There are a couple of other proxies, including Dormando's proxy. But none of them is an official release. You should tell your customer that mysql-proxy is a core part of MySQL Enterprise. Its alpha status means that it is subject to change (as they develop MySQL Enterprise they may discover different features they don't foresee now). The alpha status doesn't mean it is unstable or poor quality, it is used in production in thousands of major installations. On Tue, Mar 24, 2009 at 4:26 AM, Moon's Father yueliangdao0...@gmail.com wrote: Hi. I want to know if there're a tool which can act as the same funciton as the mysql-proxy? Now we have a customer who want to use mysql-proxy, but he is afraid of its alpha version. So I want to know if there're another tool that can replace it? Any reply is appreciated. -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn -- Baron Schwartz, Director of Consulting, Percona Inc. Our Blog: http://www.mysqlperformanceblog.com/ Our Services: http://www.percona.com/services.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: if there're a tool which can replace mysql-proxy?
Question: my company tried the mysql-proxy about one year ago(may be more) but could not use it for not being multithreaded. They say they spoke to the 'mysql-proxy' developer. Is this still true? Are there any limitation on using mysql proxy on a high load production server? Will it be completely(almost) transparent? Thanks Claudio 2009/3/24 Baron Schwartz ba...@xaprb.com There are a couple of other proxies, including Dormando's proxy. But none of them is an official release. You should tell your customer that mysql-proxy is a core part of MySQL Enterprise. Its alpha status means that it is subject to change (as they develop MySQL Enterprise they may discover different features they don't foresee now). The alpha status doesn't mean it is unstable or poor quality, it is used in production in thousands of major installations. On Tue, Mar 24, 2009 at 4:26 AM, Moon's Father yueliangdao0...@gmail.com wrote: Hi. I want to know if there're a tool which can act as the same funciton as the mysql-proxy? Now we have a customer who want to use mysql-proxy, but he is afraid of its alpha version. So I want to know if there're another tool that can replace it? Any reply is appreciated. -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn -- Baron Schwartz, Director of Consulting, Percona Inc. Our Blog: http://www.mysqlperformanceblog.com/ Our Services: http://www.percona.com/services.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com
Re: if there're a tool which can replace mysql-proxy?
On Mar 24, 2009, at 8:06 AM, Claudio Nanni wrote: Question: Hello Claudio, my company tried the mysql-proxy about one year ago(may be more) but could not use it for not being multithreaded. They say they spoke to the 'mysql-proxy' developer. Is this still true? Are there any limitation on using mysql proxy on a high load production server? It's still not multi-threaded, but work is progressing in this area, see: https://lists.launchpad.net/mysql-proxy-discuss/msg00041.html There are people using it on high-load production servers, for various flavors of high load. How much impact *any* proxy will have depends a lot on the type of workload you run through it, and what you do with the data while it's in the proxy itself, since what's going to hurt you performance-wise is directly related to latency, caused by the extra network hop, and anything else you do that delays the data being forwarded. Will it be completely(almost) transparent? Once again, that depends on what you do to the data flowing through it. The only major non-transparent part of the proxy is the permissions system, in that clients connecting through the proxy will always *appear* to be connecting *from* the proxy from mysqld's point of view, since there is no way to forward the client address to mysqld itself. For proxy-related questions, you'll probably get more detailed, quicker responses if you join the launchpad project's mailing list at: https://launchpad.net/~mysql-proxy-discuss If you're considering using mysql-proxy, I highly recommend tracking the project via the mailing list and staying in touch with the developers and the community, to both get a better idea if it's going to work for your situation in it's current (and always changing) state, and also to provide input into the direction of the developers. Best regards, -Mark -- Mark Matthews, Architect - Enterprise Tools MySQL @ Sun Microsystems, Inc., http://www.sun.com/mysql/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: if there're a tool which can replace mysql-proxy?
Hello, One additional note in regards to learning more about the current state of MySQL Proxy and connecting with Proxy developers... Check out the Simulating Workload with MySQL Proxy webinar on April 2, with Giuseppe Maxia, MySQL Community Lead and Diego Medina, Quality Assurance Engineer @ Sun who will be talking about Proxy in general, but also some advanced topics. Thanks, -- Jimmy Mark Matthews wrote: On Mar 24, 2009, at 8:06 AM, Claudio Nanni wrote: Question: Hello Claudio, my company tried the mysql-proxy about one year ago(may be more) but could not use it for not being multithreaded. They say they spoke to the 'mysql-proxy' developer. Is this still true? Are there any limitation on using mysql proxy on a high load production server? It's still not multi-threaded, but work is progressing in this area, see: https://lists.launchpad.net/mysql-proxy-discuss/msg00041.html There are people using it on high-load production servers, for various flavors of high load. How much impact *any* proxy will have depends a lot on the type of workload you run through it, and what you do with the data while it's in the proxy itself, since what's going to hurt you performance-wise is directly related to latency, caused by the extra network hop, and anything else you do that delays the data being forwarded. Will it be completely(almost) transparent? Once again, that depends on what you do to the data flowing through it. The only major non-transparent part of the proxy is the permissions system, in that clients connecting through the proxy will always *appear* to be connecting *from* the proxy from mysqld's point of view, since there is no way to forward the client address to mysqld itself. For proxy-related questions, you'll probably get more detailed, quicker responses if you join the launchpad project's mailing list at: https://launchpad.net/~mysql-proxy-discuss If you're considering using mysql-proxy, I highly recommend tracking the project via the mailing list and staying in touch with the developers and the community, to both get a better idea if it's going to work for your situation in it's current (and always changing) state, and also to provide input into the direction of the developers. Best regards, -Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: if there're a tool which can replace mysql-proxy?
Forgot to post the URL in the event you are interested: http://www.mysql.com/news-and-events/web-seminars/display-306.html -- Jimmy Jimmy Guerrero wrote: Hello, One additional note in regards to learning more about the current state of MySQL Proxy and connecting with Proxy developers... Check out the Simulating Workload with MySQL Proxy webinar on April 2, with Giuseppe Maxia, MySQL Community Lead and Diego Medina, Quality Assurance Engineer @ Sun who will be talking about Proxy in general, but also some advanced topics. Thanks, -- Jimmy Mark Matthews wrote: On Mar 24, 2009, at 8:06 AM, Claudio Nanni wrote: Question: Hello Claudio, my company tried the mysql-proxy about one year ago(may be more) but could not use it for not being multithreaded. They say they spoke to the 'mysql-proxy' developer. Is this still true? Are there any limitation on using mysql proxy on a high load production server? It's still not multi-threaded, but work is progressing in this area, see: https://lists.launchpad.net/mysql-proxy-discuss/msg00041.html There are people using it on high-load production servers, for various flavors of high load. How much impact *any* proxy will have depends a lot on the type of workload you run through it, and what you do with the data while it's in the proxy itself, since what's going to hurt you performance-wise is directly related to latency, caused by the extra network hop, and anything else you do that delays the data being forwarded. Will it be completely(almost) transparent? Once again, that depends on what you do to the data flowing through it. The only major non-transparent part of the proxy is the permissions system, in that clients connecting through the proxy will always *appear* to be connecting *from* the proxy from mysqld's point of view, since there is no way to forward the client address to mysqld itself. For proxy-related questions, you'll probably get more detailed, quicker responses if you join the launchpad project's mailing list at: https://launchpad.net/~mysql-proxy-discuss If you're considering using mysql-proxy, I highly recommend tracking the project via the mailing list and staying in touch with the developers and the community, to both get a better idea if it's going to work for your situation in it's current (and always changing) state, and also to provide input into the direction of the developers. Best regards, -Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: if there're a tool which can replace mysql-proxy?
Great, thanks guys, I think after subqueries,triggers , stored procs and views is the most awaited thingie now! Cheers Claudio 2009/3/24 Jimmy Guerrero jimmy.guerr...@sun.com Forgot to post the URL in the event you are interested: http://www.mysql.com/news-and-events/web-seminars/display-306.html -- Jimmy Jimmy Guerrero wrote: Hello, One additional note in regards to learning more about the current state of MySQL Proxy and connecting with Proxy developers... Check out the Simulating Workload with MySQL Proxy webinar on April 2, with Giuseppe Maxia, MySQL Community Lead and Diego Medina, Quality Assurance Engineer @ Sun who will be talking about Proxy in general, but also some advanced topics. Thanks, -- Jimmy Mark Matthews wrote: On Mar 24, 2009, at 8:06 AM, Claudio Nanni wrote: Question: Hello Claudio, my company tried the mysql-proxy about one year ago(may be more) but could not use it for not being multithreaded. They say they spoke to the 'mysql-proxy' developer. Is this still true? Are there any limitation on using mysql proxy on a high load production server? It's still not multi-threaded, but work is progressing in this area, see: https://lists.launchpad.net/mysql-proxy-discuss/msg00041.html There are people using it on high-load production servers, for various flavors of high load. How much impact *any* proxy will have depends a lot on the type of workload you run through it, and what you do with the data while it's in the proxy itself, since what's going to hurt you performance-wise is directly related to latency, caused by the extra network hop, and anything else you do that delays the data being forwarded. Will it be completely(almost) transparent? Once again, that depends on what you do to the data flowing through it. The only major non-transparent part of the proxy is the permissions system, in that clients connecting through the proxy will always *appear* to be connecting *from* the proxy from mysqld's point of view, since there is no way to forward the client address to mysqld itself. For proxy-related questions, you'll probably get more detailed, quicker responses if you join the launchpad project's mailing list at: https://launchpad.net/~mysql-proxy-discusshttps://launchpad.net/%7Emysql-proxy-discuss If you're considering using mysql-proxy, I highly recommend tracking the project via the mailing list and staying in touch with the developers and the community, to both get a better idea if it's going to work for your situation in it's current (and always changing) state, and also to provide input into the direction of the developers. Best regards, -Mark
MySQL Binary Log Summary Tool
All Lately I am struggling with big tables maintenance, I've just made a very quick and dirty tool for having summaries from the binary log files, like how many times a table was updated, or inserted or deleted. Before going any further I would really appreciate your opinion to know if there is sense in improving it. Thanks in advance Claudio
MySQL Binary Log Summary Tool - w/link!
All Lately I am struggling with big tables maintenance, I've just made a very quick and dirty tool for having summaries from the binary log files, like how many times a table was updated, or inserted or deleted. Before going any further I would really appreciate your opinion to know if there is sense in improving it. Thanks in advance Claudio http://forge.mysql.com/tools/tool.php?id=185
Re: A tool
Hi Krishna Chandra Prajapati, How can i customize, to make it work on debian OS After months of search finally yesterday i got debian - Lastnight i tested giis binary with debian -- yes running binary version gave me an Error as Floating Exception Then i tried to compile it from source it worked well.Please refer INSTALL file on how to compile from source (it has only 5 steps) I will fix this giis binary issue - till then debian user can try it from source. Anyway debian looks cool. :) Cheers, Lakshmipathi.G On Wed, Nov 19, 2008 at 11:48 AM, Krishna Chandra Prajapati prajapat...@gmail.com wrote: Thanks, I will be waiting for your reply. On Wed, Nov 19, 2008 at 10:22 AM, lakshmi pathi lakshmipath...@gmail.com wrote: Thanks for your comments :) How can i customize, to make it work on debian OS. It should work for all ext3 Linux distros giis tested with Fedroa ,Redhat and Ubuntu ... I haven't tried it with debianso right now,i don't how to customize it for debian...I'll try and check with debian and let you know in few days time. Cheers, Lakshmipathi.G On Tue, Nov 18, 2008 at 1:55 PM, Krishna Chandra Prajapati prajapat...@gmail.com wrote: Hi, It's a nice tool. Working for fedora. But not for debian. How can i customize, to make it work on debian OS. On Mon, Nov 17, 2008 at 12:25 PM, lakshmi pathi lakshmipath...@gmail.com wrote: Hi all, If you are using mysql in linux with ext3 file system,then this might help. I have written a undelete tool. [Short functionality is ,once installed files can be recovered using the tool but files deleted before installation can't be recovered. It acts as a fail-safe.] I tried it with mysql,for screenshots check here, http://www.giis.co.in/giis_mysql_screenshots.html You can download it from http://sourceforge.net/projects/giis or from here www.giis.co.in I have recovered only tables and not yet started with complete databases, based on your comments i hope to decided on futher enhancements. (If you have already such functionality available ,please let me know - as there is no point in reinventing the wheel :) ) (ps:I posted the similar message few days back on the forum ..but didn't received any comments/info..so i'm here :) ) Cheers, Lakshmipathi.G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=prajapat...@gmail.com -- Krishna Chandra Prajapati MySQL DBA, Mob: 9912924044 Email-id: prajapat...@gmail.com -- Cheers, Lakshmipathi.G -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road, Secunderabad. Pin Code: 53 Mob: 9912924044 Email-id: prajapat...@gmail.com -- Cheers, Lakshmipathi.G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: A tool
Thanks lakshmi On Wed, Jan 21, 2009 at 11:53 AM, lakshmi pathi lakshmipath...@gmail.comwrote: Hi Krishna Chandra Prajapati, How can i customize, to make it work on debian OS After months of search finally yesterday i got debian - Lastnight i tested giis binary with debian -- yes running binary version gave me an Error as Floating Exception Then i tried to compile it from source it worked well.Please refer INSTALL file on how to compile from source (it has only 5 steps) I will fix this giis binary issue - till then debian user can try it from source. Anyway debian looks cool. :) Cheers, Lakshmipathi.G On Wed, Nov 19, 2008 at 11:48 AM, Krishna Chandra Prajapati prajapat...@gmail.com wrote: Thanks, I will be waiting for your reply. On Wed, Nov 19, 2008 at 10:22 AM, lakshmi pathi lakshmipath...@gmail.com wrote: Thanks for your comments :) How can i customize, to make it work on debian OS. It should work for all ext3 Linux distros giis tested with Fedroa ,Redhat and Ubuntu ... I haven't tried it with debianso right now,i don't how to customize it for debian...I'll try and check with debian and let you know in few days time. Cheers, Lakshmipathi.G On Tue, Nov 18, 2008 at 1:55 PM, Krishna Chandra Prajapati prajapat...@gmail.com wrote: Hi, It's a nice tool. Working for fedora. But not for debian. How can i customize, to make it work on debian OS. On Mon, Nov 17, 2008 at 12:25 PM, lakshmi pathi lakshmipath...@gmail.com wrote: Hi all, If you are using mysql in linux with ext3 file system,then this might help. I have written a undelete tool. [Short functionality is ,once installed files can be recovered using the tool but files deleted before installation can't be recovered. It acts as a fail-safe.] I tried it with mysql,for screenshots check here, http://www.giis.co.in/giis_mysql_screenshots.html You can download it from http://sourceforge.net/projects/giis or from here www.giis.co.in I have recovered only tables and not yet started with complete databases, based on your comments i hope to decided on futher enhancements. (If you have already such functionality available ,please let me know - as there is no point in reinventing the wheel :) ) (ps:I posted the similar message few days back on the forum ..but didn't received any comments/info..so i'm here :) ) Cheers, Lakshmipathi.G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=prajapat...@gmail.com -- Krishna Chandra Prajapati MySQL DBA, Mob: 9912924044 Email-id: prajapat...@gmail.com -- Cheers, Lakshmipathi.G -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road, Secunderabad. Pin Code: 53 Mob: 9912924044 Email-id: prajapat...@gmail.com -- Cheers, Lakshmipathi.G -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road, Secunderabad. Pin Code: 53 Office Number: 040-66489771 Mob: 9912924044 URL: ed-ventures-online.com Email-id: prajapat...@gmail.com
Re: A tool
Hi, It's a nice tool. Working for fedora. But not for debian. How can i customize, to make it work on debian OS. On Mon, Nov 17, 2008 at 12:25 PM, lakshmi pathi [EMAIL PROTECTED]wrote: Hi all, If you are using mysql in linux with ext3 file system,then this might help. I have written a undelete tool. [Short functionality is ,once installed files can be recovered using the tool but files deleted before installation can't be recovered. It acts as a fail-safe.] I tried it with mysql,for screenshots check here, http://www.giis.co.in/giis_mysql_screenshots.html You can download it from http://sourceforge.net/projects/giis or from here www.giis.co.in I have recovered only tables and not yet started with complete databases, based on your comments i hope to decided on futher enhancements. (If you have already such functionality available ,please let me know - as there is no point in reinventing the wheel :) ) (ps:I posted the similar message few days back on the forum ..but didn't received any comments/info..so i'm here :) ) Cheers, Lakshmipathi.G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Krishna Chandra Prajapati MySQL DBA, Mob: 9912924044 Email-id: [EMAIL PROTECTED]
Re: A tool
Thanks for your comments :) How can i customize, to make it work on debian OS. It should work for all ext3 Linux distros giis tested with Fedroa ,Redhat and Ubuntu ... I haven't tried it with debianso right now,i don't how to customize it for debian...I'll try and check with debian and let you know in few days time. Cheers, Lakshmipathi.G On Tue, Nov 18, 2008 at 1:55 PM, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote: Hi, It's a nice tool. Working for fedora. But not for debian. How can i customize, to make it work on debian OS. On Mon, Nov 17, 2008 at 12:25 PM, lakshmi pathi [EMAIL PROTECTED] wrote: Hi all, If you are using mysql in linux with ext3 file system,then this might help. I have written a undelete tool. [Short functionality is ,once installed files can be recovered using the tool but files deleted before installation can't be recovered. It acts as a fail-safe.] I tried it with mysql,for screenshots check here, http://www.giis.co.in/giis_mysql_screenshots.html You can download it from http://sourceforge.net/projects/giis or from here www.giis.co.in I have recovered only tables and not yet started with complete databases, based on your comments i hope to decided on futher enhancements. (If you have already such functionality available ,please let me know - as there is no point in reinventing the wheel :) ) (ps:I posted the similar message few days back on the forum ..but didn't received any comments/info..so i'm here :) ) Cheers, Lakshmipathi.G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Krishna Chandra Prajapati MySQL DBA, Mob: 9912924044 Email-id: [EMAIL PROTECTED] -- Cheers, Lakshmipathi.G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: A tool
Thanks, I will be waiting for your reply. On Wed, Nov 19, 2008 at 10:22 AM, lakshmi pathi [EMAIL PROTECTED]wrote: Thanks for your comments :) How can i customize, to make it work on debian OS. It should work for all ext3 Linux distros giis tested with Fedroa ,Redhat and Ubuntu ... I haven't tried it with debianso right now,i don't how to customize it for debian...I'll try and check with debian and let you know in few days time. Cheers, Lakshmipathi.G On Tue, Nov 18, 2008 at 1:55 PM, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote: Hi, It's a nice tool. Working for fedora. But not for debian. How can i customize, to make it work on debian OS. On Mon, Nov 17, 2008 at 12:25 PM, lakshmi pathi [EMAIL PROTECTED] wrote: Hi all, If you are using mysql in linux with ext3 file system,then this might help. I have written a undelete tool. [Short functionality is ,once installed files can be recovered using the tool but files deleted before installation can't be recovered. It acts as a fail-safe.] I tried it with mysql,for screenshots check here, http://www.giis.co.in/giis_mysql_screenshots.html You can download it from http://sourceforge.net/projects/giis or from here www.giis.co.in I have recovered only tables and not yet started with complete databases, based on your comments i hope to decided on futher enhancements. (If you have already such functionality available ,please let me know - as there is no point in reinventing the wheel :) ) (ps:I posted the similar message few days back on the forum ..but didn't received any comments/info..so i'm here :) ) Cheers, Lakshmipathi.G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Krishna Chandra Prajapati MySQL DBA, Mob: 9912924044 Email-id: [EMAIL PROTECTED] -- Cheers, Lakshmipathi.G -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road, Secunderabad. Pin Code: 53 Mob: 9912924044 Email-id: [EMAIL PROTECTED]
Re: A tool
really nice tool. Thanks, Saravanan --- On Mon, 11/17/08, lakshmi pathi [EMAIL PROTECTED] wrote: From: lakshmi pathi [EMAIL PROTECTED] Subject: A tool To: mysql@lists.mysql.com Date: Monday, November 17, 2008, 1:25 PM Hi all, If you are using mysql in linux with ext3 file system,then this might help. I have written a undelete tool. [Short functionality is ,once installed files can be recovered using the tool but files deleted before installation can't be recovered. It acts as a fail-safe.] I tried it with mysql,for screenshots check here, http://www.giis.co.in/giis_mysql_screenshots.html You can download it from http://sourceforge.net/projects/giis or from here www.giis.co.in I have recovered only tables and not yet started with complete databases, based on your comments i hope to decided on futher enhancements. (If you have already such functionality available ,please let me know - as there is no point in reinventing the wheel :) ) (ps:I posted the similar message few days back on the forum ..but didn't received any comments/info..so i'm here :) ) Cheers, Lakshmipathi.G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: A tool
Yeah, it's really a nice tool for me. Thanks. On Tue, Nov 18, 2008 at 5:44 AM, Saravanan [EMAIL PROTECTED] wrote: really nice tool. Thanks, Saravanan --- On Mon, 11/17/08, lakshmi pathi [EMAIL PROTECTED] wrote: From: lakshmi pathi [EMAIL PROTECTED] Subject: A tool To: mysql@lists.mysql.com Date: Monday, November 17, 2008, 1:25 PM Hi all, If you are using mysql in linux with ext3 file system,then this might help. I have written a undelete tool. [Short functionality is ,once installed files can be recovered using the tool but files deleted before installation can't be recovered. It acts as a fail-safe.] I tried it with mysql,for screenshots check here, http://www.giis.co.in/giis_mysql_screenshots.html You can download it from http://sourceforge.net/projects/giis or from here www.giis.co.in I have recovered only tables and not yet started with complete databases, based on your comments i hope to decided on futher enhancements. (If you have already such functionality available ,please let me know - as there is no point in reinventing the wheel :) ) (ps:I posted the similar message few days back on the forum ..but didn't received any comments/info..so i'm here :) ) Cheers, Lakshmipathi.G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
A tool
Hi all, If you are using mysql in linux with ext3 file system,then this might help. I have written a undelete tool. [Short functionality is ,once installed files can be recovered using the tool but files deleted before installation can't be recovered. It acts as a fail-safe.] I tried it with mysql,for screenshots check here, http://www.giis.co.in/giis_mysql_screenshots.html You can download it from http://sourceforge.net/projects/giis or from here www.giis.co.in I have recovered only tables and not yet started with complete databases, based on your comments i hope to decided on futher enhancements. (If you have already such functionality available ,please let me know - as there is no point in reinventing the wheel :) ) (ps:I posted the similar message few days back on the forum ..but didn't received any comments/info..so i'm here :) ) Cheers, Lakshmipathi.G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Table/Content Comparison Tool
Hello all, We've experienced a MySQL problem, during which few of the tables got corrupted. Because of this, few of the websites contained gibberish and we had to restore from backup. This problem was caused by overloaded CPU and unwritten data to the hard disk. We are looking for a method or a software tool, manual or automatic, that would help us identify differences between a last night's backup of the tables to their current state. The tool would show the differences, down to the content, and allow us to choose which version to restore/keep. Anyone knows of such a tool?? Anyone have an idea how to avoid such situation in the future? Thank you in advance. Noor
MySql Administrator Tool Login
Hello I successfully installed the mysql database on my pc. I also installed the mysql administrator tool. I am trying to login and I need some assistance. It is asking for stored connection, server host, username and password. I am not sure what to put in here. When I installed the database I did not give a password to the administrator question. I do not remember the administrator id. Would someone be so kind as to assist me with getting logged in on this tool? Thanks, Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySql Administrator Tool Login
On 8/7/08, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hello I successfully installed the mysql database on my pc. I also installed the mysql administrator tool. I am trying to login and I need some assistance. It is asking for stored connection, server host, username and password. I am not sure what to put in here. When I installed the database I did not give a password to the administrator question. I do not remember the administrator id. Would someone be so kind as to assist me with getting logged in on this tool? Thanks, Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Maybe try username= and password= and host=localhost -- --David.
Re: Some way/tool to do this with database scripts backups
hello let me explain me more think a table how this case cliente is customer/client in english Field Type Null Key Default Extra --- --- -- -- idCliente varchar(11) NO PRI razonCliente varchar(80) NO direccionCliente varchar(80) NO rucClientevarchar(11) NO dniClientevarchar(9) NO telefonoCliente varchar(15) NO celularClientevarchar(10) NO emailCliente varchar(50) NO fechaNacimiento date NO ciudadvarchar(20) NO ok i would have 1 to N rows already inserted in the db, and i can do a simple backup with some script/administration tool for any database (mysql/postgresql) for instance A.sql which would has this content INSERT INTO `cliente` (`idCliente`,`razonCliente`,`direccionCliente`,`rucCliente`,`dniCliente`,`telefonoCliente`,`celularCliente`,`emailCliente`,`fechaNacimiento`,`ciudad`) VALUES ('000273999','JOZEP E. VAN DEN OUWELAND','JIRON CONDE DE LEMOS # 226 - PUNO','','000273999','','','','2008-02-15','PUNO'), ('00454507','ALBERTO JESUS MARTIN LAZO FERNANDEZ','URB. SEÑORIAL H-4 CAYMA - AREQUIPA','','00454507','','','','2008-01-29','AREQUIPA'), . the point is that table cliente has how you can see 10 columns for each insertion written by the backup the problem and my requirement is create a new sql file (called B.sql) with this content UPDATE cliente SET razonCliente='JOZEP E. VAN DEN OUWELAND', ciudad='PUNO' WHERE idCliente='000273999' UPDATE cliente SET razonCliente='ALBERTO JESUS MARTIN LAZO FERNANDEZ', ciudad='AREQUIPA' WHERE idCliente='00454507' . so for each INSERT statement createad in A.sql i need generate a UPDATE statement in B.sql with the columns that i want to update, in this case razonCliente, ciudad why i need create a B.sql?, the reason is to have a batch with a lot UPDATE staments, so i can open the file and edit some row and a specific column that i need for instance UPDATE cliente SET razonCliente='JOZEP E. VAN DEN OUWELAND', ciudad='OTHER CITY' WHERE idCliente='000273999' UPDATE cliente SET razonCliente='I HAVE A NEW NAME', ciudad='AREQUIPA' WHERE idCliente='00454507' . maybe i would need create a C.sql in this way UPDATE cliente SET ciudad='PUNO' WHERE idCliente='000273999' UPDATE cliente SET ciudad='AREQUIPA' WHERE idCliente='00454507' . to only have the option to edit the column ciudad for some row i hope you see my point now thanks in advanced -- View this message in context: http://www.nabble.com/Some-way-tool-to-do-this-with-database-scripts-backups-tp16496072p16633902.html Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Some way/tool to do this with database scripts backups
Hello Martijn thanks so much for your reply pls read this carefully ok for instance i already know how use mysqldump, so i can get A.sql , something like this insert into person(id,name,age,sex ) VALUES (01, jesus, 33, male ), insert into person(id,name,age,sex ) VALUES (02, michael, 17, male), insert into person(id,name,age,sex ) VALUES (03, lucia, 18, female), the point i need generate a B.sql (from A.sql or other way) something like this UPDATE person name='jesus', age='33' WHERE id='01', UPDATE person name='michael', age='17' WHERE id='02', UPDATE person name='lucia', age='18' WHERE id='03', if you can see in my desired B.sql for each row from A.sql (insert) i have a match row in B.sql (update) see 2 importants things 1: one column is missing (sex) thats the reason that i need create this B.sql with my desired columns to update 2: the information in update statements are the same like to A.sql, but i am free to change some row to update in other words i need something like a template (B.sql) to update any update statment and the desired columns i hope you see my point now thanks in advanced Martijn van den Burg wrote: Hi, if i have for example a simple table call person with 'id' and 'name' how columns i can do a backup and get some file (A.sql) with all the inserts statements here, all fine but how i can do this? Have a look at the 'mysqldump' command line utility. It goes something like 'mysqldump -u user -p password -h host database [table] output.sql'. This will generate a text file with SQL statements that you can use to recreate the table. See http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html. for each insert statement generated in A.sql create a new B.sql, with update statements its possible do this? You could do this by editting the 'output.sql' file, changing the table name from A to B. Or you could execute the following SQL: 'CREATE TABLE B SELECT * FROM A'. See http://dev.mysql.com/doc/refman/5.0/en/create-table.html. even worst, if a have a table with 20 columns i need the way to generate the same B.sql but with my desired columns to update I am not sure I understand your question, but you could make a database export using 'mysqldump', then alter the statements in the resulting output file to create the tables you need... HTH, Martijn -- The information contained in this communication and any attachments is confidential and may be privileged, and is for the sole use of the intended recipient(s). Any unauthorized review, use, disclosure or distribution is prohibited. Unless explicitly stated otherwise in the body of this communication or the attachment thereto (if any), the information is provided on an AS-IS basis without any express or implied warranties or liabilities. To the extent you are relying on this information, you are doing so at your own risk. If you are not the intended recipient, please notify the sender immediately by replying to this message and destroy all copies of this message and any attachments. ASML is neither liable for the proper and complete transmission of the information contained in this communication, nor for any delay in its receipt. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- View this message in context: http://www.nabble.com/Some-way-tool-to-do-this-with-database-scripts-backups-tp16496072p16524400.html Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Some way/tool to do this with database scripts backups
Hi, if i have for example a simple table call person with 'id' and 'name' how columns i can do a backup and get some file (A.sql) with all the inserts statements here, all fine but how i can do this? Have a look at the 'mysqldump' command line utility. It goes something like 'mysqldump -u user -p password -h host database [table] output.sql'. This will generate a text file with SQL statements that you can use to recreate the table. See http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html. for each insert statement generated in A.sql create a new B.sql, with update statements its possible do this? You could do this by editting the 'output.sql' file, changing the table name from A to B. Or you could execute the following SQL: 'CREATE TABLE B SELECT * FROM A'. See http://dev.mysql.com/doc/refman/5.0/en/create-table.html. even worst, if a have a table with 20 columns i need the way to generate the same B.sql but with my desired columns to update I am not sure I understand your question, but you could make a database export using 'mysqldump', then alter the statements in the resulting output file to create the tables you need... HTH, Martijn -- The information contained in this communication and any attachments is confidential and may be privileged, and is for the sole use of the intended recipient(s). Any unauthorized review, use, disclosure or distribution is prohibited. Unless explicitly stated otherwise in the body of this communication or the attachment thereto (if any), the information is provided on an AS-IS basis without any express or implied warranties or liabilities. To the extent you are relying on this information, you are doing so at your own risk. If you are not the intended recipient, please notify the sender immediately by replying to this message and destroy all copies of this message and any attachments. ASML is neither liable for the proper and complete transmission of the information contained in this communication, nor for any delay in its receipt. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Some way/tool to do this with database scripts backups
Hello guys if i have for example a simple table call person with 'id' and 'name' how columns i can do a backup and get some file (A.sql) with all the inserts statements here, all fine but how i can do this? for each insert statement generated in A.sql create a new B.sql, with update statements its possible do this? even worst, if a have a table with 20 columns i need the way to generate the same B.sql but with my desired columns to update thanks in advanced -- View this message in context: http://www.nabble.com/Some-way-tool-to-do-this-with-database-scripts-backups-tp16496072p16496072.html Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ANN: AnySQL Maestro released (freeware cross-database tool)
Hi! SQL Maestro Group announces the release of AnySQL Maestro - a freeware, but powerful tool for all the database engines accessible via ODBC driver or OLE DB provider (Access, SQL Server, Firebird, Oracle, MySQL, PostgreSQL, SQLite, etc). http://www.sqlmaestro.com/products/anysql/maestro/ AnySQL Maestro has been successfully tested with the latest MySQL ODBC drivers (both 3.51 and 5.1), and all the latest MySQL server versions. Key features: - database object management - graphical database designer - visual query builder - data export and import - BLOB Viewer/Editor - and a lot of other things. Full press-release: http://www.sqlmaestro.com/news/company/4843/ Background information: SQL Maestro Group is engaged in developing complete database admin and management tools for MySQL, Oracle, MS SQL Server, PostgreSQL, SQLite, Firebird and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, SQL Maestro Group http://www.sqlmaestro.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Disk Benchmark Tool
Dear List, I am after a tool which benchmarks a file system in the same way that a MySql InnoDB system is likely to access it. That is, small random reads and writes in a very large file. For instance, the tool 'bonnie++' is no good for this as is concentrates too much on sequential read and write. If any members can suggest what might be appropriate, I would be interested in knowing :) Regards, Ben Clewett. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql to mysql conversion tool
Hi, I'm looking an application which let me convert one mysql to another db. I need this to port my website from one cms (Vivvo) to another (Drupal). -- Sharique uddin Ahmed Farooqui (C++/C# Developer, IT Consultant) A revolution is about to begin. A world is about to change. And you and I are the initiator.
RE: mysql to mysql conversion tool
Check out DBConvert variants.. http://www.dbconvert.com/ -Original Message- From: Sharique uddin Ahmed Farooqui [mailto:[EMAIL PROTECTED] Sent: 29 January 2008 18:16 To: mysql@lists.mysql.com Subject: mysql to mysql conversion tool Hi, I'm looking an application which let me convert one mysql to another db. I need this to port my website from one cms (Vivvo) to another (Drupal). -- Sharique uddin Ahmed Farooqui (C++/C# Developer, IT Consultant) A revolution is about to begin. A world is about to change. And you and I are the initiator. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql to mysql conversion tool
http://drupal.org/project/convert2drupal NB: no pending tasks AND no developers working on any part of the project the author claims a release in january (but has'nt published anything yet..) Looks like you there is some work ahead of you.. Oi Vay! - Original Message - From: Sharique uddin Ahmed Farooqui [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tuesday, January 29, 2008 1:16 PM Subject: mysql to mysql conversion tool Hi, I'm looking an application which let me convert one mysql to another db. I need this to port my website from one cms (Vivvo) to another (Drupal). -- Sharique uddin Ahmed Farooqui (C++/C# Developer, IT Consultant) A revolution is about to begin. A world is about to change. And you and I are the initiator. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Monitoring and analysis tool
Daniel Caune wrote: Hi, Our MySQL server used for our development environment is slowing down, certainly because of a massive query execution by different processes. We are trying to determine which kind of query is the most executed and on which database instance(s). We are quite novice in administrating MySQL. We imagine that we can configure MySQL so that it logs every queries executed in its queries.log file. However is there any analysis tool that would import this log file and that would generate a complete report providing the number of similar queries (same DML order on the same table) per databases per minute? P.S.: we are using mytop and innotop, but it seems that they don't support such a feature. We see a lot of different queries executed against MySQL but we can't figure out, which kind of queries is the most executed, on which database. Turn on the slow query log (log_slow_queries), set long_query_time to 1 (second), and then use the mysqldumpslow tool to aggregate all of the slow queries: [EMAIL PROTECTED]:~/mysql/mysql-5.0-bk] $ mysqldumpslow --help Usage: mysqldumpslow [ OPTS... ] [ LOGS... ] Parse and summarize the MySQL slow query log. Options are --verboseverbose --debug debug --help write this text to standard output -v verbose -d debug -s ORDER what to sort by (t, at, l, al, r, ar etc), 'at' is default -r reverse the sort order (largest last instead of first) -t NUM just show the top n queries -a don't abstract all numbers to N and strings to 'S' -n NUM abstract numbers with at least n digits within names -g PATTERN grep: only consider stmts that include this string -h HOSTNAME hostname of db server for *-slow.log filename (can be wildcard), default is '*', i.e. match all -i NAME name of server instance (if using mysql.server startup script) -l don't subtract lock time from total time http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html Regards Mark -- Mark Leith, Manager of Support, Americas MySQL AB, www.mysql.com Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Monitoring and analysis tool
-Message d'origine- De : Mark Leith [mailto:[EMAIL PROTECTED] Envoyé : dimanche, décembre 16, 2007 04:53 À : Daniel Caune Cc : mysql@lists.mysql.com Objet : Re: Monitoring and analysis tool Daniel Caune wrote: Hi, Our MySQL server used for our development environment is slowing down, certainly because of a massive query execution by different processes. We are trying to determine which kind of query is the most executed and on which database instance(s). We are quite novice in administrating MySQL. We imagine that we can configure MySQL so that it logs every queries executed in its queries.log file. However is there any analysis tool that would import this log file and that would generate a complete report providing the number of similar queries (same DML order on the same table) per databases per minute? P.S.: we are using mytop and innotop, but it seems that they don't support such a feature. We see a lot of different queries executed against MySQL but we can't figure out, which kind of queries is the most executed, on which database. Turn on the slow query log (log_slow_queries), set long_query_time to 1 (second), and then use the mysqldumpslow tool to aggregate all of the slow queries: Thanks. However how can I trace every queries run against MySQL traced into slow-queries.log in order to use the mysqldumpslow tool? The minimum and default values of long_query_time are 1 and 10, respectively. It seems that I can't set 0 for long_query_time. -- Daniel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Monitoring and analysis tool
Daniel, On Dec 16, 2007 12:37 PM, Daniel Caune [EMAIL PROTECTED] wrote: -Message d'origine- De: Mark Leith [mailto:[EMAIL PROTECTED] Envoyé: dimanche, décembre 16, 2007 04:53 À: Daniel Caune Cc: mysql@lists.mysql.com Objet: Re: Monitoring and analysis tool Daniel Caune wrote: Hi, Our MySQL server used for our development environment is slowing down, certainly because of a massive query execution by different processes. We are trying to determine which kind of query is the most executed and on which database instance(s). We are quite novice in administrating MySQL. We imagine that we can configure MySQL so that it logs every queries executed in its queries.log file. However is there any analysis tool that would import this log file and that would generate a complete report providing the number of similar queries (same DML order on the same table) per databases per minute? P.S.: we are using mytop and innotop, but it seems that they don't support such a feature. We see a lot of different queries executed against MySQL but we can't figure out, which kind of queries is the most executed, on which database. Turn on the slow query log (log_slow_queries), set long_query_time to 1 (second), and then use the mysqldumpslow tool to aggregate all of the slow queries: Thanks. However how can I trace every queries run against MySQL traced into slow-queries.log in order to use the mysqldumpslow tool? The minimum and default values of long_query_time are 1 and 10, respectively. It seems that I can't set 0 for long_query_time. Correct. But if you are willing to patch your server, you can: http://www.mysqlperformanceblog.com/2007/10/31/new-patch-for-mysql-performance/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Monitoring and analysis tool
Baron Schwartz wrote: Correct. But if you are willing to patch your server, you can: http://www.mysqlperformanceblog.com/2007/10/31/new-patch-for-mysql-performance/ This is in 5.1 as well now :) Regards Mark -- Mark Leith, Manager of Support, Americas MySQL AB, www.mysql.com Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Monitoring and analysis tool
Hi, Our MySQL server used for our development environment is slowing down, certainly because of a massive query execution by different processes. We are trying to determine which kind of query is the most executed and on which database instance(s). We are quite novice in administrating MySQL. We imagine that we can configure MySQL so that it logs every queries executed in its queries.log file. However is there any analysis tool that would import this log file and that would generate a complete report providing the number of similar queries (same DML order on the same table) per databases per minute? P.S.: we are using mytop and innotop, but it seems that they don't support such a feature. We see a lot of different queries executed against MySQL but we can't figure out, which kind of queries is the most executed, on which database. Thanks, -- Daniel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]