Moving Oscommerce to new domain

[LaurenElise]

I have a current oscommerce shop setup but Im trying to move it to a different server that has more space, and Im also changing the domain for marketing reasons. Both the old and new host have cpanel.

 

Problem is I've tried to move the site a few times and keep getting various error messages. Im sure Im just missing a basic step somewhere but I cant seem to find any clear instructions on the process.

 

I tried first by

 

- downloading all my files from the old site

- backing up the database through admin on oscommerce

- installing oscommerce through cpanel on the new site

- uploading the files to the new site via ftp

- altering both config files to reflect the new website address

- restoring the database using oscommerce

 

When I did this I had an error message in german on the home page, and the database wasnt loading properly into oscommerce. It either didnt seem to upload at all, and on one try I had the catagories and info, but the pictures didnt show and I still had the error on the home page.

 

I also tried a few variations of the config file, but when I altered this it didnt let me log into the admin section. I also tried to upload the database using phpmyadmin but It wouldnt allow me to import the old database.

 

If anyone could point me to a clear set of instructions on how to move an oscommerce site to a new domain and host, that would be great. Any advise at this point will be helpful.

[bkellum]

Try this:

 

1. Export your old database using phpMyAdmin and save the sql file to your computer
   
2. Backup all of your old osCommerce files, all folders and files
   
3. Wipe your new location clean of the current osC installation
   
4. FTP (upload) your old osCommerce folders and files to the new site
   
5. Create a new (blank) database on the new server noting the username and password
   
6. Import the old database into the newly created blank database using phpMyAdmin
   
7. Edit the admin/includes/configure.php and includes/configure.php to match the paths of your new site. You will also need to edit the database settings in these files to match your new setup. eg: localhost name, username, password, etc.
   
8. Check your file permission settings on the above two files as well as your images and admin/backups folder.
   

The above is for a manual installation. You may run into problems if your old shop is based on an older version of osCommerce that does not play nicely with an updated server setup that is running PHP 5 and/or MySQL 5. If you old shop is already running the latest version of osC then you should not run into any problems.

 

NOTE: You could follow the migration path that you had previously tried as long as the new osC installation is the same version as your old shop. If not, then you run the risk of files/folders/database not matching up.

 

This is a long way of explaining something that is a pretty straight forward process. I highly suggest that you give Vger's osC Installation thread a read as it goes into more detail of the above:

 

http://www.oscommerce.com/forums/index.php?sho...p;#entry1262567

 

Hope this helped,

[LaurenElise]

Thanks for your help, I got so frustrated with the whole process I ended up paying someone to move it for me.

 

Im still not sure where I went wrong though. I had tried the steps you mentioned but when I got to step 6 phpmyadmin wouldnt let me import the database, I just got an error message.

 

I'll probably have to move the shop again at the end of the year because my current hosting package only has 50mb's of space. So Im really hoping I can do it myself next time. It sounded so simple from the steps I had read about moving an oscommerce site. Others had said it is easy as pie if you have cpanel on both sites, but something I was doing wasnt adding up and I couldnt find any clear steps on the process so I could back track to find out what the issue was.

 

 

Oh well, its done now, and im none the wiser lol

[diy]

I had tried the steps you mentioned but when I got to step 6 phpmyadmin wouldnt let me import the database, I just got an error message.

 

 

What error message??? I moved recently and I had a problem with the database, apparently the new database server was an older version and I could not import a database made on a newer version of Mysql.

 

they moved me to a server with a newer mysql version (and equal or higher to the one that my database came from) and my problem was solved :hopefull

 

 

PS I tried also to export a database by using "SQL compatibility mode" but I had a problem with encoding

[bkellum]

Thanks for your help, I got so frustrated with the whole process I ended up paying someone to move it for me.

 

Im still not sure where I went wrong though. I had tried the steps you mentioned but when I got to step 6 phpmyadmin wouldnt let me import the database, I just got an error message.

 

I'll probably have to move the shop again at the end of the year because my current hosting package only has 50mb's of space. So Im really hoping I can do it myself next time. It sounded so simple from the steps I had read about moving an oscommerce site. Others had said it is easy as pie if you have cpanel on both sites, but something I was doing wasnt adding up and I couldnt find any clear steps on the process so I could back track to find out what the issue was.

 

 

Oh well, its done now, and im none the wiser lol

That's too bad. :( Next time, come back to the forums and let us know what part you are having trouble with and we will try to get you through it.

 

The database error was most likely caused by how the original database was exported. In phpMyAdmin, you need to have the following settings checked in the export window:

 

Under Structure, check the following:

 

Under Export, check the SQL button.

 

Add DROP TABLE

Add IF NOT EXISTS

Add AUTO_INCREMENT value