RE: preserving indexes

2003-08-14 Thread Rob A. Brahier
, August 06, 2003 4:55 PM To: MySQL List Subject: preserving indexes Hi Every night. I dump the schema of a table, drop it, create the table, and load it up with data. I'm using phpMyAdmin for the most part. I notice that the index cardinality shows up as None in phpMyAdmin for each index I

preserving indexes

2003-08-11 Thread Chris Edwards
Hi Every night. I dump the schema of a table, drop it, create the table, and load it up with data. I'm using phpMyAdmin for the most part. I notice that the index cardinality shows up as None in phpMyAdmin for each index I have. If I drop the index and re-create it, all of the indexes show thei