In the last episode (Jan 11), Sathish said:
> We have been using MYSQL in our dedicated server for long time without
> problem, Suddenly we noticed an error stating " Can't open file error
> number 24".
>
> When we rebooted the machine , MYSQL started working again fine. We have
> to fix this pro
> problem, Suddenly we noticed an error stating " Can't open file error
> number 24".
If I recall correctly, error 24 means the disk partition is full.
Neil
--
Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net
MySQL pre-installed on a virtual private server for $25/mo
Unmetered band
--On August 8, 2006 11:36:21 AM +0200 thomas Armstrong
<[EMAIL PROTECTED]> wrote:
Hi.
My Linux server has just restarted due to memory problems.
Browsing mySQL logs, I've found out 5,000 lines like these in less
than one hour:
--
060808 1:27:39 [ERROR] /usr/sbin/mysqld: Can't
On 8/8/06, thomas Armstrong <[EMAIL PROTECTED]> wrote:
Hi.
My Linux server has just restarted due to memory problems.
Browsing mySQL logs, I've found out 5,000 lines like these in less
than one hour:
--
060808 1:27:39 [ERROR] /usr/sbin/mysqld: Can't open file:
'my_table.MYI' (errno
> > hmm! mysql.sock was created at var/lib/mysql.
> > owner=mysql, permissions=777
> > So again, is there paths/permissions problems?
> >
> >
> Since this is where your my.cnf says to put it, it would be a problem if
> it was not there.
> If you are going to override the default location of the
Tim Johnson wrote:
* Gleb Paharenko <[EMAIL PROTECTED]> [050711 07:17]:
Hello Gleb:
Check that you have correct permissions set on MySQL datadir.
See:
http://dev.mysql.com/doc/mysql/en/mysql-install-db.html
I will add to the comments above. I had to set the owner
and group to mysq
* Gleb Paharenko <[EMAIL PROTECTED]> [050711 07:17]:
Hello Gleb:
> Check that you have correct permissions set on MySQL datadir.
> See:
> http://dev.mysql.com/doc/mysql/en/mysql-install-db.html
I will add to the comments above. I had to set the owner
and group to mysql as per my redhat s
Hello.
[EMAIL PROTECTED] gleb]$ perror 13
OS error code 13: Permission denied
Check that you have correct permissions set on MySQL datadir.
See:
http://dev.mysql.com/doc/mysql/en/mysql-install-db.html
Tim Johnson <[EMAIL PROTECTED]> wrote:
> Using 4.0.20 on Slack 10.0
>
>
At 11:14 -0700 9/25/03, [EMAIL PROTECTED] wrote:
>Description:
bin/mysqld_safe --user=mysql fails with the following error
(from data/host.err file)
030925 10:58:58 mysqld started
030925 10:58:59 InnoDB: Started
030925 10:58:59 Fatal error: Can't open pri
Deependra b. Tandukar wrote:
Dear all,
what is the meaning of
Can't open file: 'products_description.MYI'. (errno: 145)
in mysql?
Regards,
_DT
$ perror 145
145 = Table was marked as crashed and should be repaired
Hope this helps
--
Joseph Bueno
--
MySQL General Mailing List
For list archives:
"Deependra b. Tandukar" <[EMAIL PROTECTED]> wrote:
>
> what is the meaning of
>
> Can't open file: 'products_description.MYI'. (errno: 145)
>
> in mysql?
$ perror 145
Error code 145: Unknown error 145
145 = Table was marked as crashed and should be repaired
You should repair table with REPAIR
Newsgroups: mailing.database.mysql
> Sent: Wednesday, June 04, 2003 7:05 AM
> Subject: Re: Can't open privilege tables: Table 'mysql.host' doesn't exist
>
> > Sorry, I should have given more details.=20
> > Its Mysql 4.1 alpha on a Suse Linux system Version
gt; Nils,
>
> - Original Message -
> From: ""Nils Valentin"" <[EMAIL PROTECTED]>
> Newsgroups: mailing.database.mysql
> Sent: Wednesday, June 04, 2003 7:05 AM
> Subject: Re: Can't open privilege tables: Table 'mysql.host' doesn't exist
>
Nils,
most probably you have some other difference in the my.cnf files.
Regards,
Heikki
- Original Message -
From: "Nils Valentin" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, June 04, 2003 6:2
Nils,
- Original Message -
From: ""Nils Valentin"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Wednesday, June 04, 2003 7:05 AM
Subject: Re: Can't open privilege tables: Table 'mysql.host' doesn't exist
> Sorry, I s
Sorry, I should have given more details.
Its Mysql 4.1 alpha on a Suse Linux system Version 8.1.
...and yes, the mysql.host table and the other 5 exist and are well alive ;-).
If I replace my.cnf with a version skipping innodb then it perfectly starts
up, so it must be related to innodb, perhap
hollen,
Saturday, July 13, 2002, 7:07:30 AM, you wrote:
h> In using MySQLGui v 1.75, I get the following message when I try to
h> connect to the database:
h> Can't connect to local MySQL server through socket "(111)
h> What can I do in addition to following the configuration for .my.sql
h>
Liu,
Wednesday, June 05, 2002, 5:59:53 AM, you wrote:
LQq> I am making use of mySQL to provide my client a solution. However, one of tables
often crash and produces the folloing error message when I try to use the table in a
query:
LQq> mysql> select * from action;
LQq> error 1016: Can't open
try to do a search on google with the error message you posted here. i'm
sure this will help.
Liu Qianghua-qch1942 wrote:
>
> Hi, everyone,
>
> I am making use of mySQL to provide my client a solution. However, one of tables
>often crash and produces the folloing error message when I try to us
19 matches
Mail list logo
