I have a Vbulletin forum that I would like to migrate to another platform. For that I need to do all sorts of testing on my local development machine. I tried importing a mysqldump produced by both the VB admin section, and the host's cpanel backup tool.
When I try to import the dump to a local database using this command
mysql -u username -p database < dbdump.sql
I keep getting all sorts of error (such as duplicate entries etc)
Is there a way to just dump and restore a db on a binary level? I'd like to just make a raw duplicate of the db as is without getting Mysql to evaluate every line of code