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 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 do

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: My procedure: PROCEDURE `real`.testproc_safe2_prep(IN param1 VARCHAR(255), IN param2 VARCHAR(255)) BEGIN SET @query = 'SELECT field1 FROM test_tab

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 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 stuck. I wonde

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 T

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 Sh

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.t

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 wrote: Hi guys, I wonder how to store to csv or txt file result from SELECT query? n

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 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 tab-delimited text

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: 860.674

Re: Slow MySQL Workbench startup

2011-01-09 Thread Felix E. Klee
On Sun, Jan 9, 2011 at 1:54 PM, Yves Goergen 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. -- MySQL General Mailing

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 faste