HI
It looks like MySQL has left a 3GB file in WINDOWS/TEMP. The date of
last modification was nearly 2 months ago and I use MySQL on a daily
basis. Can I remove this ?
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/
I copy and paste it into my mysql client, it
is fast. I can execute the query first in mysql and then in the JDBC
client and I get the same so it is not caching. I've done a bit of
searching but found nothing - any ideas ?
Chris
On 7/22/05, Chris Faulkner <[EMAIL PROTECTED]> wrote:
AIL PROTECTED]> wrote:
> Chris Faulkner wrote:
> > HI
> >
> > I have a query like this
> >
> > select * from table where (
> > ( field1 = 'VALUE1' and field2 like 'VALUE2%' )
> > OR
> > ( field3 = 'VALUE1' and fie
HI
I have a query like this
select * from table where (
( field1 = 'VALUE1' and field2 like 'VALUE2%' )
OR
( field3 = 'VALUE1' and field2 like 'VALUE2%' )
)
I have created two composite indexes - one on field1 + field2 and one
on field3 + field2. Explain on the SQL indicates that the indexes
Export as CSV.
MySQL command line client.
Run a script with LOAD DATA INFILE.
Chris
On 5/23/05, Andrew Dixon - MSO.net <[EMAIL PROTECTED]> wrote:
> Hi Adam.
>
> I need to get all the data.
>
> Andrew
>
>
> Adam wrote:
>
> >Drew,
> >
> >That's vague. Specifically what do you want from th
Hello
I am trying to connect from host 192.168.0.8 on my home network to a
database on 192.168.0.7. When I connect as root on 192.168.0.7 itself,
I can do this
mysql> show grants for 'root'@'192.168.0.8';
++
| Grants for [EMAIL PROTECTED]
Hi
I have a table with about 20m rows. It is a MyISAM table. I do a alter
table disable keys before loading with "LOAD DATA". Re-creating the
primary key after import takes a long time. I have increased the
myISAM sort buffer to 75MB and the Key buffer is 100MB.
Is there anything else I can do t
