Im trying to run run write a command where I can execute remote queries stored local.
I was trying:
drush @remote.master sqlq < src/sql/data.sql
but no luck, also tried the option --file=path/to/file but it's only for remote files :(
Any ideas?
1
-
"but no luck" - please explain. What you expected to happen? What really happened?– MołotAug 13, 2015 at 15:39
Add a comment
|
2 Answers
Try this:
cat src/sql/data.sql | drush @remote.master sql-cli
answered Aug 13, 2015 at 16:31
-
This work, but: 1. You need to add:
'ssh-options' => '-t'to drush alias 2. You need to add:;and new line at the end of you sql files Thanks! I can't put line breacks on this box!!!!– NahAug 14, 2015 at 10:40 -
Any idea how I could concatenate the
;\nat the end, on the same command so I can have "clean" sql files?– NahAug 14, 2015 at 10:48 -
forget about -t option, the message
Pseudo-terminal will not be allocated because stdin is not a terminal.don't interfere with the sql actually excecuting, but -t option it mess with other drush works. Just remember to add ; at the end of sql.– NahAug 14, 2015 at 11:39 -
Not sure why your source sql file would be missing a trailing
;if the remote side needs it, but you could always add one on via(cat src/sql/data.sql && echo ";") | drush ...if you needed to. Aug 14, 2015 at 13:13
you should try with other command:
drush sql-sync --source-dump=src/sql/data.sql --target-db-url=mysql://remoteusername:remotepass@remoteserver/remotedatabase
answered Aug 13, 2015 at 16:24
-
can't use that solution as I don't have direct access to mysql, but trough drush aliased ssh connection :(– NahAug 14, 2015 at 10:45
-
In that case, I think the best is copy the dump via SCP and restore it. Aug 17, 2015 at 11:51