User:Mutante/wikivoyage pastebin

wikivoyage db imports

Since databases exist before import through addwiki, to really check what is done check the first user id's.

if (user_id=="Hansm") { echo "done"; } elseif (user_id=="Reedy") { echo "not yet"; }

loop

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 order by user_id limit 1'";
  done;
 done | tee wv_imports.check

status

db1003
de
user_id	user_name
2	Hansm
db1010
de
user_id	user_name
2	Hansm
db1035
de
user_id	user_name
2	Hansm
db1019
de
user_id	user_name
2	Hansm
db39
de
user_id	user_name
2	Hansm
db64
de
user_id	user_name
2	Hansm
db11
de
user_id	user_name
2	Hansm
db34
de
user_id	user_name
2	Hansm
db1003
en
user_id	user_name
2	Hansm
db1010
en
user_id	user_name
2	Hansm
db1035
en
user_id	user_name
2	Hansm
db1019
en
user_id	user_name
2	Hansm
db39
en
user_id	user_name
2	Hansm
db64
en
user_id	user_name
2	Hansm
db11
en
user_id	user_name
2	Hansm
db34
en
user_id	user_name
2	Hansm
db1003
fr
user_id	user_name
2	Hansm
db1010
fr
user_id	user_name
2	Hansm
db1035
fr
user_id	user_name
2	Hansm
db1019
fr
user_id	user_name
2	Hansm
db39
fr
user_id	user_name
2	Hansm
db64
fr
user_id	user_name
2	Hansm
db11
fr
user_id	user_name
2	Hansm
db34
fr
user_id	user_name
2	Hansm
db1003
it
user_id	user_name
2	Hansm
db1010
it
user_id	user_name
2	Hansm
db1035
it
user_id	user_name
2	Hansm
db1019
it
user_id	user_name
2	Hansm
db39
it
user_id	user_name
2	Hansm
db64
it
user_id	user_name
2	Hansm
db11
it
user_id	user_name
2	Hansm
db34
it
user_id	user_name
2	Hansm
db1003
nl
user_id	user_name
2	Hansm
db1010
nl
user_id	user_name
2	Hansm
db1035
nl
user_id	user_name
2	Hansm
db1019
nl
user_id	user_name
2	Hansm
db39
nl
user_id	user_name
2	Hansm
db64
nl
user_id	user_name
2	Hansm
db11
nl
user_id	user_name
2	Hansm
db34
nl
user_id	user_name
2	Hansm
db1003
ru
user_id	user_name
2	Hansm
db1010
ru
user_id	user_name
2	Hansm
db1035
ru
user_id	user_name
2	Hansm
db1019
ru
user_id	user_name
2	Hansm
db39
ru
user_id	user_name
2	Hansm
db64
ru
user_id	user_name
2	Hansm
db11
ru
user_id	user_name
2	Hansm
db34
ru
user_id	user_name
2	Hansm
db1003
sv
user_id	user_name
2	Hansm
db1010
sv
user_id	user_name
2	Hansm
db1035
sv
user_id	user_name
2	Hansm
db1019
sv
user_id	user_name
2	Hansm
db39
sv
user_id	user_name
2	Hansm
db64
sv
user_id	user_name
2	Hansm
db11
sv
user_id	user_name
2	Hansm
db34
sv
user_id	user_name
2	Hansm