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!

RSS Latest posts from my personal blog


Most viewed posts


Subscribe to RSS feed


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

Web Developer at Aftonbladet (Schibsted Media Group)
Any opinions on this blog are my own and do not reflect the views of my employer.
LinkedIn
Twitter
WordPress.org Profile
Visit my other blog

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