MySQL

Code

PHP Best Practices: Models and Data Mining

Most PHP developers utilizing MVC frameworks would argue that the best approach for models are classes with a varied number of getters and setters. After a long time working with PHP and especially MVC frameworks and data mining/retrieval, I am of a completely different opinion and I will discuss why.

By GodLikeMouse, 12 yearsJanuary 18, 2013 ago

Fixing Mysqldump Lock Tables Error

If you ever find yourself doing a mysqldump on a large database, you may end up seeing this error: If this happens, just re-run the mysqldump command and add the –skip-lock-tables flag: MySQL sometimes tries to incorrectly lock tables on the information_schema database.

By GodLikeMouse, 14 yearsJuly 29, 2011 ago