To Lumier with a bike the yesterday "action"
Saturday was quite shaking. The morning start yearly around 8:30.
Anton a friend of mine for whom I am working and for whom I am
admining two servers. Called yearly in the morning and informed me
that winner.bg is not working for several hours. I logged on the
server and tried to see what's wrong. It seemed that the whole
MySQL was quite messy. It even refuses to start. There were
corrupted data the system seemed to be restarted twice. I won't
enter into much details here just put some moral mostly. I was
desperate things looked like everything was lost. The old sql
backups made by the automated script I use were completely useless
cause they were dumped with characterset latin1 .... So everything
which was in cp1251 appeared like "?" questionmarks. I thought
there was encoding problem and the problem might be solved with
iconv, however unfortunately that was not the case. The dumps were
completely useless. So as a prescription if you use cp1251 or koi8r
or any cyrillic encoding and you've explicitly definition in
/etc/my.cnf outlining that be sure not to dump with
--default-character-set=latin1 ! Never ever! do this. At a moment I
felt completely forgotten by God doubt came along for a second,
nevertheless I started praying even though only with hope and
without faith enough I screamed "Lord Jesus Christ, Son of the
Blessed God, have mercy on me the sinner!". Eventually until 16:45
most of the problems were fixed. Praise the Lord! Hallelujah! I
could see one more time clearly God fixing things for me. To be
honest I was so messed at a poing before all came to its place that
I was not knowing exactly what I am doing. I followed a couple of
steps one of which was completely unsinstall the mysql server and
exchange it with 5.0.75 from 5.0.65. I had to switch to innodb
recovery mode level 4 and dump some of the databases and import
them back. A lot of the databases I simply copied in binary format
to the newly created sql server. The sql server started working
again ! Blessed be God My helped and refugee! I did some shopping
on Saturday 5:30 'till 18:00. Then I tried to recover the databaess
with the screwed cyrillic letters. I had to contact ganchev
"shudder" a friend of mine who is pretty good in coding and worked
at the same company I did for some years. He couldn't help however
he advised me to check the dumps with hexdump -C and see if the "?"
questionmarks are questionmarks. In my case they were so the
backups were completely useless. I was lucky that one of the
database my friend Tony has backed up and the other one was for a
website who was started just a few days before so data there could
be recovered with a little effort and it's not gonna be so fatal I
guess. Later on during the evening I updated a couple of services
like apache php eaccelerator and so on on the two freebsd servers I
take care for. On the Sunday morning I had to fix a little thing a
consequence from the nightly update. The php5-gd port didn't
upgraded with the portupgrade -ri cause according to portaudit it
has a security flaw. However quite flashy and luckily I fixed the
problem. The rest of the Sunday I spend in talks with Paco, then we
went to Sali and went to Lumiere the coffee restaurant where Sali
managed to arrange work for Papi. The idea of us going there was to
negotiate if possible to increase Papi's daily sallary cause today
he receives only 20 EUR per day for 10 hours of work. We went to
Lumiere with Bikes that Sali gave us. On our way Papi fall off his
bike and hurt his leg badly ...
We went there
and drinked coffee, thanks God they didn't charged me for the
coffee because the restaurant owners (Aidyn and Tazira) said the
coffee I don't need to pay for. After that we went back home we had
small argue with Papi for which I deeply regret. I should thanks
God for granting me from his divine mercy and doing so much for me
the sinner. Quite in a few minutes I'll be praying a bit and going
to bed. Let's hope that the Lord will be blessing me and helping me
in my work and studies in the coming week just like he did so far.
Just to conclude my post. Glory be to you Almighty and all merciful
Lord my stronghold and my refugee! Hallelujah!