I just realized I needed to replicate some data from one database to another, but only certain tables.... Read More

I’ve recently gotten some help and done some research into optimizing a MySQL database. The following applies if you have a powerful box at your disposal, I have 32GB RAM and 32 cores. If you are very limited hardware wise then not much of the following will apply.... Read More

It’s time to start saving the data we downloaded in the prior part in a MySQL database.... Read More

Today I just realized I didn’t have any PHP code to generate extended MySQL inserts at my disposal. For heavy inserts I’ve been using BEGIN and COMMIT with lines terminated with ;. ... Read More

Recently I’ve just finished migrating a custom forum to vBulletin, in doing this your mileage may vary, much of it depends on if the original forum was part of a bigger offering that should still exist, or if it was standalone. In my case the site is cardlovers.com, a poker rakeback site, where the new forum is located at cardlovers.com/forum... Read More

There is a lot of talk about a lot of automation tools these days. Truth is though that you can cover a lot by simply using a normal shell script and some common Linux tools.... Read More

Update: This stuff has its own MySQL page now where we continue ... Read More

I just got a mail from John Fraboni, asking about that MySQL wrapper I’m using in my Zend AMFPHP tutorial. ... Read More

Update: Since the below piece was written I’ve ported the little framework to H2O instead, H2O is a cleaner alternative to Smarty.... Read More

I’m a bit rusty, after scouring the Doctrine manual for the import functions I found a script of my own that I totally had forgotten:... Read More