I have had a client transfer a Magento to me recently from their old host which was shutting down.
Unfortunately, the old host was unaware of Magento's.... features, and sent me a database that was screwed up big time. I have managed to fix the majority of the damage via a lot of effort. But the final hurdle is replacing a lot of missing quotation marks.
They have all been changed from ' to ’
The problem is, I don't want to have to run a query on 220 individual tables...
So any suggestions on how to run it and search ALL tables for ’ and if found, replace it with '
Im guessing some sort of regular expression... however I will happilly admit, RegEx is something I can't get my head around... I know what it does and how it does it... but not how to form it into something I would use.
Thanks!
Unfortunately, the old host was unaware of Magento's.... features, and sent me a database that was screwed up big time. I have managed to fix the majority of the damage via a lot of effort. But the final hurdle is replacing a lot of missing quotation marks.
They have all been changed from ' to ’
The problem is, I don't want to have to run a query on 220 individual tables...
So any suggestions on how to run it and search ALL tables for ’ and if found, replace it with '
Im guessing some sort of regular expression... however I will happilly admit, RegEx is something I can't get my head around... I know what it does and how it does it... but not how to form it into something I would use.
Thanks!