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 »

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 »

Steve Jobs newest gadget: Apple iPad MB292LL/A Tablet (16GB, Wifi)

sepedatua • No Comment

A magically and revolutionary product at an unbelievable price. Technical details and features: [*] CPU Manufacturer: Transmeta [*] Hard Disk Size: 16GB [*] Hard Disk Interface: IDE [*] Hardware Platform: Mac [*] Dimensions (inches): 0.50 x 9.56 x 1.50 x 7.47 (Height x Length x Weight x Width) [*] System Memory Size: 256MB DIMM [*] 9.7-inch (diagonal) LED-backlit glossy widescreen…

Read More »

Free public resolving nameservers

sepedatua • 1 Comment

Google public DNS: 8.8.8.8 8.8.4.4 Cloudflare: 1.1.1.1 1.0.0.1 Tiggee LLC 208.94.147.150 208.94.147.151 Level3 4.2.2.1 4.2.2.2 4.2.2.3 4.2.2.4 4.2.2.5 4.2.2.6 TelkomFlexi 202.134.0.155 203.130.212.217 Open DNS (with parental control) 208.67.222.222 208.67.220.220

Read More »