things i’ve used recently: tar -zxvf file.tar.gz

mysql -u username -p password database_name < filename.sql

http://kb.mediatemple.net/questions/129/How+can+I+Backup+and+Restore+a+MySQL+database%3F