Zen Cart Logo
trapezoid-twopenny
Open navigation menu
Home Community Forum Plugins
Documentation
For Developers For Storeowners
Services Donate Get Started
Forums / Installing on a Linux/Unix Server / Switching servers.. db name problem

Switching servers.. db name problem

Locked
Results 1 to 20 of 43
This thread is locked. New replies are disabled.
30 Mar 2010, 12:32
#1
ersio avatar

ersio

New Zenner

Join Date:
Oct 2008
Posts:
41
Plugin Contributions:
0

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?
30 Mar 2010, 13:12
#2
website_rob avatar

website_rob

Inactive

Join Date:
Oct 2006
Posts:
4,572
Plugin Contributions:
0

Re: Switching servers.. db name problem

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.
30 Mar 2010, 13:15
#3
ersio avatar

ersio

New Zenner

Join Date:
Oct 2008
Posts:
41
Plugin Contributions:
0

Re: Switching servers.. db name problem

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
31 Mar 2010, 13:16
#5
ersio avatar

ersio

New Zenner

Join Date:
Oct 2008
Posts:
41
Plugin Contributions:
0

Re: Switching servers.. db name problem

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.
31 Mar 2010, 13:35
#6
ersio avatar

ersio

New Zenner

Join Date:
Oct 2008
Posts:
41
Plugin Contributions:
0

Re: Switching servers.. db name problem

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?
31 Mar 2010, 13:40
#7
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Posts:
10,324
Plugin Contributions:
0

Re: Switching servers.. db name 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...
31 Mar 2010, 13:45
#8
ersio avatar

ersio

New Zenner

Join Date:
Oct 2008
Posts:
41
Plugin Contributions:
0

Re: Switching servers.. db name problem

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
31 Mar 2010, 13:59
#10
ersio avatar

ersio

New Zenner

Join Date:
Oct 2008
Posts:
41
Plugin Contributions:
0

Re: Switching servers.. db name problem

I'll get into that, but right now, I need to get my godaddy hosting up...
to much downtime
31 Mar 2010, 14:05
#11
ersio avatar

ersio

New Zenner

Join Date:
Oct 2008
Posts:
41
Plugin Contributions:
0

Re: Switching servers.. db name problem

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?
31 Mar 2010, 14:23
#12
twaddle avatar

twaddle

Banned

Join Date:
Jul 2009
Posts:
478
Plugin Contributions:
0

Re: Switching servers.. db name problem

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
31 Mar 2010, 14:26
#13
ersio avatar

ersio

New Zenner

Join Date:
Oct 2008
Posts:
41
Plugin Contributions:
0

Re: Switching servers.. db name problem

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
31 Mar 2010, 14:30
#14
twaddle avatar

twaddle

Banned

Join Date:
Jul 2009
Posts:
478
Plugin Contributions:
0

Re: Switching servers.. db name problem

ersio:

so how do I fix this?

Don't save the back up file as a zip file. Save it as xxxxxxxx.sql
31 Mar 2010, 14:31
#15
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,506
Plugin Contributions:
173

Re: Switching servers.. db name problem

Evidently GoDaddy doesn't like it when you upload zipped files. So, don't.
31 Mar 2010, 14:36
#16
twaddle avatar

twaddle

Banned

Join Date:
Jul 2009
Posts:
478
Plugin Contributions:
0

Re: Switching servers.. db name problem

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:
31 Mar 2010, 17:16
#17
ersio avatar

ersio

New Zenner

Join Date:
Oct 2008
Posts:
41
Plugin Contributions:
0

Re: Switching servers.. db name problem

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 :(
31 Mar 2010, 17:32
#18
twaddle avatar

twaddle

Banned

Join Date:
Jul 2009
Posts:
478
Plugin Contributions:
0

Re: Switching servers.. db name problem

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!!!!!!!!!
31 Mar 2010, 17:51
#19
ersio avatar

ersio

New Zenner

Join Date:
Oct 2008
Posts:
41
Plugin Contributions:
0

Re: Switching servers.. db name problem

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


http://img10.imageshack.us/img10/9364/111111111tv.jpg


No Idea how this is coming up
31 Mar 2010, 18:05
#20
twaddle avatar

twaddle

Banned

Join Date:
Jul 2009
Posts:
478
Plugin Contributions:
0

Re: Switching servers.. db name problem

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


http://img10.imageshack.us/img10/9364/111111111tv.jpg


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