MySQL Error 1016
Posted by godzalli | Posted in IT | Posted on 22-04-2008-05-2008
6
Tadi siang, teman saya mengalami kesulitan. Dia bercerita lewat telepon bahwa salah satu tabel mysqlnya bermasalah. Pesan error yang dia dapatkan melalui phpmyadminnya adalah: #1016 – Can’t open file: ‘blabla.MYI’. (errno: 145).
Karena sebelumnya saya juga pernah mengalami hal serupa, saya lakukan perintah seperti dibawah ini:
C:\mysql\bin>perror 145
Error code 145: unknown error
145 = Table was marked as crashed and should be repaired
Lalu perintah untuk membetulkan file yang rusak:
C:\mysql\bin>myisamchk -r c:\mysql\data\folder\blabla.MYI
- recovering (with sort) MyISAM-table ‘c:\mysql\data\folder\blabla.MYI’
Data records: 216
- Fixing index 1
- Fixing index 2
- Fixing index 3
Alhamdulillah tabelnya sudah kembali seperti sediakala
I’ve also gotten this error: ERROR 1030 (HY000): Got error 127 from storage engine
Which can also be fixed by running a repair table command.
When you are working with PHP and MySQL and encounter an error, it is helpful to receive more detailed information regarding the problem to point you in the direction of fixing it. You can use the mysql_error ( ) to get feedback from MySQL to your PHP document if you are encountering problems. It is phrased as: mysql_error ( [link_identifier] )
I am doing a site. it connect mysql server using mysql_connect is working but the same mysql_connect does not work another site. it displays following error
Warning: mysql_connect() [function.mysql-connect]: Can’t connect to MySQL server on ‘mysql18.site.com’ (10060) in D:\root\httpdocs\Acc\ji\config.inc.php on line 120
Can’t connect to MySQL server on ‘mysql18.site.com’ (10060)..
So what should I do?
i have a problem. in the direction of fixing it. You can use the mysql_error ( ) to get feedback …
Now I’ve also gotten this error: ERROR 1030 (HY000): Got error 127 from storage engine
Which can also be fixed by running a repair table command.
:pinch: :whistle: