Forums / Templates, Stylesheets, Page Layout / Transfering servers. DNS already changed but need to back up database

Transfering servers. DNS already changed but need to back up database

Locked

Views: 2,901

Results 1 to 11 of 11
This thread is locked. New replies are disabled.
24 Aug 2006, 6:34 AM
#1
estrange avatar

estrange

New Zenner

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

Transfering servers. DNS already changed but need to back up database

I'm moving servers from Dreamhost to opensource hosting that was offered here on Zen-cart. I basically followed the steps exactly on the Wiki Help. The problem is Opensource hosting requires that I have the DNS propgated before I can create the new database. Now I need to backup my old database and I can't access my old PhpmyAdmin due to the fact that my DNS server has already changed.

mysql.lareefs.com no longer works and therefore I can't do any backups. I can't seem to access it from my Dreamhost control panel either.

Any ideas?

24 Aug 2006, 7:29 AM
#2
drbyte avatar

drbyte

Sensei

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

Re: Transfering servers. DNS already changed but need to back up database

instead of mysql.lareefs.com do any of these work:

66.228.121.252
66.33.201.141

If not, you'll need to contact dreamhost and ask them the ipaddress of your mysql server.

Or, you could use your dreamhost control panel to do a full site backup or just a mysql backup for you. That'll create a file on the server which you can download by FTP.

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

24 Aug 2006, 7:56 AM
#3
estrange avatar

estrange

New Zenner

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

Re: Transfering servers. DNS already changed but need to back up database

DrByte:

instead of mysql.lareefs.com do any of these work:

66.228.121.252
66.33.201.141

If not, you'll need to contact dreamhost and ask them the ipaddress of your mysql server.

Or, you could use your dreamhost control panel to do a full site backup or just a mysql backup for you. That'll create a file on the server which you can download by FTP.

I have a full site back up (basically downloaed all the files of my cart through ftp). Is there anyway to extract what I need to transfer servers? I can't seem to find the back up function in the dreamhost CP.

24 Aug 2006, 7:57 AM
#4
drbyte avatar

drbyte

Sensei

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

Re: Transfering servers. DNS already changed but need to back up database

Unless you had done a database backup into a file before transferring, you won't have it in the files area of your old server.

You'll have to talk to DH support.

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

24 Aug 2006, 8:47 AM
#5
estrange avatar

estrange

New Zenner

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

Re: Transfering servers. DNS already changed but need to back up database

DrByte:

Unless you had done a database backup into a file before transferring, you won't have it in the files area of your old server.

You'll have to talk to DH support.

Let's say I don't care about records on my hits, my customers and orders. I just want to keep my products, templates, images, custom sidebox, and stuff like that. Would I still need the database backup?

24 Aug 2006, 8:49 AM
#6
drbyte avatar

drbyte

Sensei

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

Re: Transfering servers. DNS already changed but need to back up database

yes - your product details are in the database

your images and template customizations are in the PHP files you downloaded

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

24 Aug 2006, 10:18 AM
#7
estrange avatar

estrange

New Zenner

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

Re: Transfering servers. DNS already changed but need to back up database

estrange:

Let's say I don't care about records on my hits, my customers and orders. I just want to keep my products, templates, images, custom sidebox, and stuff like that. Would I still need the database backup?

Worse comes to worse I can always just set the DNS back to dreamhost and then access it then right?

BTW, Opensourcehosting kicks ass! I always just thought Zen-Cart was just inherently slow. If you sign up through them Zen-Cart gets a donation and that helps them make the cart better. This thing blazes through everything!

24 Aug 2006, 10:19 AM
#8
drbyte avatar

drbyte

Sensei

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

Re: Transfering servers. DNS already changed but need to back up database

estrange:

Worse comes to worse I can always just set the DNS back to dreamhost and then access it then right? technically, yes.
What was the old DNS address? ... the NS address, that is.

estrange:

BTW, Opensourcehosting kicks ass! I always just thought Zen-Cart was just inherently slow. If you sign up through them Zen-Cart gets a donation and that helps them make the cart better. This thing blazes through everything!
That's why they're certified hosts :wink2:

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

24 Aug 2006, 10:23 AM
#9
estrange avatar

estrange

New Zenner

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

Re: Transfering servers. DNS already changed but need to back up database

DrByte:

technically, yes.
What was the old DNS address? ... the NS address, that is.

That's why they're certified hosts :wink2:

It's

ns1.dreamhost.com
ns2.dreamhost.com
ns3.dreamhost.com

Funny, when I went back to the Dreamhost CP it still shows that under my WhoIS information.

24 Aug 2006, 10:32 AM
#10
drbyte avatar

drbyte

Sensei

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

Re: Transfering servers. DNS already changed but need to back up database

According to dreamhost's nameservers, your IP is:

Name: mysql.lareefs.com
Address: 208.97.155.213

So, you could use the indicated IP address instead of "mysql.lareefs.com" as you used to do.

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

24 Aug 2006, 12:20 PM
#11
estrange avatar

estrange

New Zenner

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

Re: Transfering servers. DNS already changed but need to back up database

DrByte:

According to dreamhost's nameservers, your IP is:

Name: mysql.lareefs.com
Address: 208.97.155.213

So, you could use the indicated IP address instead of "mysql.lareefs.com" as you used to do.

Thats what I got too but it doesn't work. The www, ftp and "A" also don't work. I'll see what Dreamhost can do. I really appreciate the help though. Thanks.