I have a copy of Q2A running on localhost while I make changes to the theme and so on. However, if I export the live site and import into localhost I always get errors with key constraints.
I think it should work fine if I delete/truncate the tables in the correct order, with either qa_posts or qa_users last. What would be the correct order, and is there a simple way to backup the database? Currently I'm using phpMyAdmin.
EDIT: also, I am unable to truncate or delete the qa_posts table at all, even after all the others are truncated. I get this message:
#1451 - Cannot delete or update a parent row: a foreign key constraint fails (`pokemondb`.`qa_posts`, CONSTRAINT `qa_posts_ibfk_2` FOREIGN KEY (`parentid`) REFERENCES `qa_posts` (`postid`))