I imported data into a table "mytable" into a databse "mydb" with existing data.
mysqlimport -L mydb data.txt

that operation failed.
I interrupt it.

It seems that I imported data with the same indexes (duplicate entries)

I tried: delete from mytable;
that seems to fail too

What happens when you interrupt such operation: unstable state (indexes, references to other keys ...)

What can I do to repair?
Should I drop the table, create it again and fill it up with my data?
Or is there more to do than that?

Thank you for your suggestions
Laurie


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to