On 5/24/19 8:37 AM, Valerio Bozzolan via Cloud wrote:
Hello Thomas,
Just try to type 'mysql' instead of 'sql'. I don't know any
'sql' command.
Regards
On May 24, 2019 12:59:33 AM GMT+02:00, Maximilian Doerr
<maximilian.doerr(a)gmail.com> wrote:
> You may need to point the command to the location by calling an
> absolute path. Use “which sql” to figure out where the command is
> located.
>
> Cyberpower678
> English Wikipedia Account Creation Team
> English Wikipedia Administrator
> Global User Renamer
>
>> On May 23, 2019, at 18:57, Thomas Stieve
> <tomthirteen(a)email.arizona.edu> wrote:
>>
>> Also, my question for the webchat was about how to run commands using
> a bash file. I used to be able to run:
>>
>> sql enwiki_p 'select * from logging where log_title = "A.S._Roma"
and
> log_namespace = 0 and log_timestamp > 20160101000 and log_action =
> "move"' > A.S._Roma.txt;
>>
>> Now, I just just get command not found.
>>
You can read more about the `sql` command here:
https://wikitech.wikimedia.org/wiki/Help:Toolforge/Database#Connecting_to_t…
It's a custom wrapper aiming to ease interaction with the DB.
--
Arturo Borrero Gonzalez
Operations Engineer / Wikimedia Cloud Services
Wikimedia Foundation