Essential Books

restore a gzipped mysqldump file without uncompressing

suggest change 
gunzip -c dbname.sql.gz | mysql dbname -u username -p

Note: -c means write output to stdout.

Found a mistake? Have a question or improvement idea? Let me know.

Feedback about page:

Feedback:
Optional: your email if you want me to get back to you:

Backup using mysqldump:
*Backup using mysqldump
*Specifying username and password
*Creating a backup of a database or table
*Restoring a backup of a database or table
*mysqldump from a remote server with compression
*restore a gzipped mysqldump file without uncompressing
*Backup direct to Amazon S3 with compression
*Tranferring data from one MySQL server to another
*Backup database with stored procedures and functions
Table Of Contents