Reason DLE using module Sypex Dumper Lite 1.0.8 to backup, restore database
So it different from phpMyAdmin or MySQLDumper....

If you use another tool: some table will be lost (from table category)

Fix
We have some way to fix this problem

Way 1
1. Backup database via DLE Admin CP
2. In new host using your tools to restore
3. Use DLE Admin CP to restore database again

Way 2
1. Backup database via DLE Admin CP
2. Download (http://sypex.net/en/products/dumper/downloads/)

In this tool have folder /sxd/backup/

Copy file database backup to that folder

3. Use that tool to restore

Way 3
Use your tool to backup and restore database (Don't use Admin CP to backup)