Try this Take dump of table using mysqldump utility
eg : mysqldump <db name> <tablename> --quick --allow-keywords --no-create-info > <dumpfilename> Then truncate table data eg: mysql>truncate table <tablename>; create primary or unique keys what ever you want on table Then restore the data from dump file with the following options mysql <databasename> --force < <dumpfilename> Thanks Anil DBA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]