need advice switching hosts from Xampp to a hosting company...where to start?

[dhilden]

Hi,

 

I've been modifying my oscommerce site for the past month using Xampp, the local hosting platform that people recommended to use before loading it to a live address with a hosting company.

 

Now I'm happy with my site and need to transfer my store from Xampp to a company that will host the site for me. I've been looking for a while but can't find any documentation for how to do this. Do I have to start with a clean oscommerce install?

 

First I uploaded the same 'catalog' folder as I had in Xampp to my new host using ftp to www.bonzjewellery.com. Then I looked in www.bonzjewellery.com/catalog and the following error appeared:

 

'Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /home/.mardi/bonnielou/bonzjewellery.com/catalog/includes/functions/database.php on line 19

Unable to connect to database server!'

 

So I read through a bunch of stuff and found out that I need to put in another database in my new server, which I did....and the same error occurred.

 

So i'm wondering if I need to transfer my sql database from Xampp to my new host? I'm really confused, any advice on where to find directions would be greatly appreciated.

 

How is switching hosts different from the installation guide at http://www.oscommerce.info/docs/english/?

 

thanks

[natewlew]

You have already transferred you catalog folder to your host and made a database.

 

Now you need to export your old database with phpmyadmin and import it into your new empty database.

 

Then you need to update the paths and mysql information in the includes/configure.php and the admin/includes/configure.php.

[usernamenone]

Once you have had a unsuccessful install you must start all over again.

 

Delete your database base and start with a clean empty database.

 

You did not say when you got your error but you must do the install (catalog/install) and answer all the questions. This is when you give your install your database user name and password.

[dhilden]

hey,

 

thanks so much for the advice. I have now got my website running on the new Hosting company. The only thing to do is transfer the databases from Xampp to mysql.bonzjewellery.com. I have gone into Xampp and clicked on all the databases, then clicked 'export' (this gives me one huge text file that can't be imported to my new database). I believe I have to export it from Xampp first and save the files on my laptop, then import it to my new host from the saved file on my computer....but i've run into a wall

 

any advice on how to get the databases to my new server?

[dhilden]

ok I found the solution to that problem on another site http://forum.websitebaker.org/index.php?PH...;prev_next=next

 

The databases are loaded to my new server and all the pictures and everything works perfectly on the home page. My site is now online at www.bonzjewellery.com. The new problem is when I click on any of the categories or pictures the following message appears:

 

'The requested URL /://www.bonzjewellery.com/product_info.php was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.'

 

I looked on my server and the product_info.php file appears to be loaded to my new server.

 

Anyone had this problem before or know how to fix it?

[usernamenone]

Did you do a backup on the Xamp server and then do a restore on the hosted server?