How do I load a sql.gz file to my database? (importing)

Question

is this right?

mysql -uroot -ppassword mydb < myfile.sql.gz

Answer 1

Not, it isn't, the right would be:

zcat myfile.sql.gz | mysql -u root -p password mydb

Answer 2

tar -xzf myfile.tar.gz

Check the extracted sql files using: ls

mysql -u root -p password database < myfile.sql