User:Dzahn/wikivoyage pastebin
From Wikitech
< User:Dzahn(Difference between revisions)
(Created page with "=== 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" then done elsei...") |
(→loop) |
||
| Line 6: | Line 6: | ||
==== loop ==== | ==== loop ==== | ||
<pre> | <pre> | ||
| − | 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 | + | 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 | ||
</pre> | </pre> | ||
Revision as of 17:33, 9 November 2012
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" then done elseif user_id=="Reedy" then not done. :)
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 1 Reedy db1019 de user_id user_name 1 Reedy db39 de user_id user_name 1 Reedy db64 de user_id user_name 1 Reedy db11 de user_id user_name 1 Reedy db34 de user_id user_name 1 Reedy 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
