Trouble with subdomains on account:?

Click Here To View All Answers...

Got a quick question: Trouble with subdomains on account:? Looking forward for any answer or 2. Another quick question... Hello all,.

I'm looking for advice on how I can properly setup a test environment on my local machine and then FTP (to go live) to my host provider's machine..

Here's how I'm setup currently:.

Local Machine.

-Apache server.

-MySQL server.


Host provider.

-Apache server.

-MySQL server.


I'm sruggling with understanding how to move data and settings from the local machine to the host provider machine once I'm ready to go live..

Any advice would be appreciated!..

Comments (4)

I would like to know the answer too. Anyone here know what is the answer to that question. I'll do some Googling and get back to you if I find an answer. You should email the people at iPage as they probably could help you..

Comment #1

I would like to add that you have to be careful with moving the entire database up to the live server if you care about data like Customers, Orders,Products Viewed and Products Purchased unless you specifically are not including those in your database push. If you pushed these up, it will delete any information in these tables/columns since you're pushing stuff from your staging server to the live server...

Comment #2

Hi, I just did the same thing on my WindowsXP laptop. I downloaded a package called WAMP which sets up Apache, MySQL and PHP. It is not perfect (see caveats below) but most of it seems to be working..

There are 2 directories that are relevant \mysql\data and \www.

You need to get your osc database installed in \mysql\data and put a copy of \catalog in \www. You may need to add a user name to mysql with access to your osc database..

You will need to edit \catalog\configure.php and \catalog\includes\configure.php to point to localhost rather than your webhost, and check that the database user name & password matches what you set up for the mysql database..


1) WAMP comes with PHP5, and the copy of osC I have does not like it. There is a PHP4 module you can add to WAMP..

2) I have trouble with checkout. I can add stuff to the cart just fine for testing, but it gives me an error about keywords and netscape when I try to check out. I'm sure I have not configured it entirely right. But if all you want to do is adjust the look and feel, what I've described should do for you..

When done editing you can ftp the changed files (except for the 2 configure files) in \www\catalog to your webhost..

I'm not sure what's the best way to move table data to the webhost. I haven't been entering products. There's a contribution that allows you to upload from an Excel file..


This post has been edited by.


: 12 October 2004, 19:42..

Comment #3

Todd, in addtion to apache, Mysql, and osCommerce, you will also need PHP installed locally..

To sync your local PHP code with the server PHP code, you can copy all files, images, etc from your local host to your server, with the exception of:.



Leave the server's configuration files in tact..

As far as the database goes, you will need to do a mysqldump from your local machine. Include that add-drop-tables switch and output it to a text file. Then you can paste it straight into phpmyadmin on your live server. prior to pasting the entire file in, you may wish to delete some of the tables you dont want copied to the server, such as customers, orders, etc..

If you've only got 1 table to update, it's easier to copy the text for that 1 table only into phpmyadmin..

I hope this helps, it's been working flawlessly for me for the last few months...

Comment #4

One thing you can do is to create a local system configure.php file and place in the includes/local directory, then leave the includes/configure.php the same as on the live server. all you have to do is make sure the includes/local/configure.php file is deleted on the live server...

Comment #5

This question was taken from a support group/message board and re-posted here so others can learn from it.