After migrating a WordPress site to a new URL either live or to a production or development server, the new URL strings in the mysql database need to be changed and updated in the various mysql database tables. To avoid working directly in the database you can also to this in a gui style interface with …
Read More
Import a mysql database into OS X 10.8 via Terminal
Import a mysql database into OS X 10.8 I have found that phpmydmin on the Mac has issues with the max upload file size limit and changing the value in php.ini doesn’t always do the trick. Since mysql is already installed a quick trip to the terminal will sort this out. Create the database if …
Read More
How to backup your WordPress mysql database
One of the crucial components of a WordPress site is the database and it should be backed up on a regular basis to avoid the misfortune of the database becoming corrupt, hacked or deleted. WordPress uses a mysql database, which can be managed by the mysql commands on a command line or by phpMyAdmin through …
Read More