Tobiel Posted March 21, 2004 Share Posted March 21, 2004 I got my shop up-and-running now, but I want to chagne server. Can I just go to a new server, upload all my files there, create a database with the same username/password etc. and upload my backup-database? Is it even possible? Link to comment Share on other sites More sharing options...
Draco Posted March 21, 2004 Share Posted March 21, 2004 Try it you have nothing to lose it is straightt forward. If it doesn't work try again. Link to comment Share on other sites More sharing options...
ozcsys Posted March 21, 2004 Share Posted March 21, 2004 I got my shop up-and-running now, but I want to chagne server. Can I just go to a new server, upload all my files there, create a database with the same username/password etc. and upload my backup-database? Is it even possible? Yes you will just have to make any needed changes in your two configure.php files. I usually start a site on a local computer then move it to a server when it is ready and these are the steps I use. First make a backup of your database on the old site and download your site to your computer. Then follow these steps and you should be OK 1. Ftp all your files to server 2. create a database 3. make changes in the two configure.php files ftp changes to server 4. using php my admin run the oscommerce.sql file (found in the install directory) to populate the database with the correct fields so the admin section will work 5. restore database from the admin page using last backup made just before you transferred the site. This will give you all your product data and changes to database made by any contributions you installed. Site should now be up and running The Knowledge Base is a wonderful thing. Do you have a problem? Have you checked out Common Problems? There are many very useful osC Contributions Are you having trouble with a installed contribution? Have you checked out the support thread found Here BACKUP BACKUP BACKUP!!! You did backup, right?? Link to comment Share on other sites More sharing options...
Guest Posted May 1, 2004 Share Posted May 1, 2004 Which are the two configure.php files? Link to comment Share on other sites More sharing options...
Jason G Posted May 6, 2004 Share Posted May 6, 2004 I followed your instructions, but I got this error: 1054 - Unknown column 'customers_selected_template' in 'field list' select customers_selected_template as template_selected from customers where customers_id = '' [TEP STOP] Any idea what I should do now? Any help would be very appreciated. Sincerely, Jason Link to comment Share on other sites More sharing options...
Jason G Posted May 6, 2004 Share Posted May 6, 2004 Actually, I'm having trouble with Step 4. I see no install directory; not in FTP or in phpmyadmin. Where is it? JG Link to comment Share on other sites More sharing options...
ozcsys Posted May 6, 2004 Share Posted May 6, 2004 Actually, I'm having trouble with Step 4. I see no install directory; not in FTP or in phpmyadmin. Where is it? JG Do you have a copy of osC on your local computer? If not download one and you will see catalog/install/oscommerce.sql That is the file you use in step 4 For step 5 you are going to use the backup that you did in your admin section of osC just before you started moving you site. ( you did do a backup, say yes ) The admin section will work after step 4 but unless you have not loaded any contributions that made changes to the database the catalog section will not work until you do a restore from your backup in step 5 and you will get error messages. The Knowledge Base is a wonderful thing. Do you have a problem? Have you checked out Common Problems? There are many very useful osC Contributions Are you having trouble with a installed contribution? Have you checked out the support thread found Here BACKUP BACKUP BACKUP!!! You did backup, right?? Link to comment Share on other sites More sharing options...
ComputerCity Posted May 10, 2004 Share Posted May 10, 2004 Actually, I'm having trouble with Step 4. I see no install directory; not in FTP or in phpmyadmin. Where is it? JG Do you have a copy of osC on your local computer? If not download one and you will see catalog/install/oscommerce.sql That is the file you use in step 4 For step 5 you are going to use the backup that you did in your admin section of osC just before you started moving you site. ( you did do a backup, say yes ) The admin section will work after step 4 but unless you have not loaded any contributions that made changes to the database the catalog section will not work until you do a restore from your backup in step 5 and you will get error messages. Hi, I followed the instructions here, except for step 4 - I don't know how to phpmyadmin (newbie :-/ ). I uploaded the backup of my shop to the new server by ftp, made the database, ran install to set it up, and restored the backup. The shop works, but I can't see my products or customers. Ermm.... help? :-) Cheers, Ron Link to comment Share on other sites More sharing options...
Guest Posted June 26, 2004 Share Posted June 26, 2004 Possibly a better solution for some, what I tend to do is develop what I need on one server. Then transfer 2 my web server, once I am happy. HOW: I make a complete sql export drop tables and all that in phpmyadmin ok, I save this into my install folder replacing my original stock oscommerce.sql. I then copy the catalog complete to the new server, making the config in catalog and admin 777chmod writable, then I just use the osc install and let osc setup my config file the normal way, and it works like a charm no problems. Hope this helps Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.