nezbie Posted June 3, 2003 Posted June 3, 2003 Hi again, I decided to give some time to install Apache, Php and MySQL to my computer. Ok, they work fine. But now, how can I safely import everything from my current webpage (under development) store to my own computer, I tried just to copy the files and folders from there, modified configure.php to exceed current needs (changing servers, database address, etc) with making a "new install"... But, the only thing that remained the same was the layout, all the other defaults got back, like it was nothing was modified, language changed to english, all the things I removed got back... How can this even be possible? :shock: I'm really stunned... If there truly is evil in this world. It lies within the heart of mankind..
Ian Posted June 3, 2003 Posted June 3, 2003 It's quite simple really, all of those settings are stored in the database. To carry them accross to your offline site, you would have to export the contents of your online site and then import that into your offline site. Trust me, I'm an Accountant.
nezbie Posted June 3, 2003 Author Posted June 3, 2003 Ok, so I should 1. download the whole page contents from the net to a temporary folder 2. copy all the files to "localhost/www/" -folder 3. copy the database to mysqldata"mycatalog" ? 4. go to catalog/install/index.php - new install 5. install oscommerce and put the database name to "mycatalog" ?, should I enable the "Import Catalog Database" ? What then? :) If there truly is evil in this world. It lies within the heart of mankind..
Ian Posted June 3, 2003 Posted June 3, 2003 As you have already downloaded all pages succesfully from your live site then I don't se any reason to repeat this. The only part left to do is to transfer the database contents. Transferring the mysql data files is a possibility, or using phpmyadmin to export import the data is another way. I'm not a mysql expert so I'm not sure if there are any differences in the raw data files accross mysql version so phpmyadmin might be the safer option. Trust me, I'm an Accountant.
nezbie Posted June 3, 2003 Author Posted June 3, 2003 Ok, thanks for quick replies :) I'll try it out tomorrow afternoon as it's very late now :P 1.53 am local time... I'll ask if I happen to run any more problems.. Hopefully not :) If there truly is evil in this world. It lies within the heart of mankind..
Daemonj Posted June 4, 2003 Posted June 4, 2003 Yep, it is easy. On your webserver, go into PHPMyAdmin, and select 1. your database 2. the export tab 3. all of the tables 4. structure and data 5. add drop table 6. complete inserts 7. extended inserts 8. and, if you have the option, save to file 9. and click the ok button. Save the file to c:tempdb_backup.sql Then on your local system, in PHPMyAdmin 10. select the database 11. select the drop tab and confirm 12. at the main page, enter the name of your database and select create 13. select the new database if it is not selected. 14. click the sql tab 15. either click the browse button and select the c:tempdb_backup.sql file or just enter the information into the box and click ok. and that should do it for ya. ;) "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein
bklynjava Posted June 17, 2003 Posted June 17, 2003 The installation works great on my server when I access it via http://localhost. when I go over to another computer and access it from the url http://ibmbob.com all the images are missing. I have tried this....(ie) define('HTTP_SERVER', 'http://ibmbob.com'); // eg, http://localhost - should not be empty for productive servers define('HTTPS_SERVER', 'https://ibmbob.com'); in both areas admin as well as catalog/includes. When I make this change in the configure.php files localhost and ibmbob both lose the images. Any help is much appreciated.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.