[IMPORT]
mysql -u username -p db_name < db_name.sql

[EXPORT]
mysqldump --user=username --password db_name > db_name.sql


[LOCALHOST -> REMOTEHOST]
scp -r domain.com user@domain.com:
rsync -rc  /home/localhost_username/domain.com/ username@domain.com:/home/username/public_html

[REMOTEHOST -> LOCALHOST]
scp -r emma@domain.com:pulic_html/ domain.com
rsync -rc  username@domain.com:/home/username/public_html/ /home/localhost_username/domain.com/


[PERMISSIONS]
grant all privileges on db_name.* to 'username'@'localhost' identified by 'password';