Just wanted to put my issues out here to see if I can get a little assistance from anyone.
Situation is this:
Got referred to this problem because the original devs went dark on the site owners. I have ZERO experience with Magento prior to this but have worked with PHP carts before and other CMS systems.
Somehow, the site owner screwed up their database over a month ago, yet I get called to help now. Joy! I get GoDaddy to restore their site and their database as close to the death date as possible. I am trying to restore the database, which is massive(2.1GB). I managed to get direct access to it and start the import the SQL script but I keep getting errors of this variety:
Duplicate entry \'1\' for key 1
Is there a way to disable the key restraints and get the database loaded back up? I\’m really at a loss because working with such a large file is so time consuming just to open files, save them and execute them.
Currently I\’ve had this error appear in the following tables, and am expecting it to occur in others:
Any advice would be helpful at this point as I want to simply get the DB back to where I found it.