Sundar ; mysql@lists.mysql.com
Sent: Tue, August 10, 2010 5:03:44 PM
Subject: Re: Dropping ALL indexes from a database / not just a table?
auto_increment is only allowed on primary-keyed columns. I expect it
is not allowing you to drop the primary key because that column has
the auto_increment attribute. Dro
dering if it has something to do with the fact that
> dbf_UID is a primary AND auto_increment?
>
> TIA...
>
> Nunzio
>
>
>
> ____________
> From: Michael Dykman
> To: Nunzio Daveri
> Cc: Anirudh Sundar ; mysql@lists.mysql.com
> Sent: Tue,
nzio Daveri
Cc: Anirudh Sundar ; mysql@lists.mysql.com
Sent: Tue, August 10, 2010 4:10:37 PM
Subject: Re: Dropping ALL indexes from a database / not just a table?
It's not a completely solution and will need some tweaking.. You
might have to run the PRIMARY KEYS distinctly from the rest.
nzio
> ________
> From: Michael Dykman
> To: Nunzio Daveri
> Cc: Anirudh Sundar ; mysql@lists.mysql.com
> Sent: Tue, August 10, 2010 3:17:48 PM
> Subject: Re: Dropping ALL indexes from a database / not just a table?
>
> This should give you a good st
chael Dykman
To: Nunzio Daveri
Cc: Anirudh Sundar ; mysql@lists.mysql.com
Sent: Tue, August 10, 2010 3:17:48 PM
Subject: Re: Dropping ALL indexes from a database / not just a table?
This should give you a good starting point (not tested):
select distinct concat('ALTE
gt;
> Thanks again...
>
> Nunzio
>
>
>
>
>
> From: Anirudh Sundar
> To: Nunzio Daveri
> Cc: mysql@lists.mysql.com
> Sent: Tue, August 10, 2010 1:06:41 AM
> Subject: Re: Dropping ALL indexes from a database / not just a table?
Sundar
To: Nunzio Daveri
Cc: mysql@lists.mysql.com
Sent: Tue, August 10, 2010 1:06:41 AM
Subject: Re: Dropping ALL indexes from a database / not just a table?
Hello Nunzio,
Instead of Dropping a index, you can disable the indexes and get the work done
and re-enable them.
If you are ok with
At 01:06 AM 8/10/2010, you wrote:
Hello Nunzio,
Instead of Dropping a index, you can disable the indexes and get the work
done and re-enable them.
Disabling keys will NOT disable Primary or Unique keys. They will still be
active.
Mike
If you are ok with this then run the below as a shel
Hello Nunzio,
Instead of Dropping a index, you can disable the indexes and get the work
done and re-enable them.
If you are ok with this then run the below as a shell script :-
MUSER="username"
MPASS="password"
DATABASE="dbname"
for db in $DATABASE
do
echo "starting disabling indexes for datab
Hello Gurus, is there a way / script that will let me DROP ALL the indexes in a
single database? for example, lets say my database is call db_Animals, and
inside db_Animals there are 97 tables, is there a SINGLE command or a perl
script of some kind that can read all the MYI files, remove the .
10 matches
Mail list logo