Posts Tagged ‘mysql’

MySQL replication in PHP - on the same machine

Wednesday, September 14th, 2011

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

MySQL / InnoDB performance optimization

Wednesday, September 14th, 2011

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

Clojure and MySQL

Sunday, February 13th, 2011

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

Generating extended MySQL inserts in PHP

Thursday, November 4th, 2010

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

Migrating a Legacy Forum to vBulletin 4.0.3

Saturday, July 17th, 2010

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

Remote MySQL database backup with local Linux shell

Wednesday, July 14th, 2010

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

MySQL tips and tricks

Tuesday, May 26th, 2009

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

The missing fluent MySQL wrapper

Thursday, April 30th, 2009

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

Smarty + Doctrine = Smoc

Wednesday, February 18th, 2009

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

Simple Doctrine model to MySQL script

Monday, February 16th, 2009

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