Transferring database from one x10 account to another

[ray.ciara151]

I am trying to transfer a wordpress website and database from my account jsr06b to another x10 account auroram, I have created a website for them but need it to go to their server now. I can't seem to stop getting a 1044 error saying auroram@10...doesn't have permission to load this database when I'm trying to upload the database from jsr06b into her account.

Can you help?

[descalzo]

When you downloaded the database, did you export it as a database (ie with CREATE DATABASE instuction) or as a collection of tables?

You should export the tables. Not the database. My understanding is that this configuration of PHPMyAdmin does not allow you to create databases.
Use MySQL Databases in cPanel to create the new database and user.
Import the table and data into the new database.

[ray.ciara151]

thank you so much for your help, worked like a charm.

-thread closed-