Author: sepedatua

Hey, I'm SepedaTua — a self-taught programmer and sysadmin in my early 40s, running CrushEdge to share the fixes I wish I'd found faster. I spend my days wrestling WordPress, WooCommerce, Linux servers, PHP, Python, and whatever else small-business sites throw at me. After years of trial-and-error (and way too many late-night server crashes), I document the solutions that actually work — safely, with backups first, and no unnecessary fluff. Outside the terminal, I'm a dad to four awesome kids, married to my best friend, and still squeezing in some video games when the house quiets down. If you're stuck on a problem, grab a coffee and let's sort it out together.
Hey, I'm SepedaTua — a self-taught programmer and sysadmin in my early 40s, running CrushEdge to share the fixes I wish I'd found faster. I spend my days wrestling WordPress, WooCommerce, Linux servers, PHP, Python, and whatever else small-business sites throw at me. After years of trial-and-error (and way too many late-night server crashes), I document the solutions that actually work — safely, with backups first, and no unnecessary fluff. Outside the terminal, I'm a dad to four awesome kids, married to my best friend, and still squeezing in some video games when the house quiets down. If you're stuck on a problem, grab a coffee and let's sort it out together.

Move rows between tables, avoid duplicate and update auto increment value.

sepedatua • Leave a comment

Table “books” and “books_tmp” is identical. “books” table is production state.“books_tmp” is sandbox/testing/pre-production state. Data comes in csv files >> dumped to “books_tmp” >> checked, sorted, etc. >> good data moved to “books”, row by row. Before moved, “books_tmp” data is checked for duplicates in “books”, using ISBN (unique).Upon inserted into “books”, (auto increment) id is checked for duplicate, if…

Read More »

How to: install ionCube loaders on Linux server

sepedatua • Leave a comment

ionCube loader is the PHP extension that decodes encrypted PHP files at runtime. Most commercial hosting companies have ionCube loader installed already. But if this is not your case, here’s how to install the loader. Steps: [*] Login via SSH to your server as root [*] Download the loader from ionCube: wget http://downloads2.ioncube.com/loader_downloads/ioncube_loaders_lin_x86.tar.bz2 Wait until its finished: –09:20:50– http://downloads2.ioncube.com/loader_downloads/ioncube_loaders_lin_x86.tar.bz2 Resolving…

Read More »

Increasing virtual memory

sepedatua • Leave a comment

To increase virtual memory / paging in Windows XP: Go to: >> “Control Panel” >> “System”. >> “Advanced” >> Under “Performance” label, click the “Settings” button. >> In the new window, navigate into “Advanced” tab. Under “Virtual Memory” label click the “Change” button. >> Select “System Managed Size” and click the “Set” button and “OK”. Restart the computer for the…

Read More »