I usually build Wordpress sites on a server with a different domain than the final destination.
I then export the db in phpMyAdmin, replace the site url, and import into the phpMyAdmin of the final server and domain.
Usually no problem, done it xx times.
Now suddenly I am running into errors either of
"Access denied for user 'xxxxxx'@'localhost'
(that is on the destination server)
on the original server where I want to duplicate the db
#1007 - Can't create database 'xxxxx_yyyyy'; database exists
Regarding the original server with the #1007 error:
I see in the sql dump in line 19 and below:
-- Database: `xxxxx_yyyyy`
CREATE DATABASE `xxxxx_yyyyy` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
I tried replacing that with the name of the empty database in which I want to import, but get the same error.
Hope this makes sense to someone out there.
Please consider in your suggestions that I do not use command-line tools.