Chris,
What version of MySQL are you using and what table type (InnoDB, MyISAM,
etc.)? I followed your procedure and was unable to replicate the problem
with MySQL 4.0.14 on a MyISAM table.
-Rob
-----Original Message-----
From: Chris Edwards [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 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 have. If I drop the index
and re-create it, all of the indexes show their correct cardinality. I
don't think phpMyAdmin is at fault because searching on the table before I
fix it is sluggish until afterwards. Is the a command I could run that
would re-index everything after I dump the data into the table? Or what is
going on?
thanks.
--
Chris Edwards
Web Application Developer
Outer Banks Internet, Inc.
252-441-6698
[EMAIL PROTECTED]
http://www.OuterBanksInternet.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
