gunzip and mysql import - No such file or directory

Question

I have created a bash script for the automation of my database restore. When I run the following commands, I get /my/sql/file/path.sql: No such file or directory.

ssh $USER@"$cloneMysqlHost" gunzip /path/file.sql.gz && MySQL -u root -p db_name < /path/file.sql 

I did an ls -lrot on the host I ssh to, just to make sure the file exists the permissions are correct, and they are.

Any ideas what I'm doing wrong?

Thanks in advance!

Answer 1

The && is causing the local shell to split the command and run the MySQL command locally.

The < redirection is also being done locally (and the cause of your error).

The gunzip is being performed on the remote host though.

You need to quote the entire argument to ssh if you want it all run on the remote system.

ssh "$USER@$cloneMysqlHost" 'gunzip /path/file.sql.gz && MySQL -u root -p db_name < /path/file.sql'

Answer 2

Are you providing the password properly? Also, not sure what's going on with the &&, should use a pipe there. MySql is probably not valid, use mysql. See here for more details.

ssh $USER@"$cloneMysqlHost" gunzip /path/file.sql.gz | mysql -u root -p [password] db_name