in to all. This is very educational.
Dan
> -Original Message-
> From: Brian McCain [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 27, 2003 7:22 PM
> To: Dan Wright; [EMAIL PROTECTED]
> Subject: Re: Slow Inserts
>
>
> I had a very similar problem a couple weeks ago, a
Y (id)
) TYPE=MyISAM;
Incidentally - I waited a long time to post my own issue to this list and
I'm quite pleased by the responsiveness and ideas I'm getting. Thanks to all
that are consider the issues I'm having.
Dan
-Original Message-
From: Victor Pendleton [mailto:[
I've been having trouble with some large tables getting what seems to be
corrupted.
Here's the situation:
I have several tables that have 3 million to as much as 7 million records. I
have a process that I run against those tables that pulls out a record based
on specific criteria (select id,name f
There are many things "short of wiping the hard drive" that you can try.
I just had this happen and was able to find the answer quickly on
www.mysql.com
IE: http://www.mysql.com/doc/en/Resetting_permissions.html
Just read, step back, think, then try something.
You shouldn't need to rebuild ever
You're having a permissions problem.
>From the Load data infile section of the manual:
For security reasons, when reading text files located on the server, the
files must either reside in the database directory or be readable by all.
Also, to use LOAD DATA INFILE on server files, you must have the
> Hi guys,
> Hopefully have an easy question for you guys.
> Whats wrong with this query
>
>
> Select * from Tablename where drinks is not = 'pepsi';
>
> Driving me batty..
select * from CaseSensitiveTablename where drink != 'pepsi';
or
select * from CaseSensitiveTablename where drink not lik
