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 twoservers. 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 sqlbackups made by the automated script I use were completely useless causethey were dumped with characterset latin1 …. So everything which was in cp1251appeared 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.cnfoutlining 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!END—–
Posts Tagged ‘doubt’
To Lumier with a bike the yesterday “action”Monday, February 16th, 2009
Tags: action, bg, cause, characterset, coffee, corrupted data, databases, default character, doubt, dumps, everything, faith, god have mercy, Hallelujah, iconv, jesus christ son, level, lord jesus christ, Lumier, mysql server, php, place, poing, Praise, quot, recovery mode, Sali, second, sinner, time, winner, work, yesterday
Posted in Everyday Life | No Comments »
Mysqlreport a tiny script intended to make easy-to-read MySQL status reportsWednesday, February 13th, 2008
Check this out. Mysqlreport is a small script intended to Make easy-to-read MySQL status reports.It has also a nice manual explaining every variable it returns. Check it out here .From yesterday I feel a little sich just like I guess I’ve catched a flu. I’m still looking for a what kind of laptop to buy.
Everybody says a different thing.
A friend of mine who sells laptop says Gigabyte is a good choice, still I’m uncertain about that.I personally like Thinkpads but unfortunately thinkpads comes with OS installed on them and also I don’t like it that IBM Thinkpads (e.g. nowhere days Lenovo Thinkpads) at least the cheaper ones come with Integrated ATI video.
I’m thinking of a Dell as a possibility but still I’min doubt which one to take … For all those who doesn’t know IBM/Lenovo has three major series of Thinkpads the “r” series “t” series from Terminator :), and the “x” series. x series thinkpads are a way smaller than “r” and “t” series. As I’ve heard from friends and other sources online “t” series are rock solid and had a titanium backing. A good thing about Thinkpads to note is that the batter life of “r” and “z” series is 3.5 h 🙂 What I can afford is to spend no more than 1600 lv. (something like 1200 USD) for a laptop. The Dell models I liked were Inspiron 1520 but unfortunately they come with integrated wifi card which is dell and has no support for Linux/BSD (I need the computer to run FBSD/linux).Ofcourse I can always use NDIS and use the windows driver under linux/BSD but this is not the ideaEND—–
Tags: choice, dell, doubt, FBSD, ibm thinkpads, laptop, Linux, lv, make, models, NDIS, series thinkpads, series x, terminator, titanium, USD, wifi card, windows driver
Posted in MySQL, System Administration, Web and CMS | No Comments »
BSD tipsThursday, February 7th, 2008
On one of my previous posts I give an url to a great wiki. Unfortunately I have seen I have given a wrong linkhere is the mediawiki bsdtips.utcorp.net Today I have to go to a German classes. I’m in doubt what kind of laptop to take I doubt between IBM Thinkpad and Dell. IBM’s has ati where I prefer having nvidia. On the other hand I know not all of Dell’s hardware would probably work correctly in Linux and BSD. Another problem is IBM is being selled with preinstalled XP … END—–
Tags: doubt, ibm, kind, laptop, Linux, nvidia, problem, url, wiki, work
Posted in FreeBSD | No Comments »