Pipe gunzip and mysql to gunzip a dump and import it

Question

How can font-awesome be upgraded for shiny on a mac?

Here it is for windows

shinydashboard some Font Awesome Icons Not Working

However I couldn't find any folders resembling the windows solution on the mac.

Solution 1

zcat foo.sql.gz | mysql -uroot -ppassword foo

This will also leave foo.sql.gz as it is.

Solution 2

For those on Max OSX there is a bug with zcat so you'll need to use gzcat instead.

gzcat foo.sql.gz | mysql -uroot -ppassword foo

Solution 3

All other answers are recommending writing the password in the command. This is a very bad practice and poses security risks. Please DON'T DO that.

You can leave the password empty in the command, than it will ask you to enter the password interactively. This way the password is not saved in the bash history.

gunzip < dump.sql.gz | mysql -u username -p databasename

Comments

[thefreeman]

FYI you really do not want to pass the mysql password on the command line. This leads to it being stored in ~/.bash_history for all to see. If you just put -p it will prompt you to enter your password which is much safer (and doesn't break the zcat pipe either)

[iacnats]

You orignal command would work if gunzip < foo.sql.gz | mysql -uroot -ppassword foo

[podarok]

In terms of speed this works much more slower than gunzip && mysql -e "use unzipped.sql".