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.
Leave a Reply