restoring after changing servers

[modwerx]

im moving my store to a home server from godaddy's hosting and seem to be having problems restoring the db. ive tried everything i can possibly think to try but i still cant figure out what im doing wrong. ive tried inserting the old db after deleting the tables from phpmyadmin but if it does anything its only an 1146 error.

1146 Table 'zencart.configuration' doesn't exist
in:
[select configuration_key as cfgkey, configuration_value as cfgvalue from configuration]

ive tried upgrading from the install page but when i refresh the shop home page it just gives me the same type of error as above. can anyone help with this? this is the first time ive tried to restore and old db to a fresh install and i cant seem to get it right..

[kobra]

GD is notorius for not creating a complete backup...
Wait till late at night when their traffic is less and create a backup following this tutorial
Restore is also covered

https://www.zen-cart.com/tutorials/i...hp?article=103

im moving my store to a home server

Really not a great idea if you are serious about operating a business
Broadband does have the bandwidth to effectively service the www
You were using cheap oversold hosting and now moving to an even cheaper alternative

[modwerx]

maybe i should have rephrased that.. im moving to a web server i built. im behind a router w/ firewall, running server 2003 so windows firewall is also setup to be secure, and ive got more processor speed/memory than i really need ;)

is there a way to just back up the customer db? can i just delete the tables i dont want from the sql file and leave the others from the install?

[kobra]

is there a way to just back up the customer db? can i just delete the tables i dont want from the sql file and leave the others from the install?

You can select any sub-set of tables you want - but if there is a version difference you will still need to run the zc_install upgrade DB only after inserting/importing the tables

maybe i should have rephrased that.. im moving to a web server i built. im behind a router w/ firewall, running server 2003 so windows firewall is also setup to be secure, and ive got more processor speed/memory than i really need

I was not referencing the class of equipment but the speed of your uplink...
Most broadband downloads at some rate BUT uploads at approx 10% of the download rate. And what the ISP's advertise is seldom what you actually see.
And as a web server it is the upload bandwidth you will need
Kinds like trying to pump 1,000 gallons of water through a soda straw
Good luck with this but I suggest you access from somewhere else and check your performance maybe get 3-4 of your friends to join in on a test

[modwerx]

thanks for the input and help kobra. i also plan on upgrading my service to at least a business class before i go live. my friend chad also helps me out with advice and service calls. hes been a network admin for a couple years now. good to have some one like that on my side or i may not tried this.. :)

i just got done trying the tutorial and according to phpmyadmin 275 queries were executed successfully and 99 tables show up under the db but when trying to upgrade the files(re-running zc_install) i get

1146 Table 'zencart.configuration' doesn't exist
in:
[update configuration set configuration_value='C:/shop/cache' where configuration_key = 'SESSION_WRITE_DIRECTORY']

any idea whats causing the 1146 errors? does it have anything to do with permissions? in properties its checked as a read only file but if i uncheck it and close the window and then open properties again it goes back to read only..

[modwerx]

thanks again for your help kobra but i think i figured out the problem. the DB from godaddy had been prefixed with the zen_ prefix and when i installed the shop i didnt use the prefix. it was kind of weird thought b/c i had tried to use the backup add-on from the DL section but all i got from it was something like "result code 1" and it wouldnt restore either.

SO ive got the DB restored and everything seems to work great...as long as i view it with http://localhost. when i view the shop area using my ip address to simulate someone else viewing it it shows up all crazy...



it shows up perfect when viewed with the http://localhost just not with http://(ipaddress)/shop. the home page at http://(ipaddress) works perfectly as well so im not quite sure whats going on atm.

the original shop is still online at mod-werx-com just remove the 2 "-" and add a . where you need it.

[kobra]

it shows up perfect when viewed with the http://localhost just not with http://(ipaddress)/shop. the home page at http://(ipaddress) works perfectly as well so im not quite sure whats going on atm.

What is in your configure.php files for where the shop is for http and https??
Might need to have a set for "by IP"

[modwerx]

thanks again for your responses kobra :) the lines with 'localhost' were there and the lines with 'ipaddress' i tried adding but it didnt have any effect. did i add the lines correctly?


define('HTTP_SERVER', 'http://localhost');
define('HTTPS_SERVER', 'https://localhost'); // Use secure webserver for checkout procedure?

define('HTTP_SERVER', 'http://ipaddress'); define('HTTPS_SERVER', 'https://ipaddress'); // Use secure webserver for checkout procedure?



define('HTTP_SERVER', 'http://localhost');
define('HTTPS_SERVER', 'https://localhost');
define('HTTP_CATALOG_SERVER', 'http://localhost');
define('HTTPS_CATALOG_SERVER', 'https://localhost');// Use secure webserver for catalog module and/or admin areas?


define('HTTP_SERVER', 'http://ipaddress');
define('HTTPS_SERVER', 'https://ipaddress');
define('HTTP_CATALOG_SERVER', 'http://ipaddress');
define('HTTPS_CATALOG_SERVER', 'https://ipaddress'); // Use secure webserver for catalog module and/or admin areas?

[kobra]

Might check on how to delagate a virtual host an IP

http://www.webhostingtalk.com/showthread.php?p=6149651

[modwerx]

YAY! here comes the fun part... thanks for the help again kobra. ill look into it and if it cant be fixed i may just try importing the customers instead of the whole db and starting over with everything else. (prays for miracle)

thanks again kobra!