Project

General

Profile

Actions

Demande #1071

closed

la base adhérent est corrompue et son contenu est restauré à partir d'une sauvegarde

Added by Loïc Dachary almost 12 years ago. Updated almost 12 years ago.

Status:
Fermé
Priority:
Immédiate
Assignee:
Category:
Story
Target version:
Start date:
12/03/2012
Due date:
12/14/2012
% Done:

100%

Estimated time:
Spent time:
Difficulté:
2 Facile

Description

TODO:

Actions #1

Updated by Loïc Dachary almost 12 years ago

  • Due date set to 12/14/2012
Actions #2

Updated by Loïc Dachary almost 12 years ago

  • Assignee deleted (Loïc Dachary)
Actions #3

Updated by Loïc Dachary almost 12 years ago

  • Status changed from En cours de traitement to Nouveau
Actions #4

Updated by Loïc Dachary almost 12 years ago

  • Target version changed from Décembre 2012 (1/2) to Backlog
Actions #5

Updated by Loïc Dachary almost 12 years ago

  • Target version changed from Backlog to Décembre 2012 (2/2)
Actions #6

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)

Actions #7

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
Actions #8

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
Actions #10

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

Actions #11

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
Actions #12

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

Also available in: Atom PDF