Switching servers.. db name problem

[ersio]

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?

[Website Rob]

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.

[ersio]

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

[DrByte]

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

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

[ersio]

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?

[schoolboy]

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

[ersio]

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

[DrByte]

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

[ersio]

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