Need help executing mysql stress test suite

Hi, For mysql stress test suite (mysql-stress-test.pl) to execute, it requires --stress-tests-file to be provided which contains the list of tests to be executed. As per the documentation the default name of the file is stress-test.txt and it will be located under ./mysql-test directory. But I co

Re: select ... into outfile=stdout ?

hi ronaldo i tried and failed. it seems that mysql has no option to specify a select statement. did i mis something ? re, wh walter harms schrieb: > hi ronaldo, > iadmit i was mysql (the command) fixated :) > > thx a lot, > wh > > Rolando Edwards schrieb: >> Try mysqldump !!! >> >> On this w

Re: select ... into outfile=stdout ?

hi ronaldo, iadmit i was mysql (the command) fixated :) thx a lot, wh Rolando Edwards schrieb: > Try mysqldump !!! > > On this web page, http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html > > It says the following: > > --fields-terminated-by=..., --fields-enclosed-by=..., > --fields-optio

Re: MySQL Date problem

DATE TIME ZONE SENSITIVE DATETIME NOT SENSITIVE TO TIME ZONE TIMESTAMP TIMEZONE SENSITIVE iam getting the above problem as date is timezone sensitive.i resolved it by changing the field type from date to string. YOu can use any method to fill the DATE field of mysql ."which method we use

Re: MySQL Date problem

SK wrote: 2008/10/19 Rama <[EMAIL PROTECTED]> hi, iam using java,hibernate,mysql i am storing *19-10-2008 (*of type java.sql.Date) (TIMEZONE GMT) to mysql DATE field. when i retrieve the same date from mysql to java it is being displayed as *18-10-2008 18:30:00 GMT * i could not ab

Re: MySQL Date problem

The above argument applies to only MYSQL DATE field (timezone sensitive) where as in the case DATETIME Field it does not do any conversion gets what we store (timezone insensitive) in the case of TIMESTAMP Field it gets converted between UTC and local timezone.

Re: MySQL Date problem

i figured out the root cause of the problem. 1) Java TIME ZONE is GMT --- storing DATE (2008-10-19 which is in GMT ) 2) storing the above date in GMT to mysql 3) MYSQL TIME ZONE IS GMT+05:30 4) as mysql time zone is GMT+05:30 it is viewing the date as (2008-10-19) @ GMT

Re: MySQL Date problem

2008/10/19 Rama <[EMAIL PROTECTED]> > hi, > > iam using java,hibernate,mysql > > i am storing *19-10-2008 (*of type java.sql.Date) (TIMEZONE GMT) to > mysql > DATE field. > > when i retrieve the same date from mysql to java it is being displayed as > *18-10-2008 18:30:00 GMT * > > > i could n