TRUNCATE PARTITION syntax allows for fast truncation of a ... and is the author of the MySQL Administrator's Bible and co-hosts OurSQL: The MySQL Database Community Podcast. Cabral is a pioneer member ...

In general truncate and reload is the easiest option - for the reason that you don't have to worry about what's changed and any back door updates to the source database will be reflected in the ...