Switching servers.. db name problem

So I switched or am trying to switch from yahoo servers to google and when I export and run the script I run into this problem"

SQL query:

--
-- Database: mysql

CREATE DATABASE mysql DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

MySQL said:

#1044 - Access denied for user 'ersio@'%' to database 'mysql'

How Do I get around this? I understnad it's because I don't have the db name "mysql" but is there a way to get it to that?

First you create a database.

Then you create a database user.

Finally, you allow the database user access to the database.

All the above should be doable within your Hosting Control Panel. If not or you have problems then contacting your Hoster is the fastest and best way to resolve any problems.

To my understanding, each db name had to be unique for google...

So when I did yahoo, I named the db mysql and it has all my setup files etc on them...

so i don't know how to transfer over correctly if the db name isnt the same

You missed steps 2 and 3 as explained in this FAQ: https://www.zen-cart.com/tutorials/index.php?article=103

Now I'm getting this

You attempted to load file with unsupported compression (application/zip). Either support for it is not implemented or disabled by your configuration.

On a side note, I'm swtiching from yahoo to godaddy servers

and well my db names are store and mysql and I can't have those on godaddy so I'm not sure if thats the problem?

ersio:

On a side note, I'm swtiching from yahoo to godaddy servers

You're going from BAD (yahoo) to WORSE (godaddy).

GoDaddy is a completely inappropriate host for eCommerce...

What would be a good hosting site? I'm just trying to get to a more stable server that is easy to navigate for me...

I left yahoo because you cant use .htaccess

I'm very uneducated in this... my business is making food lol

http://www.zen-cart.com/index.php?main_page=infopages&pages_id=10

I'll get into that, but right now, I need to get my godaddy hosting up...
to much downtime

ersio:

Now I'm getting this

You attempted to load file with unsupported compression (application/zip). Either support for it is not implemented or disabled by your configuration.

so how do I fix this?

DrByte:

You missed steps 2 and 3 as explained in this FAQ: https://www.zen-cart.com/tutorials/index.php?article=103
I don't know if I learnt a lazy way of copying databases, but that article saved my sanity a couple of days ago trying to copy from GoDaddy to another server. I've done countless transfers before and never had a problem, as soon as GoDaddy get involved the whole thing goes to cack

Follow the article to the letter (slowly and step by step) and you will have no problems is my guess

ersio:

Now I'm getting this

You attempted to load file with unsupported compression (application/zip). Either support for it is not implemented or disabled by your configuration.

Twaddle:

I don't know if I learnt a lazy way of copying databases, but that article saved my sanity a couple of days ago trying to copy from GoDaddy to another server. I've done countless transfers before and never had a problem, as soon as GoDaddy get involved the whole thing goes to cack

Follow the article to the letter (slowly and step by step) and you will have no problems is my guess

Thats what I did with that link and bam, had that error lol

ersio:

so how do I fix this?
Don't save the back up file as a zip file. Save it as xxxxxxxx.sql

Evidently GoDaddy doesn't like it when you upload zipped files. So, don't.

Send me > DrByte:

Evidently GoDaddy doesn't like it when you upload zipped files. So, don't.
I'm soooooooooooooooo trying hard not to swear here as I'm currently transferring three Zen Carts FROM GoDaddy for somebody.

Evidently GoDaddy don't like ######## that their customers do from what I have seen!!!!!!!!

Oh, one more thing to the OP, before he/she wastes his/her time in doing this, most likely your email address won't work and most likely email confirmations of new users, confirmation of orders etc etc won't get sent.

I did find a work around for one site, but it didn't work for all

I'd spend your time finding new hosting and have a couple of days break. Send me a PM and I can recommend who I use, or there's one link above from Dr Byte to Zen Cart hosted stuff. Damm, I'm even tempted to offer to install it all for you but I don't know if that's allowed practice on here :lamo:

long story short..

bluehost is easier to navigate then godaddy

I went ahead with bluehost, I have godaddy pointing to bluehost right now, and I have to wait 60 days for domain transfer :(

ersio:

long story short..

bluehost is easier to navigate then godaddy

I went ahead with bluehost, I have godaddy pointing to bluehost right now, and I have to wait 60 days for domain transfer :(
60 days??????

Bo11ocks!!!!!

Do you have all your log in details for registrar etc etc? ie where you bought the domain?

If you have all that, give me the FTP details, control panel etc I'll effing transfer this myself to my server and give you hosting for a while til you get it sorted.

I don't give a hoot if I don't know you, this is ridiculous and I hate seeing these morons take advantage of people like you!!!!!!!!!

I got the hosting set up, I have set up the mysql in bluehost and have transfered all the files yet i'm stuck here and have no idea while...

No Idea how this is coming up

ersio:

I got the hosting set up, I have set up the mysql in bluehost and have transfered all the files yet i'm stuck here and have no idea while...

No Idea how this is coming up
Did you or they change the DNS?

Most say up to 24 hours, other like GoDaddy say 72hours.... in reality it's often only 3... though it then has to propgate across the rest of the world