Copy MySQL DB

You need to have (remote) access to both source and target host/database.

mysqldump -h source_host -u source_user -psource_password source_db | mysql -h target_host -u target_user -ptarget_password target_db

Note: there is no space between -psource_password or -ptarget_password

Tarball

Compress /directory/to/compress into archived.tar.gz

tar -zcf archived.tar.gz /directory/to/compress

Uncompress archived.tar.gz

tar -zxf archived.tar.gz

Uncompress archived.tar.gz into /directory/to/uncompress. /directory/to/uncompress need to exist.

tar -zxf archived.tar.gz -C /directory/to/uncompress/