Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

transfer site to a new server


sp_kenny

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

James Scheller

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

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

Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site.

 

Check My About US For who am I and what My company does.

Link to comment
Share on other sites

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

 

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

Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site.

 

Check My About US For who am I and what My company does.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...