milauskas Posted August 22, 2010 Posted August 22, 2010 Hi, After one of my sites was hacked I decided I'd have to do a clean install. I did it first on my local computer (a Mac running apache, php, mysql) and got the catalog back to where it was. After doing a clean install locally, I kept replacing files from the live site backup until I got the store working correctly. I created a new local database using an export from the live site and everything showed up fine. The products and descriptions were there and I was able to go through the checkout, etc. I thought, okay, I'll do a clean install on the live server and then upload my local files, replacing files on the new install with files from my local install to get it working (of course the local settings are different from the live store settings in files like configure.php so I excluded overwriting those files). I kept notes as I did the local replacement and am trying to do the same thing on the live server. However, now I think I've uploaded every file from my working local backup and yet I still see the default products and categories. What file determines categories and/or products. Am I missing something? I imported the same sql file to the live server that I used locally so shouldn't I be seeing product and categories that I created? Not the default Hardware, Software and DVD movies? If anyone can help I would be VERY grateful. THanks!
FIMBLE Posted August 22, 2010 Posted August 22, 2010 hello Did you drop the old database before adding the new one? Nic Sometimes you're the dog and sometimes the lamp post [/url] My Contributions
multimixer Posted August 22, 2010 Posted August 22, 2010 You say that you didn't replaced the 2 configure.php files. I suspect that they point to the new "clean install" database A. So you need to change them to point to your desired database B My community profile | Template system for osCommerce - New: Responsive | Feedback channel
milauskas Posted August 22, 2010 Author Posted August 22, 2010 hello Did you drop the old database before adding the new one? Nic Hi Nic, I did drop the old database and imported my backup copy. That's why I'm confused. Can I do it again? I mean, what would happen if I dropped the database now after having installed the store and then imported the backup copy again?
milauskas Posted August 22, 2010 Author Posted August 22, 2010 You say that you didn't replaced the 2 configure.php files. I suspect that they point to the new "clean install" database A. So you need to change them to point to your desired database B Hi Multimixer, I'm not sure I follow. If I dropped the old database, then imported the backup version it would be called the same thing, correct? If that's true then during the install process I should enter the same database info (which I did). Database, server, user, password. And if the backup database has all the new product info in it, shouldn't the product show up instead of the default ones? BTW, I checked both configure.php files and I've got the new database info in both. I am so confused.
Guest Posted August 22, 2010 Posted August 22, 2010 Did you refresh your browser cookies ?? Perhaps you are looking at a cached version of the site ??? Chris
Jan Zonjee Posted August 22, 2010 Posted August 22, 2010 Can I do it again? I mean, what would happen if I dropped the database now after having installed the store and then imported the backup copy again? Yes, you could do it again. No problem. But if you did the new install, perhaps you left the install directory there and the hacker knows the name of your database and password and did the install again? Just summing up some possibilities...
milauskas Posted August 24, 2010 Author Posted August 24, 2010 Okay, I've tried everything I know several times. I have created a new database and imported the saved sql file into it. When I browse some tables I see products and orders, etc. so it seems that the database is good. I then do a clean install of osc using the new database, its server, username and password. osC installs correctly. Then I go to the catalog and I see all the default products. If i'm using a database with the correct products in them, shouldn't they show up after install? Alternatively, if not, what files do I need to overwrite? I've looked at the configure.php files in both catalog/includes and admin/includes and everything looks correct. The database, server, user and password are correct so I'm very confused.
milauskas Posted August 24, 2010 Author Posted August 24, 2010 Here's my current status. I was confused. I thought that doing a clean install would use the data in the database to populate the store. I misunderstood. Now I know that installation overwrites everything in the database. That's why I was seeing default products. So, I've done another clean install and then restored the old database using bigdump. SO far, so good. I see the products the SHOULD be in my catalog now.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.