Connection Database Problem - Cara Repair

Symptom:

Connection Problems

Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.



Show Recent Messages (F3)

saiya: kat p*t*n m*n*a ade error Error: The requested address '/' was not found on this server. ni ker?
Azril Nazli Alias: database down
Azril Nazli Alias: kena restart mysqld
Azril Nazli Alias: /sbin/service mysqld restart
saiya: ok ok aku wat kan tp ajar aku
Azril Nazli Alias: ssh masuk ke ph1
saiya: aku da masuk da ph1
Azril Nazli Alias: taip whoami
Azril Nazli Alias: bagitau aku apa status
saiya: www
Azril Nazli Alias: ko kena login as root
Azril Nazli Alias: taip su
Azril Nazli Alias: letak password root
saiya: ok da suda
Azril Nazli Alias: taip /sbin/service mysqld restart
Azril Nazli Alias: dia tulis apa kat screen ?
saiya: stopping mysql [ok]
Azril Nazli Alias: ok
Azril Nazli Alias: starting cemana
saiya: starting failed
Azril Nazli Alias: ko taip nih
Azril Nazli Alias: reboot
Azril Nazli Alias: reboot terus server
saiya: ok da reboot
Azril Nazli Alias: dah ready
saiya: ok da ready
Azril Nazli Alias: ok masuk sebagai root
saiya: ok da root dah
Azril Nazli Alias: skrg turn off database
Azril Nazli Alias: /sbin/service mysqld stop
saiya: ok
saiya: stopping mysql... [OK]
Azril Nazli Alias: try run
Azril Nazli Alias: /sbin/service mysqld start
saiya: failed
saiya: Timeout error occurred trying to start MySQL Daemon.
Azril Nazli Alias: ada
Azril Nazli Alias: cd /var/lib/mysql
saiya: boleh
Azril Nazli Alias: boleh ?
Azril Nazli Alias: ls
Azril Nazli Alias: apa folder yg ada
saiya: A**
g***
m****
p****m
a***n
p*t*nm*n*a_2009
p*t*nc**s_db

dan banyak lagi perkara dlm ni..

Azril Nazli Alias: cd p*t*nm*n*a_2009
saiya: ok boleh

Azril Nazli Alias: try myisamchk -r *.MYI
Azril Nazli Alias: kalau diam..maksudnya dah repair
saiya: file index ape tah
saiya: fixing index
Azril Nazli Alias: ohh dia tgh repair
saiya: recovering
saiya: ok dah
Azril Nazli Alias: cun
Azril Nazli Alias: cd ../p*t*nc**s_db (ok ni maksudnya patah balik folder belakang dan masuk folderbaru) contoh dia akan jd cam ni ler sama jugak
cd /var/lib/mysql/p*t*nm*n*a_2009 (folder asal)
cd /var/lib/mysql/p*t*nc**s_db (nak masuk folder ni)

saiya: ok
Azril Nazli Alias: myisamchk *.MYI
saiya: oo wat lagi skali ek
saiya: nak ade -r tak
Azril Nazli Alias: command nih akan repair semua fail ending dgn .MYI
Azril Nazli Alias: ada
Azril Nazli Alias: -r maksudnya auto repair
saiya: myisamchk -r *.MYI
Azril Nazli Alias: lepas r ada jarak
saiya: recovering
Azril Nazli Alias: ok cun
saiya: fixing index 1
Azril Nazli Alias: sure seronok tengok kan
Azril Nazli Alias: dia tgh repair
saiya: ha'ah
saiya: nampak nombor bergerak2
saiya: - recovering (with sort) MyISAM-table 'smf_messages.MYI'
Data records: 244037
- Fixing index 1
Found block that points outside data file at 79740844
Found block that points outside data file at 79740852
Found block that points outside data file at 79740864
- Fixing index 2
- Fixing index 3
- Fixing index 4
244000

Azril Nazli Alias: nanti bila ko free..aku ajar ko create databae, backup database
saiya: mcm2 dia repair
saiya: ok cun.. sbb skarang ni pun aku tgh install vmware...
saiya: aku nak install centos dlm tu
Azril Nazli Alias: ok
Azril Nazli Alias: centos...fedoracore laa senang
Azril Nazli Alias: ko nak belajar cakephp pun aku leh ajar
saiya: ok da siap repair
Azril Nazli Alias: ok skrg start db
Azril Nazli Alias: /sbin/service mysqld start
Azril Nazli Alias: command tu untuk start database mysql daemon
saiya: command tu taip kat mana2 pun bleh ek
saiya: Starting MySQL: [ OK ]

Azril Nazli Alias: yup boleh
saiya: tapi kat http://ad.p*t*m*a.com/ masih sama
Azril Nazli Alias: ok
Azril Nazli Alias: killall mysqld
Azril Nazli Alias: taip tu
Azril Nazli Alias: pastu taip mysqld start balik
saiya: ok
saiya: msqld: no process killed

Azril Nazli Alias: ok skrg taip nih
Azril Nazli Alias: mysql -u -p p*t*n*a_2009
saiya: sama ar ERROR 1040 (00000): Too many connections

Azril Nazli Alias: ok
Azril Nazli Alias: skrg try reboot
Azril Nazli Alias: tunggu 10 minit
Azril Nazli Alias: sebab kita dah repair database
Azril Nazli Alias: kita reboot server
saiya: ok
Azril Nazli Alias: server tuh dah tahap kokah
Azril Nazli Alias: kokak
Azril Nazli Alias: zaman 1990an nyer server kot
saiya: erm agaknyr la
Azril Nazli Alias: ker awal 2000
Azril Nazli Alias is using a different version of Yahoo! Messenger. Certain features may be unavailable.

saiya: aha.. dah nampak dah
Azril Nazli Alias: ok done
Azril Nazli Alias: simpan dalam nota
Azril Nazli Alias: sebab aku rasa server nih dah nyawa nyawa ikan
saiya: apemenda yang berlaku tadi
Azril Nazli Alias: skrg aku nak ko backup database aku
Azril Nazli Alias: tapi bukan skrg laa
Azril Nazli Alias: petang karang ker
saiya: ok ptg karang wat
Azril Nazli Alias: oppss satu db lagi x repair
Azril Nazli Alias: cd /var/lib/mysql/peroduacars_db
Azril Nazli Alias: mysam check yg tadi siap r
saiya: oo ok jap
Azril Nazli Alias: database pmc still error...
Azril Nazli Alias: Can't open file: 'smf_sessions.MYI' (errno: 145)
saiya: ok skarang ni tgh repair peroduacars_db
Azril Nazli Alias: ok
saiya: ok da siap repair
Azril Nazli Alias: cd masuk protonmania_2009
Azril Nazli Alias: rapir balik
saiya: ok da siap repair
Azril Nazli Alias: ok
Azril Nazli Alias: too many connections error balik
Azril Nazli Alias: ubat dia
Azril Nazli Alias: reboot
Azril Nazli Alias: pastu kalau error lagi....
Azril Nazli Alias: esok laa pk balik
Azril Nazli Alias:
saiya: ok tgh reboot
saiya: harap ok la kot
Azril Nazli Alias: ker nak ganti hdd baru