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

sepedatua • No 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 • No 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 »
Practical Linux Permissions Basics for New Server Admins

Practical Linux Permissions Basics for New Server Admins

sepedatua • No Comment

Why Linux Permissions Matter When You Touch a Server If you’re logging into a Linux cloud server for the first time, permissions can feel like a wall of cryptic letters and numbers. It hits anyone who tries to manage a VPS, set up services, or host apps without understanding who owns what on the system. Linux is a multi-user operating…

Read More »

Increasing virtual memory

sepedatua • No 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 »