esm Posted October 6, 2005 Share Posted October 6, 2005 Hi, I have XAMPP installed, have switched to php 4 and have created a blank database in the phpAdmin control panel. I have dowloaded (via ftp client) an osCommerce-based production website into a catalog folder inside the XAMPP folder and I am trying to locate the database so I can "import" it into the blank database I have created. The problem is that I can not seem to locate the database in the downloaded production website. Can someone tell me where the database typically would be located? What would be a typical file name/extension? Perhaps .sql? When I am trying to "fill" the created database in the phpAdmin window, it asks me for a text file. Is that the database file? I'd really apreciate any help I could get. Thanks, esm Link to comment Share on other sites More sharing options...
♥Vger Posted October 6, 2005 Share Posted October 6, 2005 The database is not in the folders/files of the production website. You need to access it via phpMyAdmin and use the 'Export' function to download a backup of it to your computer. Once you've done that then you need to go to http://localhost/phpmyadmin, locate the blank database you've set up and use the SQL tab and the Browse function to locate the sql file you downloaded, then click 'Go' and it will populate the database. Vger Link to comment Share on other sites More sharing options...
esm Posted October 6, 2005 Author Share Posted October 6, 2005 The database is not in the folders/files of the production website. You need to access it via phpMyAdmin and use the 'Export' function to download a backup of it to your computer. Once you've done that then you need to go to http://localhost/phpmyadmin, locate the blank database you've set up and use the SQL tab and the Browse function to locate the sql file you downloaded, then click 'Go' and it will populate the database. Vger I'm sorry but I don't understand that. First you say that the database is not in the folders/files of the production website and then you say I need to access it via phpMyAdmin and export it. Access it where? Online? Export what file? Sorry to appear so dense. Link to comment Share on other sites More sharing options...
OSCnewbie Posted October 7, 2005 Share Posted October 7, 2005 esm, I'm new to osC, but if I understand you correctly, you want to make a copy of the entire database that has been populated by a live osC-based website, which you've downloaded locally to work on. That would mean the full database still resides with the original web host (if I understand your question). You would need access to it through the host's phpmyadmin URL, along with username and password for that database. But, if you are simply looking for the .sql file to start a new database locally, it is called "intall/oscommerce.sql". It would contain all the database tables, but of course they would not have any current data in them. Hope this helps. And sorry if I'm so far out in left field that you can't see the highway anymore! --OSCnewbie. Link to comment Share on other sites More sharing options...
esm Posted October 7, 2005 Author Share Posted October 7, 2005 esm, I'm new to osC, but if I understand you correctly, you want to make a copy of the entire database that has been populated by a live osC-based website, which you've downloaded locally to work on. That would mean the full database still resides with the original web host (if I understand your question). You would need access to it through the host's phpmyadmin URL, along with username and password for that database. But, if you are simply looking for the .sql file to start a new database locally, it is called "intall/oscommerce.sql". It would contain all the database tables, but of course they would not have any current data in them. Hope this helps. And sorry if I'm so far out in left field that you can't see the highway anymore! --OSCnewbie. Hi Newbie, Yes, you did understand me correctly. I have ftp'd the entire production website on to my PC and I was under the impression that the download somehow included the database, which apparently does not seem to be the case. I can get into the online control panel (I do have the user name and the PW) but I don't know what to do and how to find the online database. Could you tell me what to do? Thanks a lot, esm Link to comment Share on other sites More sharing options...
♥Vger Posted October 7, 2005 Share Posted October 7, 2005 Okay - simple solution - go to your osCommerce admin panel --> Tools --> Backup and click to take a backup of the database, then tick the box to back it up via download. It will download a backup of your database to your computer. Vger Link to comment Share on other sites More sharing options...
esm Posted October 7, 2005 Author Share Posted October 7, 2005 Okay - simple solution - go to your osCommerce admin panel --> Tools --> Backup and click to take a backup of the database, then tick the box to back it up via download. It will download a backup of your database to your computer. Vger Thanks a bunch! Got it downloaded and installed in XAMPP. Now I am wondering how to open all those php files so I can modify them. Right now, when I click on a php file, it opens in notepad. Thanks again, esm Link to comment Share on other sites More sharing options...
♥Vger Posted October 7, 2005 Share Posted October 7, 2005 Download and install a good plain text editor. Both Text Pad and Crimson Editor are free. Text Pad has a nag screen, but in my opinion is better than Crimson Editor. Once you've installed one of them you'll be able to right-click on the file and select either Text Pad or Crimson Editor to open the file with. Long term make it the default editor for .php files. Vger Link to comment Share on other sites More sharing options...
esm Posted October 7, 2005 Author Share Posted October 7, 2005 What do you think of the DzSoft PHP Editor? 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.