No option to TRUNCATE TABLE ?

[jlig]

Maybe I have missed this.. but wondering if there is a way to just "delete" all of the data in a MySQL table before transferring?
- I only see the option to "DROP and RECREATE destination database" and "Transfer Records"
- But no option to just "update my existing Table" without DROPPING the table?

- What would be best is an option to "TRUNCATE TABLE and Transfer records" because this would a) Not delete table, b) Start AutoNum back at "1", c)transfer new records

Note: DELETE FROM <tablename> does *not* reset the auto increment counter. It will remain as it was before the delete.
TRUNCATE <tablename> *does* reset the counter to 1

Any ideas on this?
Thanks,
jlig

[chloewright]

Seems there's no way you can do this way.