Go to the location on your server where your file is using cd command
cd /var/www
pwd
$ mysql -u root -h localhost -p -Bse 'show databases'
To dump your database:
$ mysqldump -u root -h localhost -pmypassword faqs | database_name -9 > database_name.sql
To import your database:
mysql -u user -ppassword --default-character-set=utf8 database < "database_name.sql"
If you have a zip file you need to unzip it
gunzip name_file
Links
[1] https://dominiquedecooman.com/blog-topics/linux-0
[2] https://dominiquedecooman.com/blog-topics/import
[3] https://dominiquedecooman.com/blog-topics/export