reinstalling old store on new server

[thestark]

Hello,

 

I had a osCommerce store up on one of my sites' web servers (hosted by IPowerWeb). Recently, we changed the domain name and IPowerWeb assigned me a new block of server space, so I needed to re-upload the site to that. IPowerWeb supports osCommerce and allows you to install it directly and automatically from their control panel, so I did that (that's the way I'd also installed it previously). I had also done a database backup of the original store (the SQL file). Now I'm trying to restore the database in the Admin section... First, I tried to upload the SQL file directly from the Admin section, and that didn't work (the default products and settings are still visible). So next, I uploaded the .sql file directly to the backups folder on the server and it showed up in the menu, so I tried to restore it that way. It cuts the process short, and says there are MySQL syntax errors.

 

Does this ring a bell to anyone as far as what I'm doing wrong? I just need to import the old catalog and settings into an already-installed store. I also have all of the files from the original store on my hard drive, and I actually tried uploading those as well, but that didn't work, which didn't surprise me.

 

Many thanks to anyone who can point me in the right direction. Let me know if I need to provide more detail. Also, I couldn't find this topic, so please direct me to the proper place if it's been covered.

Todd

[ammmze]

Hello,

 

I had a osCommerce store up on one of my sites' web servers (hosted by IPowerWeb). Recently, we changed the domain name and IPowerWeb assigned me a new block of server space, so I needed to re-upload the site to that. IPowerWeb supports osCommerce and allows you to install it directly and automatically from their control panel, so I did that (that's the way I'd also installed it previously). I had also done a database backup of the original store (the SQL file). Now I'm trying to restore the database in the Admin section... First, I tried to upload the SQL file directly from the Admin section, and that didn't work (the default products and settings are still visible). So next, I uploaded the .sql file directly to the backups folder on the server and it showed up in the menu, so I tried to restore it that way. It cuts the process short, and says there are MySQL syntax errors.

 

Does this ring a bell to anyone as far as what I'm doing wrong? I just need to import the old catalog and settings into an already-installed store. I also have all of the files from the original store on my hard drive, and I actually tried uploading those as well, but that didn't work, which didn't surprise me.

 

Many thanks to anyone who can point me in the right direction. Let me know if I need to provide more detail. Also, I couldn't find this topic, so please direct me to the proper place if it's been covered.

Todd

 

Had you modified the store before the switch? If so you will need to upload the original files from your hard drive to whereever you want them, and then edit the configure.php file, I think it is in the includes directory, make sure everything points to the new domain and what ever else changed and make sure your database server is still correct and same with your database username and password. They may have changed during the switch, but I dont know. Then upload the old sql through phpmyadmin if possible.

 

hope that helps, I know it sounds like what you did but maybe you missed somthing

[thestark]

Ammmze,

 

Just wanted to say thanks for your help. That was similar to what I did, but it was nice to have it laid out like that. Everything worked great! (Uploading the SQL through PHPMyAdmin as opposed to the osCommerce admin may have helped too.)

 

Thanks again.

Todd

 

Had you modified the store before the switch? If so you will need to upload the original files from your hard drive to whereever you want them, and then edit the configure.php file, I think it is in the includes directory, make sure everything points to the new domain and what ever else changed and make sure your database server is still correct and same with your database username and password. They may have changed during the switch, but I dont know. Then upload the old sql through phpmyadmin if possible.

 

hope that helps, I know it sounds like what you did but maybe you missed somthing