Terminal commands for migrating sites

migrate.markdown

Dump a MySQL database to a file

mysqldump -h example.com -u username -p database > file.sql

Import sql file into MySQL

mysql -u username -p
mysql: source file.sql

Compress a directory into a tar file and maintain permissions

tar -pczf files.tar.gz directory

Copy file to remote server over ssh

scp file.tar.gz username@example.com:/path/to/save/file.tar.gz

Expand compressed file

tar -xvzf file.tar.gz