On Wed, Feb 28, 2007 at 02:07:34PM -0500, Hans C. Kaspersetz wrote:
>
> >ALTER TABLE <tablename> DISABLE KEYS;
> >before import and
> >ALTER TABLE <tablename> ENABLE KEYS;
> >after import.
> >
> I am going to look at using DISABLE/ENABLE instead of dropping and adding.
The manual indicates that's for MyISAM tables. You said you're using
InnoDB.
--Dan
--
T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y
data intensive web and database programming
http://www.AnalysisAndSolutions.com/
4015 7th Ave #4, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
