I'm moving from shared hosting to a virtual private server and need to restore my site from the WordPress Backup to Dropbox backup. I know my way around cPanel, phpMyAdmin and other tools enough to be dangerous, but could use a hand with restoring the database.
In my WP to Dropbox backup I see two .sql files:
When I create a new database on my new server, and attempt to import "user_db-backup-core.sql" I get an error "#1044 - Access denied for user 'user'@'localhost' to database 'user_db'"
On the new server, the database name that I want my backup to overwrite is different, the user is also different.
I'm assuming that the general process is to overwrite a blank new database with the backup "user_db-backup-core.sql" first, then "user_db-backup-plugins.sql" next.