Jump to content

User:Mutante/wikivoyage check

From Wikitech
dzahn@fenari:~$ for lang in de en fr it nl ru sv; do   for dbhost in db1003 db1010 db1035 db1019 db39 db64 db11 db34;
 do   ssh root@${dbhost} -C "hostname; echo $lang; 
  mysql ${lang}wikivoyage -e 'select user_id,user_name from user where user_id='3''";   done;  done | tee wvroland

db1003
de
user_id	user_name
3	Hoo man
db1010
de
user_id	user_name
3	Hoo man
db1035
de
user_id	user_name
3	Hoo man
db1019
de
user_id	user_name
3	Hoo man
db39
de
user_id	user_name
3	Hoo man
db64
de
user_id	user_name
3	Hoo man
db11
de
user_id	user_name
3	Hoo man
db34
de
user_id	user_name
3	Hoo man
db1003
en
user_id	user_name
3	Unger
db1010
en
user_id	user_name
3	Unger
db1035
en
user_id	user_name
3	Unger
db1019
en
user_id	user_name
3	Unger
db39
en
user_id	user_name
3	Unger
db64
en
user_id	user_name
3	Unger
db11
en
user_id	user_name
3	Unger
db34
en
user_id	user_name
3	Unger
db1003
fr
user_id	user_name
3	Unger
db1010
fr
user_id	user_name
3	Unger
db1035
fr
user_id	user_name
3	Unger
db1019
fr
user_id	user_name
3	Unger
db39
fr
user_id	user_name
3	Unger
db64
fr
user_id	user_name
3	Unger
db11
fr
user_id	user_name
3	Unger
db34
fr
user_id	user_name
3	Unger
db1003
it
user_id	user_name
3	Unger
db1010
it
user_id	user_name
3	Unger
db1035
it
user_id	user_name
3	Unger
db1019
it
user_id	user_name
3	Unger
db39
it
user_id	user_name
3	Unger
db64
it
user_id	user_name
3	Unger
db11
it
user_id	user_name
3	Unger
db34
it
user_id	user_name
3	Unger
db1003
nl
user_id	user_name
3	Unger
db1010
nl
user_id	user_name
3	Unger
db1035
nl
user_id	user_name
3	Unger
db1019
nl
user_id	user_name
3	Unger
db39
nl
user_id	user_name
3	Unger
db64
nl
user_id	user_name
3	Unger
db11
nl
user_id	user_name
3	Unger
db34
nl
user_id	user_name
3	Unger
db1003
ru
user_id	user_name
3	Unger
db1010
ru
user_id	user_name
3	Unger
db1035
ru
user_id	user_name
3	Unger
db1019
ru
user_id	user_name
3	Unger
db39
ru
user_id	user_name
3	Unger
db64
ru
user_id	user_name
3	Unger
db11
ru
user_id	user_name
3	Unger
db34
ru
user_id	user_name
3	Unger
db1003
sv
user_id	user_name
3	Unger
db1010
sv
user_id	user_name
3	Unger
db1035
sv
user_id	user_name
3	Unger
db1019
sv
user_id	user_name
3	Unger
db39
sv
user_id	user_name
3	Unger
db64
sv
user_id	user_name
3	Unger
db11
sv
user_id	user_name
3	Unger
db34
sv
user_id	user_name
3	Unger