I might add that its a known fact that using phpmyadmin to export your forum database will sometimes cause you to have an incomplete backup of your forum especially if your forum is really large and has a large database. Your browser will time out when using phpmyadmin and get an incomplete backup. The best way to get a complete backup of your forum is to use either MySQLDumper or use the CPanel built in option. I have a tutorial on the cpanel option here:
http://www.skinsnstyles.com/xenforo/...via-cpanel.26/ Its remarkably easy to use Cpanel for the complete backup if your host has allowed this function. if not you can usually get them to turn it on for you. To restore the database from the Cpanel backup you can use BigDump usually.