Exporting/Importing to new database without moving files
I've been scratching my head for a while over this, and the other posts don't seem to hold an answer for me...
I'm trying to duplicate the database and use the new database for my site.
I've recently upgraded 1and1 hosting to managed servers, and as part of the upgrade I have to create new databases for each site again. 1and1 take care of the files on the server and so their location never change, it's literally export old database, setup new database and import...right?
Only I export using phpmyadmin default settings (no compression), import using default settings and update the config.php file... BONK.
I've seen people suggest deleting the .ini files in the cache folder, tried that even though they don't seem to contain any database reference. Any suggestions?