Just a heads up, for those exporting their databases from the X-Cart DB backup tool, it is important that you've made this small modification...
In admin/db_backup.php comment out or delete this code...
Code:
if (!in_array($_table, $sql_tbl))
continue;
It will then export ALL database tables including custom ones.
Also, if you have a large database, for importing it's a good idea to use
Bigdump