transfer site to a new server

[sp_kenny]

I have been reading the forums for an answer to this and so far have none. I need to transfer my site and shopping cart to a new host. What files need to be changed in order to do this. I did not build the site it was done for me and the person doing it really screwed us over. It was a legal battle to get ownership of the site back and now I need to get it off of his server . I have access to his server temporarily so I need to act quickly. I tried just transfering the files ( knowing it would not work ) and get a database error. Any assistance greatly appreciated to keep from redoing a 1200 item site.

 

Thanks

[Guest]

Modify the configure.php files to reflect the new host details. There are 2 configure.php files. One in the catalog\includes the other in catalog\admin\includes

 

Finally do a text scan on the entire source tree for references to the old host name just in case.

[sp_kenny]

I have check all config files and found no references to any servers. Please advise. I am using PHP Designer.

 

Shawn

[sp_kenny]

Nix that I was looking in configuration not configure . I am trying it now.

 

Will let you you know and keep fingers crossed.

 

Shawn

[sp_kenny]

ok the site opens but when I try to access the admin this is what I get.

 

Warning: mysql_connect(): Access denied for user: '*******_osc1@localhost' (Using password: YES) in /home/*****/public_html/newcart/includes/functions/database.php on line 19

Unable to connect to database server!

 

 

Shawn

 

and again thanks for all teh help

[altDev]

So you transfered the files but did you transfer the database? If not, that is your error, you will need to create a new database on the new host and keep the login info to input in the config file.

[sp_kenny]

OK I thought that I had to get to the cpanel to transfer the database? If not please tell me how to transfer the database. Man you guys are great, I was really intimidated by this but thanks o your help so far , so good.

 

Shawn

[Guest]

Got an idea - Go into Admin and do a backup in the database, it's in that last category when you look at the left-panel menu.

 

Then copy the entire site. When you get to the new one, reinstall/Setup in the install dir, then goto admin again and tell it to grab that backup.

[sp_kenny]

Well that is the problem I cannot get to admin to upload the database. I get that error when I try to go to admin. I am going to try something stupid and see what happens. I will let you know if it works but please keep the ideas coming.

[M-Pro]

To move all of the database, assuming the current site is hosted by a hosting company and you are moving it to another hosting company, most hosting companies provide a control panel (which is nothing to do with osCommerce) you need access to this, here they'll normally provide you with access to a database management tool such as MySQLAdmin.

 

From here export a dump of the whole database. Ensure that the 'Structure' and 'Drop Table' and 'Data' tick boxes are selected and save the resultant sql text file to your PC.

 

Then from control panel of the destination hosting company, assuming you've already created a standard osCommerce database which you are happy to DELETE, then use their MySQLADMIN to run the SQL text file from your PC, which will drop = DELETE your existing 'empty'/default-demo-data osC database and import the database that has all the products in. The images aren't stored in the database, they are in the images directed and referred to in the DB, but you say you've grabbed a copy of the files so presumably you've got the images.

 

Hope this helps ..... but be careful what you are doing with the above, if necessary get some help from someone who knows what they are doing, even with slow down loads the above should be able to be done in way less than a couple of hours, more like 30 minutes if you have all the id and MYSQLADMIN at both ends.

 

M-Pro

[sp_kenny]

Woohoo the site is up and running. THanks so much for all of your help. Now one last question. On the index page there are several boxes on the left for reviews , languages and best sellers. How do I remove these options?

 

Thanks,

 

Shawn :D

[Guest]

look in the catalog/includes/column_left.php In there you will see the boxes that appear on the left. Modify accordingly.

[sp_kenny]

Wow thanks again. Worked fine. I don't know what I would have done without all of your help. Ok last 2 things I swear. ON the my account page it shows previous orders from other people , how do I kill that. Also I currnetly have paypal upport but how do I add credit card support thru paypal?

 

Shawn

[satish]

I have been reading the forums for an answer to this and so far have none.  I need to transfer my site and shopping cart to a new host.  What files need to be changed in order to do this.  I did not build the site it was done for me and the person doing it really screwed us over.  It was a legal battle to get ownership of the site back and now I need to get it off of his server .  I have access to his server temporarily so I need to act quickly.  I tried just transfering the files ( knowing it would not work ) and get a database error.  Any assistance greatly appreciated to keep from redoing a 1200 item site.

 

Thanks

<{POST_SNAPBACK}>

Creat a data base generally with change in server the db name might get some pre appended value.So if its diff from the previous name modify configure.php of both catalog and admin.

Aldo you might have to change some more values in configure for path changes.

 

Satish Mantri

[satish]

I have been reading the forums for an answer to this and so far have none.  I need to transfer my site and shopping cart to a new host.  What files need to be changed in order to do this.  I did not build the site it was done for me and the person doing it really screwed us over.  It was a legal battle to get ownership of the site back and now I need to get it off of his server .  I have access to his server temporarily so I need to act quickly.  I tried just transfering the files ( knowing it would not work ) and get a database error.  Any assistance greatly appreciated to keep from redoing a 1200 item site.

 

Thanks

<{POST_SNAPBACK}>

 

Also just downlaod the catalog and admin plus download the db thru PHpMyAdmin andsave it on your desktop.

So even if access to the existing site is lost you have all the data.

 

Satish Mantri

[sp_kenny]

Well I actually have everything running good now and all is backed up. THe only thing I would like to do is a dd a link to the top bar where home and catalog links are located. I cannot find this anywhere in any php but I know I am just overlooking it.

 

Shawn

[M-Pro]

Have a look in catalog/includes/header.php

 

Well I actually have everything running good now and all is backed up.  THe only thing I would like to do is a dd a link to the top bar where home and catalog links are located.  I cannot find this anywhere in any php but I know I am just overlooking it.

 

Shawn

<{POST_SNAPBACK}>