[support] drush sql-query returns nothing
Tim Johnson
tim at akwebsoft.com
Mon Nov 4 20:23:46 UTC 2013
* Tim Johnson <tim at akwebsoft.com> [131104 10:53]:
> I am using drush 5.8 on Mac OSX
>
> drush sql-query returns nothing at all, can't see to get any
> response whatsoever if I run (as example)
> drush sql-query "show tables;" from sites/default
>
> the only response I can get is if I run the command above from
> above/outside the site root - and that is the "No database to
> operate on." error..
>
> could be a very handy feature of drush for me, but I'm clueless on
> how to make it work and `drush help sql-query` doesn't provide me
> with any clues as where to execute from...
Sorry, I should have included more of a demonstration of the issue
..
from my user root :
bash-3.2$ drush sql-query 'show table;'
No database to operate on.
To be expected...
from my site root - deliberate error
/Users/http/sites/akwebsoft
bash-3.2$ drush sql-query 'show nothing;'
ERROR 1064 (42000) at line 1: You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server
version for the right syntax to use near 'nothing' at line 1
Also to be expected
now a valid command :
bash-3.2$ drush sql-query 'show tables;'
bash-3.2$
Where's the output??
--
Tim
tim at tee jay forty nine dot com or akwebsoft dot com
http://www.akwebsoft.com, http://www.tj49.com
More information about the support
mailing list