MySQL import database fails

Question

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

1) I EXPORTED a wordpress database 1_029f4ab_0 and file was saved as "localhost.sql" to my laptop

2) In myphpadmin, 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'

What am I doing wrong?

Answer 1

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