wow, who pissed in your cornflakes this morning?
here ya go...
One concern here is that I have some auto-increment columns
the generated INSERT statements preserve those values
Is there any true backup and restore in this situation?
yes, using mysqldump
What's the best I can do?
Or, will Mysql require a private server?
no, it won't