(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
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.
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
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
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
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
: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
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
>
>
>
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
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
>
&
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
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
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
13 matches
Mail list logo