Import a tar.gz file to MySQL

import-tar-gz.sh

tar xOf dump.sql.tar.gz | mysql -u $user -p $database

I don't think you need the z when extracting:

In extract or list modes, this option is ignored.

Thanks, maybe this changed somewhere in time, I learned the options once and never looked it again

👍 I hear that! Really useful so thanks for posting.

Came back to this yet again to figure out how to do this.

I thought I would add this method to obtain the estimated progress and completion time:

1. Install pv. On macOS, you can do brew install pv.

2. pv dump.sql.tar.gz | tar xO | mysql -u $user -p $database

And you'll get a real-time output like this:

Simple and effective:
zcat dump.sql.tar.gz | mysql -u $user -p $database

zcat is cat equivalent that also decompresses archive.

On OSX zcat might not work like that, you need zcat < dump.sql.tar.gz | mysql -u $user -p $database