Inquiry:MySql table data missing problem

--0016364c759054c14c04718b7936
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Dear All
Can you please do me favor and let me know what is wrong with my MySql db
installed on Linux server that causes to get the following error message :
"Fail to insert cdr:Can't open file: 'cdrFromMSC_06.MYD'. (errno: 145)"
Your reply is highly appreciated
Regards
H.Motamedi

--0016364c759054c14c04718b7936--

Re: Inquiry:MySql table data missing problem

In the last episode (Aug 20), hadi motamedi said:
> Can you please do me favor and let me know what is wrong with my MySql db
> installed on Linux server that causes to get the following error message :
> "Fail to insert cdr:Can't open file: 'cdrFromMSC_06.MYD'. (errno: 145)"

$ perror 145
MySQL error code 145: Table was marked as crashed and should be repaired
$

You need to repair your table:

http://dev.mysql.com/doc/refman/5.1/en/repair.html

--
Dan Nelson
dnelson@allantgroup.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org