Truncating a table?

[abenoking]

I ran the import a couple of months ago and did some extensive testing and permissions assignments. I am ready to do the final conversion, but selecting 'redo' for the posts module is taking *forever* as there are well over 1 million posts.

Can I just truncate this table to speed this process up?

If so what is the SQL query I should use to do this? Also do I need to reset the auto increment?

[Steve Machol]

No, I would not recommend this since the post table has data that is used in other tables and they all need to be updated together.

[abenoking]

Is there a faster way of doing this? Or at the very least, a way to monitor the progress?

If the redo gets interrupted, does it pick up from where it left off, or does it have to start all over again?

[Steve Machol]

No to both questions, at least as far as I know. As long as you have not finalized the import you should be able to rerun that if needed.

[Jerry]

If its a fresh import drop the database and restore with the backup you took just before doing the import.