I have 2 MySQL databases 1_029f4ab_0
and 1_029f4ab_1
I want to copy the contents of 1_029f4ab_0
into 1_029f4ab_1
The structure of both databases are identical
I EXPORTED a WordPress database 1_029f4ab_0
and file was saved as localhost.sql
to my laptop
In phpMyAdmin, I selected the second WordPress database 1_029f4ab_1
and chose "admin" in order to IMPORT the 1_029f4ab_0
database.
MySQL said: Documentation
#1044 - Access denied for user '1_029f4ab_1'@'localhost' to database '1_029f4ab_0'
Does your SQL file contain
CREATE DATABASE 1_029f4ab_0;
or
USE 1_029f4ab_0;
If so, delete those lines and re-run it. If you export the database from the top level in PHPmyadmin then sometimes it can add that in