If this is your first visit, check our documentation. To post, register or login.
Forums / Upgrading from 1.2 to 1.3.x / Backing up database for a host switch

Backing up database for a host switch

Locked

Started by mommydesigns on 27 Aug 2006, 2:06 AM · Views: 5,593

Results 1 to 15 of 15
This thread is locked. New replies are disabled.
27 Aug 2006, 2:06 AM
#1
mommydesigns avatar

mommydesigns

Zen Follower

Join Date:
Jul 2006
Posts:
135
Plugin Contributions:
0

Backing up database for a host switch

I have a new client who needs to move their Zen from old host to new host (you'll see why in a moment...).

The old host uses Plesk with very limited capabilities - the client has no access to their database. The host installed Zen for them a while back and now this client wants to move to a host using CPanel with full control over her own files with phpMyAdmin.

She has asked me to help as she has been trying to contact this host for over 2 weeks asking for a back up or access to HER data and she can't get it. We want to upgrade the Zen to include the new security patches and add the QB module but I won't proceed to do the installs for her without a DB backup.

Is there anyway to download her database using another tool?? Any thoughts or suggestions??

Thank you!

27 Aug 2006, 2:56 AM
#2
merlinpa1969 avatar

merlinpa1969

Totally Zenned

Join Date:
Mar 2004
Posts:
13,031
Plugin Contributions:
4

Re: Backing up database for a host switch

you could use add and use the db backup module

Zen cart PCI compliant Hosting

27 Aug 2006, 3:41 AM
#3
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: Backing up database for a host switch

You could also install a copy of phpMyAdmin directly to her webspace and use that to do the backup.

You could also grab a windows tool like SQLyog and use it to connect to the database and "export db to batch scripts" ... effectively making a backup SQL file from the database.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

2 Sep 2006, 9:18 PM
#4
mommydesigns avatar

mommydesigns

Zen Follower

Join Date:
Jul 2006
Posts:
135
Plugin Contributions:
0

Re: Backing up database for a host switch

Thank you for your help guys! I got that file to install without a hitch and I've got the DB finally.

Now I'm trying to FTP the Zenfiles from her old host to my pc to upload to the new server.

Other than this one folder (/wholesale) where all the Zen files are, it downloaded as expected without a hitch. But the Zen files are all blank. I've attached a screen grab... I've even tried using 2 different FTP programs (this is from FileZilla).

I've also tried downloading in Binary... in Auto... in Ascii mode. Nothing seems to make a difference. The files aren't blank because the site is live.

Help please!
Jennie

2 Sep 2006, 9:23 PM
#5
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: Backing up database for a host switch

Perhaps the username you're logging in with doesn't have rights to read these files and thus your download is getting 0 bytes.

Failing that, you probably need to talk to the host's tech support ... tell them you're doing a backup and all the files are ending up as 0 bytes. Maybe they have an idea. Maybe they will just zip it "for" you and let you download the zip ... which might be 0 bytes when you get it :dontgetit

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

2 Sep 2006, 9:52 PM
#6
vfcoup70 avatar

vfcoup70

New Zenner

Join Date:
Jul 2006
Posts:
17
Plugin Contributions:
0

Re: Backing up database for a host switch

You may have exceeded your quota.

DrByte:

Perhaps the username you're logging in with doesn't have rights to read these files and thus your download is getting 0 bytes.

Failing that, you probably need to talk to the host's tech support ... tell them you're doing a backup and all the files are ending up as 0 bytes. Maybe they have an idea. Maybe they will just zip it "for" you and let you download the zip ... which might be 0 bytes when you get it :dontgetit

2 Sep 2006, 9:58 PM
#7
mommydesigns avatar

mommydesigns

Zen Follower

Join Date:
Jul 2006
Posts:
135
Plugin Contributions:
0

Re: Backing up database for a host switch

vfcoup70:

You may have exceeded your quota.

This is the error I get but when I looked, I should have plenty of disk space. So verrry odd.

This also goes back to the original post in that we are not getting response from the original host (hence she's switching to my hosting).

I know the company she uses is a hosting reseller... I wonder if there's any way to figure out who he buys from and maybe their tech support can help us?

We want to upgrade the Zen to have the new security patch and we can't because of all of this.

2 Sep 2006, 11:19 PM
#8
merlinpa1969 avatar

merlinpa1969

Totally Zenned

Join Date:
Mar 2004
Posts:
13,031
Plugin Contributions:
4

Re: Backing up database for a host switch

I am going to make a long shot suggestion,
You have the DB.
you have a NEW distro
I would just install a brand new version, then update the database to current on the new server,

your going to have to redo the template anyway

Just a thought

Zen cart PCI compliant Hosting

2 Sep 2006, 11:36 PM
#9
mommydesigns avatar

mommydesigns

Zen Follower

Join Date:
Jul 2006
Posts:
135
Plugin Contributions:
0

Re: Backing up database for a host switch

Why would I have to redo the template Merlin? Can't I just reupload the Zen files in the overwrite folders?

2 Sep 2006, 11:42 PM
#10
merlinpa1969 avatar

merlinpa1969

Totally Zenned

Join Date:
Mar 2004
Posts:
13,031
Plugin Contributions:
4

Re: Backing up database for a host switch

forgive me,
I am assuming ( I know, dangerous ) that you are upgrading a 1.2 version to 1.3.0.2

the 1.2 templates need work to display properly on 1.3 and since the design structure os 1.3 is now div based its usually faster to redo the layout than try to fix the old one

Zen cart PCI compliant Hosting

4 Mar 2007, 10:02 PM
#11
craftzombie avatar

craftzombie

Zen Follower

Join Date:
Jul 2006
Posts:
494
Plugin Contributions:
0

Re: Backing up database for a host switch

Just curious if anyone knows how long it should take to switch from one host to another? I went with one of the hosts from the hosting link above who advertised moving an existing zen cart for no charge. Its been 8 days and nothing. I'm still on yucky godaddy. Is this normal? Or should I be yelling and screaming for a refund?

5 Mar 2007, 4:05 AM
#12
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Backing up database for a host switch

I would contact them and see if all that is needed is you to change the name server ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

11 Mar 2007, 8:28 PM
#13
craftzombie avatar

craftzombie

Zen Follower

Join Date:
Jul 2006
Posts:
494
Plugin Contributions:
0

Re: Backing up database for a host switch

Just replying back to let anyone know who may be searching the boards....

This was not a matter of changing the nameservers. I signed up for hosting with a "Zen Certified Host" on Feb 24th. It is now March 11th and my site still has not been moved. A week ago I emailed them and asked them to cancel my new hosting account. I received this reply:

"If I can get your site transfered would you be willing to stay. I can work
on it today and have it done by tomorrow. All I need is your current Go daddy information FTP and to the domain control panel. Also if you will stay with us I will give you 1 month free service."

Stupid me said yes and a week later, still nothing. I don't know who decides to make these people "Zen Certified", but if I were Zen Cart I would never allow my name to be associated with these people.

11 Mar 2007, 8:53 PM
#14
merlinpa1969 avatar

merlinpa1969

Totally Zenned

Join Date:
Mar 2004
Posts:
13,031
Plugin Contributions:
4

Re: Backing up database for a host switch

I know it usually takes longer for DNS to propogate than it takes for us to move a site.

there are a few exceptions but those are few and far between

Zen cart PCI compliant Hosting

11 Mar 2007, 8:59 PM
#15
craftzombie avatar

craftzombie

Zen Follower

Join Date:
Jul 2006
Posts:
494
Plugin Contributions:
0

Re: Backing up database for a host switch

I never did receive any explanation for why it was taking so long. I'm sure if it was something beyond their control, they would've explained it to me. So Merlin, I just placed my order. Are you ready to deal with me?!?!?!? :wink2: