Re: [Savannah-hackers] FIXED!!! Screwing up the database

[Hugo Gayosso]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

address@hidden writes:

> Hugo Gayosso writes:
>  > -----BEGIN PGP SIGNED MESSAGE-----
>  > Hash: SHA1
>  > 
>  > Ok, finally I fixed it.
>  > 
>  > Now we have an expert in disaster recoveries for Savannah!!!
>  > 
> 
>       Could you described how your recovered ? I'll double check, just
> to have another eye on the recovery and learn from it.

[...]

It was a manual procedure at the beginning and then a semi-automatic
procedure.

I extracted (cat | grep) from the dumps all the lines that related to
user_group_id.

These lines were basically "INSERT INTO", after a "CREATE TABLE", so
it was pretty easy to understand what they were.


I processed these lines (via Emacs, awk and grep) to get the
user_group_id where the admin_flags were empty (''), I saved those
numbers into a text file. Then I executed an UPDATE command on each of
these numbers to update admin_flags to the proper value.

I repeated the process for admin_flags that were "A".

I checked with my own projects and with some other that I was familiar
with.

If more details are needed, let me know.

Greetings,
- -- 
Hugo Gayosso
Support the Free Software
Support the GNU Project 
http://www.gnu.org
http://wildebeest.penguinpowered.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.4 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE6xpFlMNObVRBZveYRAqgWAJwPvlBa2SnpEQXmmjDAW7mo1PaP9gCfYS+h
eh1JNxpapc/G11WTCVa2dw0=
=NgQB
-----END PGP SIGNATURE-----