Useful Snippets

Welcome!

This blog is used to collect useful snippets related to Linux, PHP, MySQL and more. Feel free to post comments with improvements or questions!

Are your smart devices spying on you? Make better purchasing choices and find products that respect your privacy at Unwanted.cloud

RSS Latest posts from my personal blog

Subscribe to RSS feed

RSS RSS feed

Copyright © Useful Snippets. 2025 • All rights reserved.

Cedar WordPress Theme by EckoThemes. Published with WordPress.

Import .tar.gz gzipped mysql dumps in one line

Stanislav KhromovStanislav Khromov 
tar -xzOf your_db_dump.sql.tar.gz | mysql -u USERNAME -pPASSWORD your_database

Source

Related posts

  1. Import zipped mysql dumps
  2. Dump all MySQL databases on a Linux server with a single line of bash
  3. Minimal privileges required for a MySQL backup user
  4. Dump and import a single MySQL database via command line
CentOS
Stanislav Khromov
Author

Full-stack impostor syndrome sufferer & Software Engineer at Schibsted Media Group

Comments 3
  • Max
    Posted on

    Max Max

    Reply Author

    Thx man!

  • ira youn
    Posted on

    ira youn ira youn

    Reply Author

    Top !

  • Leigh Bicknell
    Posted on

    Leigh Bicknell Leigh Bicknell

    Reply Author

    If this fails drop the –

    tar xzOf your_db_dump.sql.tar.gz | mysql -u USERNAME -pPASSWORD your_database