I just noticed that mysqldump -d outputs
/*!40000 ALTER TABLE equity_ind1 DISABLE KEYS */; at the end of the dump of the table def... If I understand this correctly... this will be executed by any version of mysql version 4 and up... That would be fine, except that since it is not dumping data, if you use this verbatim, there is no ENABLE KEYS at the bottom, like when you dump the table with the data. Is that right? Or does the disable keys only work for the life of the connection or something like that? -- ___ __ __ __ _ _ ____ _ _ ____ ____ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__) ) ( )__) )( (___/(______)(__)(__)\/ (____)()(_)\_)(____) (__) I am a mental tourist. My mind wanders. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
