User:Dzahn/wikivoyage pastebin
From Wikitech
< User:Dzahn(Difference between revisions)
(→status: update and DONE :)) |
m (syntax;)) |
||
| Line 2: | Line 2: | ||
Since databases exist before import through addwiki, to really check what is done check the first user id's. | Since databases exist before import through addwiki, to really check what is done check the first user id's. | ||
| − | if user_id="Hansm" | + | if (user_id=="Hansm") { echo "done"; } elseif (user_id=="Reedy") { echo "not yet"; } |
==== loop ==== | ==== loop ==== | ||
Latest revision as of 04:23, 10 November 2012
[edit] 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"; }
[edit] 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
[edit] 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
