As I read the documentation, ALTER TABLE my_table DISABLE KEYS only works on MyIsam tables. When I run the command against an InnoDB database, however, I get no indication of a problem. I get the usual Query OK message. So, can I temporarily disable keys on an InnoDB database (say while doing a large load)?
Second, I set up MySQL using all the defaults. So, the data directory is on C: and in the mysql\data subdir (Win2K platform). Things are a little tight on my C drive so the boss kindly bought me a 2nd drive which is now my D drive. Now, can I move my database from c: to d: just by copying the subdir and changing the path in my.cnf? (I forget what the my.cnf option is, but I'll find it.) Somehow, that sounds too easy... Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
