MySQL Wrangling

change_urls.sql

-- handy for moving a database from prouction to your local environment.
-- change URL's in wordpress single-site install.  Replace with your own URL's.
-- this doesn't address serialized options.

UPDATE wp_options SET option_value = "http://localhost:8888" WHERE option_name = "home";
UPDATE wp_options SET option_value = "http://localhost:8888" WHERE option_name = "siteurl";
update wp_postmeta set meta_value = replace(meta_value, 'http://example.com', 'http://localhost:8888') where meta_key='_menu_item_url';
update wp_posts set post_content = replace(post_content, 'http://example.com', 'http://localhost:8888');

wrangle.mysql.sql

-- Export a mysql database from the commandline:
-- That chararacter set stuff isn't always needed (most SQL databases are 
mysqldump [database] --opt -u [username] --password='[password]'  --default-character-set=latin1 -N > [filename]

I use this to create a backup script on my development environment. Whenever I make a major change to a database, I like to back it up first.