Jump to content

Can't Import Mysql Backup Using Phpmyadmin


Recommended Posts

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 :)

Link to comment
Share on other sites

@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.

Link to comment
Share on other sites

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


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?

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...