Re: LOAD DATA INFILE with space after quote but before comma

2013-12-18 Thread Dhaval Jaiswal
(1) yes it is an issue even i faced. for the remedy i search the {(" ,) (",)} values of " , space between " and , & replaced by ", in .csv itself. (2) The other way is, if all the values are like space between " , then you can use space and , in fields terminated by LOAD DATA LOCAL INFILE '/tmp

Re: Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query

2012-07-25 Thread Dhaval Jaiswal
SELECT * FROM test INTO OUTFILE '/home/test.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' as above give your join condition before INTO OUTFILE. On Thu, Jul 26, 2012 at 1:32 AM, Fred G wrote: > Hi-- > > I'm trying to do the following: > SELECT db.emp.emp_fname, db.emp.

Re: how to shrink ibdata1

2011-10-02 Thread Dhaval Jaiswal
K 2011-09-23 17:50 dbma_reply_groups.ibd > -rw-rw 1 mysql mysql 64K 2011-09-23 17:50 dbma_rewrite_domains.ibd > -rw-rw 1 mysql mysql 64K 2011-09-23 17:50 dbma_rewrite_senders.ibd > -rw-rw---- 1 mysql mysql 64K 2011-09-23 17:50 dbma_sender_relay.ibd > -rw-rw 1 m

Re: how to shrink ibdata1

2011-10-02 Thread Dhaval Jaiswal
ote: > > > Am 02.10.2011 22:10, schrieb Dhaval Jaiswal: > > Hi All, > > > > How to shrink the Mysql ibdata1 files. > > > > The actual size of database is only hardly 10G, but ibdata1 is showing > 73G > > full. I did some googling and found the following proc

how to shrink ibdata1

2011-10-02 Thread Dhaval Jaiswal
ibdata1 and ib_log files Start mysql Restore from dump When you start MySQL in step 5 the ibdata1 and ib-log files will be recreated. Is this the only option with mysql? Can't we update the statistics of database & reduce the file size. I am currently using 5.0.X. -- Regard

Re: Reg...My Hung MYSQL instance

2011-08-23 Thread Dhaval Jaiswal
mail & notify us > > immediately at ad...@sifycorp.com > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/mysql?unsub=eroomy...@gmail.com > > > -- Regards, Dhaval Jaiswal

Re: DBCP error

2011-06-01 Thread Dhaval Jaiswal
:1029) > > > > at > > > com.eos.gds.cache.FareQuoteDBCache.processInputQueue(FareQuoteDBCache.java:899) > > > > at > > com.eos.gds.cache.FareQuoteDBCache.access$000(FareQuoteDBCache.java:37) > > > > at > > com.eos.gds.cache.FareQuoteDBCache$1.run(FareQuoteDBCache.java:103) > > > > at java.lang.Thread.run(Thread.java:619) > > > > Caused by: java.net.SocketException: Socket closed > > > > at java.net.SocketInputStream.socketRead0(Native Method) > > > > at java.net.SocketInputStream.read(SocketInputStream.java:129) > > > > at > > > com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113) > > > > at > > > com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160) > > > > at > > > com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188) > > > > at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2329) > > > > at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2774) > > > > > > > > > > -- > > Regards, > > Dhaval Jaiswal > > > > > > > > > > -- > > Regards, > > Dhaval Jaiswal > -- Regards, Dhaval Jaiswal

DBCP error

2011-05-12 Thread Dhaval Jaiswal
Regards, Dhaval On Wed, May 11, 2011 at 12:44 PM, Dhaval Jaiswal wrote: > > Yeah, we have some of the SQL statements which are running more than 1 > minutes. However, for small queries it's also throwing errors DBCP. > > > -- > Regards, > Dhaval > > >

Re: DBCP error

2011-05-11 Thread Dhaval Jaiswal
gt; Subject: Re: Fwd: DBCP error > > From: nw...@plus.net > > To: dhaval.jais...@via.com > > CC: mysql@lists.mysql.com; shrinivas.devarko...@via.com > > Date: Fri, 6 May 2011 11:35:30 +0100 > > > > > On Fri, 2011-05-06 at 11:12 +0100, Dhaval Jaiswal wrote: > &g

Re: Fwd: DBCP error

2011-05-11 Thread Dhaval Jaiswal
interactive/wait_timeout = 120Seconds max_connection = 1500 still we are getting errors. -- Regards, Dhaval On Fri, May 6, 2011 at 4:05 PM, Nigel Wood wrote: > On Fri, 2011-05-06 at 11:12 +0100, Dhaval Jaiswal wrote: > > Caused by: java.net.SocketException: Socket closed > &

Fwd: DBCP error

2011-05-06 Thread Dhaval Jaiswal
yingStreamIfNecessary(ReadAheadInputStream.java:160) at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188) at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2329) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2774) -- Regards, Dhaval Jaiswal -- Regards, Dhaval Jaiswal

Re: Newbie question: Association table and Foreign Key

2011-03-01 Thread Dhaval Jaiswal
Just curious as it is not mentioned. Can Category ID also have multiple event id ? -- Cheers Dhaval Jaiswal On 01/03/2011 5:53 PM, Wagyu Beef wrote: Hey guys, Am a newbie here and need a little help. Part of the database consists of two tables "events" and "categories&q

Re: Tool for shifting tables from Mysql to Postgresql

2011-03-01 Thread Dhaval Jaiswal
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