Actions
Demande #1071
closedla base adhérent est corrompue et son contenu est restauré à partir d'une sauvegarde
Difficulté:
2 Facile
Description
- documenté dans http://127.0.0.1:8080/dokuwiki/doku.php?id=sysadm:dtc
- installé sur http://127.0.0.1:8080/dokuwiki/doku.php?id=sysadm:machines_virtuelles:ns1:lsd
TODO:
installer http://gna.org/projects/gdtc sur une machine de testcharger un dump de la base adhérents
Updated by Loïc Dachary almost 12 years ago
- Status changed from En cours de traitement to Nouveau
Updated by Loïc Dachary almost 12 years ago
- Target version changed from Décembre 2012 (1/2) to Backlog
Updated by Loïc Dachary almost 12 years ago
- Target version changed from Backlog to Décembre 2012 (2/2)
Updated by Loïc Dachary almost 12 years ago
loic@bet:~$ ssh -t -A root@ns1.april.org vserver lsd enter # april.org root@lsd:/# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 118577 Server version: 5.1.63-0+squeeze1 (Debian) Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | drupal6 | | dtc | | gdtc-dev | | mysql | +--------------------+ 5 rows in set (0.02 sec)
Updated by Loïc Dachary almost 12 years ago
(10:54:31 PM) benj: dachary: wiii ? (10:55:50 PM) dachary: je vais me pencher sur le scenario de restauration de la base adhérent a partir d'une sauvegarde, en cas de catastrophe (10:56:10 PM) dachary: est-ce que tu aurais quelque pointeurs a me conseiller pour y parvenir ? (10:56:37 PM) dachary: je suppose que le plus simple consiste a repartir d'un backup de lsd (10:57:09 PM) dachary: mais je n'ai aucune idée, une fois le backup restauré, de la façon dont je peux m'assurer que la base adhérent est ok (10:57:56 PM) dachary: je suis tenté de faire l'expérience dans une machine virtuelle, juste pour voir (10:58:29 PM) dachary: mais je crains que des cron ne fassent des interactions avec l'exterieur et que ça interfere avec le fonctionnement du vrai site (10:58:35 PM) dachary: benj: ^ (10:59:15 PM) dachary: c'est notre responsable produit qui est inquiet de sa base adhérent. Elle lui tient a coeur. Je le comprend un peu ;-) theocrite theo_taf (11:46:47 PM) benj: moi j'ai envie de dire, dump sql ? :) (11:56:10 PM) dachary: benj: oui :-) Mais quelle sorte de vérification je peux faire *apres* restauration pour valider qu'elle est ok ? (11:56:53 PM) benj: le test simple c'est par ex. d'utiliser dtcmanager en ligne de commande (11:56:57 PM) benj: pour faire un test (11:57:05 PM) benj: genre (11:58:34 PM) benj: « /var/www/adherents.april.org/htdocs/scripts/dtcmanager spamtest confirmation-adhesion-personne-1 ldachary » (11:58:51 PM) benj: ça devrait cracher un truc comme quoi il t'enverrait tel email (11:58:53 PM) benj: ça valide pas mal de choses
Updated by Loïc Dachary almost 12 years ago
- Status changed from Nouveau to En cours de traitement
- Assignee set to Loïc Dachary
TODO:
- installer http://gna.org/projects/gdtc sur une machine de test
- charger un dump de la base adhérents
- /var/www/adherents.april.org/htdocs/scripts/dtcmanager spamtest confirmation-adhesion-personne-1 ldachary
Updated by Loïc Dachary almost 12 years ago
Updated by Loïc Dachary almost 12 years ago
ajout des instructions de restauration dans http://127.0.0.1:8080/dokuwiki/doku.php?id=sysadm:dtc et test
Updated by Loïc Dachary almost 12 years ago
# myisamchk /var/lib/mysql/dtc/*.MYI Checking MyISAM file: /var/lib/mysql/dtc/actor.MYI Data records: 7691 Deleted blocks: 1 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check data record references index: 2 - check record links --------- Checking MyISAM file: /var/lib/mysql/dtc/april_position.MYI Data records: 15 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check record links --------- Checking MyISAM file: /var/lib/mysql/dtc/benevalo.MYI Data records: 4172 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check record links --------- Checking MyISAM file: /var/lib/mysql/dtc/contact.MYI Data records: 1115245 Deleted blocks: 403 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check data record references index: 2 - check data record references index: 3 - check data record references index: 4 - check record links --------- Checking MyISAM file: /var/lib/mysql/dtc/employee.MYI Data records: 657 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check record links --------- Checking MyISAM file: /var/lib/mysql/dtc/entity.MYI Data records: 637 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check data record references index: 2 - check data record references index: 3 - check record links --------- Checking MyISAM file: /var/lib/mysql/dtc/entity_type.MYI Data records: 6 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check data record references index: 2 - check record links --------- Checking MyISAM file: /var/lib/mysql/dtc/indicateurs_2009.MYI Data records: 409 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check record links --------- Checking MyISAM file: /var/lib/mysql/dtc/indicateurs.MYI Data records: 550 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check record links --------- Checking MyISAM file: /var/lib/mysql/dtc/mail_macro.MYI Data records: 38 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check record links --------- Checking MyISAM file: /var/lib/mysql/dtc/mail_template.MYI Data records: 56 Deleted blocks: 24 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check data record references index: 2 - check data record references index: 3 - check record links --------- Checking MyISAM file: /var/lib/mysql/dtc/membership.MYI Data records: 7203 Deleted blocks: 2 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check data record references index: 2 - check record links --------- Checking MyISAM file: /var/lib/mysql/dtc/modification.MYI Data records: 538778 Deleted blocks: 389 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check record links --------- Checking MyISAM file: /var/lib/mysql/dtc/person.MYI Data records: 7054 Deleted blocks: 2184 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check data record references index: 2 - check data record references index: 3 - check record links --------- Checking MyISAM file: /var/lib/mysql/dtc/questionnaire.MYI Data records: 6175 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check data record references index: 2 - check record links --------- Checking MyISAM file: /var/lib/mysql/dtc/saved_search.MYI Data records: 12 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check record links --------- Checking MyISAM file: /var/lib/mysql/dtc/subscription.MYI Data records: 20907 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check data record references index: 2 - check record links
Updated by Loïc Dachary almost 12 years ago
- Status changed from En cours de traitement to Fermé
- % Done changed from 0 to 100
Actions