MySQL migrate problem

[visua]

Hey guys,

I'm moving my store to a new server, and I'm trying to migrate everything without having to spend a week on re-customizing everything in the admin, and adding all my products, etc again.

So, ive exported the SQL from the current setup and am trying to import the .sql file into php my admin, however I keep getting the following error:

QL query:

--
-- Database: `information_schema`
--
CREATE DATABASE  `information_schema` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


MySQL said: 

#1044 - Access denied for user 'the0908308241669'@'%' to database 'information_schema'

Any information on this? I searched around and found mostly probelms with the sql user, but mine seems to be correct. And if i have to change that, I have no idea where to do that inside of phpMyAdmin.

Any info would be great.

also I am on godaddy - if that makes a difference I know these big host's often have non-standard user paths, etc.

[fairestcape]

GoDaddy has an AWFUL admin console system that is a far cry from facilities like C-Panel...

Is there not a mechanism within the GoDaddy console to easily create a database, and add a database user with universal privileges?

Once you have an "Empty" database, it's generally very easy to populate it with the SQL from the original database. (IF, or course, you have the same MySQL version on GoDaddy that you had on the original server!)

[visua]

fairestcape,

It's actually from one go-daddy server to another. Maybe i should look into contacting them to see if they could just switch the actual sql databases between accounts?

[visua]

Just spoke with some nimrod of a tech guy at GoDaddy. I don't know how these guys get jobs sometimes. It boggles my mind. In fact he started talking about paying 'monthly' when i could save yearly on my accounts instead of answering my database questions. Awesome!! thanks for nothing GoDaddy!

[GDSupport]

Sorry to hear this. I'd really like to help you out. Please message the domain name to me and I will get in touch with you so we can get this worked out.

Thanks,

[DrByte]

So, ive exported the SQL from the current setup and am trying to import the .sql file into php my admin, however I keep getting the following error:

QL query:

--
-- Database: `information_schema`
--
CREATE DATABASE  `information_schema` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


MySQL said: 

#1044 - Access denied for user 'the0908308241669'@'%' to database 'information_schema'

The problem is that the method you used to create your backup was not the best choice. Now, if GoDaddy doesn't give you any other option, well, then ... the blame goes onto *them*.

The thing is, most hosts, including GD apparently, don't allow you to "CREATE DATABASE xxx ..." via a .sql import script.
(And, since the file is usually too large for most text editing applications to handle, it'd difficult to edit that line out of the file.)

That's why this FAQ article on doing backups using phpMyAdmin tells you in step 2 to select your database from the pulldown list BEFORE clicking on the Export tab, so that it doesn't automatically include the CREATE DATABASE statement in the sql export file it produces: https://www.zen-cart.com/tutorials/i...hp?article=103

Another Related FAQ on moving from one server to another: https://www.zen-cart.com/tutorials/i...hp?article=100

[Website Rob]

Open your mySQL file in a Text Editor and delete this line:

CREATE DATABASE `information_schema` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

Then use phpMyAdmin to Import and all should be well.

[DrByte]

Well ... note that the file is likely to be large, and it's quite common that many text editors can croak on the size, or corrupt the content when editing.

And, if you do edit it, don't just remove the CREATE DATABASE line ... you'll need to *also* delete the USE DATABASE statement on the next line too.