Shopify is an e-commerce platform that enables individuals and businesses to create online stores. It started its work in 2006 but now it is great system with expressive functionality. Cataloges, blogs, hundreds of apps, large theme store, access to PayPal and excellent documentation and community for all these things. But it is better to try once then to hear for thousand times.
So let us start to make a real shop!
Sometimes you need to make a mysqldump backup without having SSH access or PHPMyAdmin. It can be done with PHP by means of SHOW TABLES/SHOW CREATE TABLE mysql queries. Below is an improved solution proposed here.
- Got rid of memory_limit – writing to file on every iteration
- gzip support – you don’t have to download huge uncompressed .sql
- PHP notice fixed
- added IF EXISTS to DROP TABLE
- ereg_replase -> str_replace
- added set_time_limit(0) to work with large DB’s
In order to make a dump:
As it might be inconvenient for some people (especially Windows users) to checkout specific revision and then patch it, I’m publishing here a patched version of ZF trunk rev. 24409 + ACL patch from rojakcoder.
Assume we have a web server having node.js (or any other client-server software) installed behind a load balancer and teh web server has only internal IP address. We need to allow clients to connect to node.js. So we need to do port forwarding with iptables from load balancer’s 8000 to web server’s 8000.
So the ideal model will look like on the figure below.