28 Jul

Quicker Dumping of a Magento MySQL Database for Branching

Any experienced Magento developer will certainly have felt the pain of dumping a multi-gigabyte MySQL database for a Magento store. Which is certainly a tedious process when you want to make a quick branch or rapidly update your staging environment. We're big advocates of branch often and merge often - but this also means updating … Continue reading

28 Jul

Quickly Purge a Magento MySQL Database

I'm sure everyone has got to that point where they need to empty a Magento MySQL database and you've logged into PHPMyAdmin, selected all the tables, then clicked delete. Only to find out only a small proportion can be deleted because of foreign key constraints. But if you persist, running the "select all" and "drop" … Continue reading

20 Apr

Giving support access to Magento (for EE support) ... with a regex

As part of an EE upgrade, we've just hit a reproducable core bug with 1.11; as we have to focus on the other fixes, we're letting Magento's EE SLA'ed support take care of the core bugs. But, in order to do that, they need access to the machine. The Magento support IPs 207.86.19.64/28 216.127.124.224/27 67.88.151.96/28 … Continue reading

20 Apr

Maintenance page with Nginx with specific permitted access

At the moment, we're in a fairly complicated upgrade of a Magento live store and during the upgrade window, it is necessary to put up a holding page. A simple maintenance.flag file isn't going to cut it for this process, so cutting off users at the web server is more suitable. For this particular customer, … Continue reading