Problem restoring MySQL that I moved from another server

I had to move all my websites from 1 server to another, so I went in and quickly did a MySQL backup through phpmyadmin.

I"ve been trying to restore the database for a few days but I keep getting this error message:

Error

SQL query:

--
-- Database: `danny17_grfxmem`
--
CREATE DATABASE `danny17_grfxmem` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

MySQL said: Documentation
#1044 - Access denied for user 'xziler8r'@'localhost' to database 'danny17_grfxmem'


danny17 used to be the username for the host on the other server, and xziler8r is on the new one. I was thinking about going into the backup file and renaming danny17 to xziler8r, but doing it through notepad it would crap out on me and move really slow. the sql file is about 3.4MB big so i dont think its that huge.

Any ideas?

 

Remove CREATE DATABASE and USE danny17_grfxmem commands from sql file. Then create the database manually and import the data into new database.

 

Here are the detailed instructions to perform this action.

1. Delete this line from your sql file.
CREATE DATABASE `danny17_grfxmem` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

2. And make sure you have not SQL command
USE `danny17_grfxmem`;
or
USE danny17_grfxmem;
in the sql file. If there is then delete this line too and save the file.


3. Create a new database with the name xziler8r_grfxmem

4. Use phpmyadmin to import the data from updated file to database xziler8r_grfxmem.

 

You must be doing some mistake.
Well,if you want,i can do it for you..
Pm me now.

 

When I create the new database, what commands do I type in the sql box to import the database?

I removed all the lines that you mentioned, create database, default character set and use (username) and saved the file again.

I tried importing it but it sat there for 30 min and didnt do anything

 

Nevermind, got it working

 

What was the issue?

 

I think that the best way to import SQL database is by using Bigdump it's really very easy to use and do the job needed effeciently
you can google it

 

I deleted the lines:

1. Delete this line from your sql file.
CREATE DATABASE `danny17_grfxmem` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

2. And make sure you have not SQL command
USE `danny17_grfxmem`;
or
USE danny17_grfxmem;
in the sql file. If there is then delete this line too and save the file

and then went through the backup sql file and removed the tables/database that I didnt need, and did that manually.

It was really simple actually heh

 

Big Dump is such a big help for transferring databases more than 50MB big. This is the same tool recommended by someone in AdminZone and SMF Forum Help.