Skip to content

Instantly share code, notes, and snippets.

@yumyo
Last active December 16, 2015 08:19
Show Gist options
  • Save yumyo/5405188 to your computer and use it in GitHub Desktop.
Save yumyo/5405188 to your computer and use it in GitHub Desktop.
WP install w/ Terminal
/* RESTORE DUMP */
mysql -u #username# -p #database# < #dump_file#
/* END RESTORE DUMP */
wget http://wordpress.org/latest.tar.gz
tar xfz latest.tar.gz
mv wordpress/* ./
rmdir ./wordpress/
rm -f latest.tar.gz
DB PART
mysql -u username -p
create database dbname;
mysql> create user 'dbusername'@'localhost' identified by 'password';
grant usage on *.* to username@localhost identified by 'password';
grant all privileges on dbname.* to username@localhost;
test with:
use dbname;
/Applications/MAMP/Library/bin/mysqldump -h 000.00.00.000 -u db_user -p db_name > ~/db-backbup.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment