Can't Import Mysql Backup Using Phpmyadmin

[aloz1]

Hello all I'm moving accross from a different free host and have made a backup of the database off of that host. I used phpmyadmin to do an export on the other host and now that I have moved over to you guys as a host, I am having problems importing the database. I am getting an access denied error that keeps popping up, and the username that it keeps saying is my default username. Just in case it is helpful in any way, I am on the stevie server. Thanks everyone

[anush]

i think there is some problem with apps on Steve.

 

guess it will be resolved soon

[aloz1]

ok, guess i'll have to wait then.

Thanks for the quick reply by the way

[bdistler]

I am on server Stevie

 

just did a import with phpMyAdmin

 

no errors

[anush]

@aloz1 i think the problem is corrected by admins or @bdistler is not affected by that error only a few accounts were affected.

 

try now

 

if still problem exists tell your problem.

[aloz1]

I'm still having the problem. Here is the error message:

 

Error
SQL query:
--
-- Database: `darkskul_Unitfication`
--
CREATE DATABASE  `darkskul_Unitfication` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

MySQL said:
#1044 - Access denied for user 'aloz1'@'localhost' to database 'darkskul_Unitfication'

 

I think I know how to solve it, but I need to change the databases prefix. Anyone know how to do that?

[aloz1]

Ok, I got around it by exporting the tables from the old DB and then importing them into another DB that I make using the MySQL tool on cpanel.

Thank you everyone who has helped me

[anush]

you are always welcome.

[bdistler]

If your SQL had something like "CREATE DATABASE" phpMyAdmin will throw a error

you can not 'make' a database with phpMyAdmin (set that way by host)

 

you need to make a database with user(s) in cPanel first

 

SQL file is a text type - take a look inside - look for something like "CREATE DATABASE" near

the top

[aloz1]

Thanks bdistler, I'll remember that fro next time.It's fixed now anyway and I've got almost everything running smoothly.

And thanks to everyone else again.