Friday, wordpress backups, pmc edits

Wordpress local copy

  • configured mysqldump backup, following dreamhost wiki (added cron job manually instead of in panel).

edit local wp-config.php to use localhost. Get the database name, user name and password from the lines above it, which are used later.


define('DB_HOST', 'localhost');     // ...and the server MySQL is running on

create user: log in as root


mysql -u root -p

and create user


mysql> create database database_name
mysql> create user 'username'@'localhost' identified by 'password';
mysql> create database database_name
mysql> grant usage on *.* to username@localhost identified by 'password';
mysql> grant all privileges on database_name.* to username@localhost;
mysql> quit

yes you need the quotes around the password and the .* appended after database_name. Then can import the most recent dump.


mysql -u username -p database_name < mysqldump_file.sql

Install wordpress, configure. Set from /var/www to backup location, following any decent tutorial.

Manuscript edits

power_curve.R still running on farm. Run just the needed analysis. Done, updated data files. Runs much faster on farm then on zero, kinda amazing. Need these kind of explanatory figures? Removed.

Confidence intervals easy to get for each model, harder to squeeze into a nice table though.


 require(pmc)
 data(anoles_model_choice)
 confidenceIntervals.pow(bm_v_ou1)$test -> ou1_ci
 confidenceIntervals.pow(bm_v_ou1)$null -> bm_ci
 confidenceIntervals.pow(ouLP_v_half)$test -> ou15_ci
 confidenceIntervals.pow(ouLP_v_ouLP4)$null -> ou3_ci
 confidenceIntervals.pow(ouLP_v_ouLP4)$test -> ou4_ci

Application statement