Category: MySQL

Vagrant up errors on install on Mac OS X

Instead of MAMP I use Vagrant to set up my virtualhosts locally. That way you can emulate your webserver's setup. To configure my Vagrant virtual machine I use PuPHPet. You need to have VirtualBox installed for this. After downloading the  PuPHPet configuration manifest you need to start up the virtual box. You do this by executing … Continue reading Vagrant up errors on install on Mac OS X

MySQL replace function – Find and replace values in database with sql

A great piece of sql that can save you a lot of time. The replace sql function finds and replaces values in a database. Just fill in the table_name, table_field, the value your searching for and with which value you want to replace it with. UPDATE table_name SET table_field = REPLACE(table_field, 'value', 'new_value') WHERE my_field … Continue reading MySQL replace function – Find and replace values in database with sql