Tag Archives: database

Updating WordPress mysql Database content After Moving to a new WebHost and URL

After moving a WordPress site to a new URL either live or to a development server, the new URL strings in the mysql database need to be updated in the various mysql tables. This method just uses the whole mysql database rather than a WordPress export/import from within, and is best suited for a straight [...]

Read more

Import a mysql database into OS X 10.6 via Terminal

Import a mysql database into OS X 10.6 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