Slow MySQL Workbench startup

2011-01-09 Thread Yves Goergen
Hello, Why does it take ages for MySQL Workbench to startup? When I start it (5.2.31 CE) on Windows (XP), the splash screen sits there around 15-30 seconds until the main window appears. There's moderate to high CPU usage in this time and the hard disk is active. I believe this has been much

Re: Slow MySQL Workbench startup

2011-01-09 Thread Felix E. Klee
On Sun, Jan 9, 2011 at 1:54 PM, Yves Goergen nospam.l...@unclassified.de wrote: Why does it take ages for MySQL Workbench to startup? I rarely use MySQL Workbench. But I remember that reducing the maximum number of items in the undo history greatly improves speed, though maybe not startup time.

RE: export result from select statement

2011-01-09 Thread Jerry Schwartz
The technique I've settled on is this: mysql blah blah blah the_select_query.sql the_output_i_want.txt That gives you a tab-delimited text file with column headings. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX:

Re: export result from select statement

2011-01-09 Thread Michael Dykman
I second Jerry's recommendation. It always works like a charm for me. - michael dykman On Sun, Jan 9, 2011 at 2:44 PM, Jerry Schwartz je...@gii.co.jp wrote: The technique I've settled on is this: mysql blah blah blah the_select_query.sql the_output_i_want.txt That gives you a

Re: export result from select statement

2011-01-09 Thread LAMP
Eric Bergen wrote: select into outfile is the correct way. What do you mean by doesn't work? Does it give you an error? It was an issue with permissions :-) Thanks On Sat, Jan 8, 2011 at 3:04 PM, LAMP l...@afan.net wrote: Hi guys, I wonder how to store to csv or txt file result from

Re: export result from select statement

2011-01-09 Thread LAMP
maybe it's clear to other but it's pretty unclear. #mysql -username -p select * from table_name where id=123 '/home/me/test/test.txt' actually doesn't work?!? Jerry Schwartz wrote: The technique I've settled on is this: mysql blah blah blah the_select_query.sql the_output_i_want.txt

Reading .MYD file of Mysql Tables

2011-01-09 Thread Adarsh Sharma
Dear all, I am facing a issue which should be resolved by editing .MYD file of a Table. I know there are 3 files foe a MyISAM table in Mysql but i want to read and edit some changes in .MYD file. If it is possible , Can anyone PLease tell me the way to do this. Thanks Regards Adarsh

Re: Reading .MYD file of Mysql Tables

2011-01-09 Thread Reindl Harald
Why in the world will you manually change a binary file form a db-server instead using sql-statements? I would mean this is russian roulette with no winning chance Am 10.01.2011 05:14, schrieb Adarsh Sharma: Dear all, I am facing a issue which should be resolved by editing .MYD file of a

Re: Help needed with what appears to be a corrupted innodb db

2011-01-09 Thread Ananda Kumar
Pito, can u show us the innodb parameters in the my.cnf file. regards anandkl On Sat, Jan 8, 2011 at 10:31 PM, Pito Salas r...@salas.com wrote: I am very new to trying to solve a problem like this and have searched and searched the web for a useful troubleshooting guide but I am honestly

bug (or feature?) with mysqli_prepare

2011-01-09 Thread Артем Лапковский
I have a problem with mysqli_prepare function, it doesn't work properly calling a stored procedure which contains prepare itself. PHP example code: ? $db = mysqli_connect(localhost,user,password,real); $stmt = mysqli_prepare($db, call testproc_safe2_prep(?,?)); mysqli_stmt_bind_param($stmt,'ss',

Re: export result from select statement

2011-01-09 Thread Yogesh Kore
#mysql -username -p -e select * from table_name where id=123 '/home/me/test/test.txt' On Mon, Jan 10, 2011 at 8:15 AM, LAMP l...@afan.net wrote: maybe it's clear to other but it's pretty unclear. #mysql -username -p select * from table_name where id=123 '/home/me/test/test.txt' actually