Hello all,
mysql on z-dat-s4-a (that's the host that serves sql-s4 (aka commons) at the moment) crashed and does not recover as far as I see. So I switched sql-s4-rr and sql-s4-user to ther hosts which have also a copy of commons. The problem is now that the host that now serves sql-s4-user have no user-databases at the moment. I switched the server read/write so you can create databases there if you like.
For details see [1].
Sincerly, DaB.
[1] https://jira.toolserver.org/browse/MNT-1074
Hello, At Tuesday 23 August 2011 22:43:50 DaB. wrote:
So I switched sql-s4-rr and sql-s4-user to ther hosts which have also a copy of commons.
sorry, I forgot to mention: The switching killed every running mysql-query. Just if you wonder why your query was killed.
Sincerly, DaB.
Hello all,
it took a while, back I finaly managed to extract your user-databases of the crashed s4-server. You can find the dumps at /mnt/user-store/s4-user-dbs.backup/. Please take a look if you still need the data and -if yes: import them into the temporary s4-user-server and delete the dump-file afterwarts. -if no: just delete the dump-file.
The dump-files will vanish in 2 weeks from now.
Sincerly, DaB.
I do indeed want to restore these as my s4/commons-related tools are currently error-ing out with "Table 'u_krinkle.foobarcommons' doesn't exist" etc.
How do I restore them ? "$ sql u_krinkle" brings me to the u_krinkle of sql.toolserver.org, not of s4-user
-- Krinkle
2011/8/26 DaB. WP@daniel.baur4.info
Hello all,
it took a while, back I finaly managed to extract your user-databases of the crashed s4-server. You can find the dumps at /mnt/user-store/s4-user-dbs.backup/. Please take a look if you still need the data and -if yes: import them into the temporary s4-user-server and delete the dump-file afterwarts. -if no: just delete the dump-file.
The dump-files will vanish in 2 weeks from now.
Sincerly, DaB.
-- Userpage: [[:w:de:User:DaB.]] — PGP: 2B255885
Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette
Hello, At Saturday 27 August 2011 15:16:14 DaB. wrote:
How do I restore them ?
sorry, I forgot:
mysql -h sql-s4-user -e 'CREATE DATABASE u_krinkle;' (if you created already a database for you that will fail, but this is no problem)
gzcat u_krinkle.gz|mysql -h sql-s4-user u_krinkle (that will decompress the file on the fly and import the tables into the database which was created in step 1).
If you (or any other user) like, I can do the import for you; just send me a mail or ping me in the IRC.
Sincerly, DaB.
2011/8/27 DaB. WP@daniel.baur4.info
Hello, At Saturday 27 August 2011 15:16:14 DaB. wrote:
How do I restore them ?
sorry, I forgot:
mysql -h sql-s4-user -e 'CREATE DATABASE u_krinkle;' (if you created already a database for you that will fail, but this is no problem)
gzcat u_krinkle.gz|mysql -h sql-s4-user u_krinkle (that will decompress the file on the fly and import the tables into the database which was created in step 1).
Thanks DaB, that worked perfect. Tools are up and running again :)
-- Krinkle
toolserver-l@lists.wikimedia.org