Dumping and importing mysql databases to/from files is pretty quick and easy to do from the command line:
dump db to file: mysqldump -u username -p databasename > dumpfile.sql
import db from file: mysql -u username -p databasename < dumpfile.sql
Archive for February, 2012
Dump and import mysql databases to/from file
Sunday, February 26th, 2012Add wordpress blog to cakephp app
Thursday, February 23rd, 2012Adding a wordpress blog within a cakephp app was easily done by copying the blog into the webroot directory of the app and updating the .htaccess file in the root of the app…for details see http://planetcakephp.org/aggregator/items/1370-wordpress-into-cakephp-the-right-way
Deploy a wordpress blog
Saturday, February 18th, 2012Deploying a wordpress blog is pretty straight-forward…although it does required a few changes in the admin panel or directly in the database before moving the site. A pretty comprehensive list of scenarios is covered here http://codex.wordpress.org/Moving_WordPress.