How to upload a mysql database from a sql.gz file

If you find this free website useful – why don’t you support this with a donation? It is easy…. read more ….

How to upload a database from a database.sql.gz file.  For instance c-panel databse backup can create this file and you might want to use it up upload to a test system or when moving server

zcat  database.sql.gz | mysql -u username -p -h localhost databasename
password:

Executing this command line in the shell on your server will do the trick.