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 aga
> 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
Hi,
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 problem not to happen again,
We h
sqld: Can't open file:
'my_table.MYI' (errno: 145)
060808 1:27:39 [ERROR] /usr/sbin/mysqld: Can't open file:
'my_table.MYI' (errno: 145)
060808 1:27:39 [ERROR] /usr/sbin/mysqld: Can't open file:
'my_table.MYI' (errno: 145)
060808 1:27:39 [ERROR] /usr/
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 fil
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: 145)
060808 1:27:39 [ERROR] /us
On Tuesday 18 July 2006 08:23 am, Calselli, Fabrizio WI wrote:
> Hi there,
>
> After having installed the Mysql Ver. 5.0.22-standard for sun-solaris2.10
> (SPARC) I get the error below when I try to start the mysql server:
>
> Sun-solaris# /usr/sbin/mysqld -u mysql
>
> Err
Hi there,
After having installed the Mysql Ver. 5.0.22-standard for sun-solaris2.10
(SPARC) I get the error below when I try to start the mysql server:
Sun-solaris# /usr/sbin/mysqld -u mysql
Error #60718 Can't open and lock privilege tables: Table 'mysql.host' doesn't
ex
Hi Micheal
Thanks for your suggestions. I use mysqldump to restore the DB's. Apparently
mysqldump doesn't create forward declarations for views. So I had to manually
feed the views in correct order to avoid errors. Also to import the DB sfg into
sfgnew I had to substitute all of the `sfg` patt
murthy gandikota wrote:
> Here are some pertinent facts:
> a) stopped mysqld
> b) copied files from sfg to sfgnew in the var directory
> c) set the permissions to 777 (read, write, execute) for all the files in
sfgnew
> d) restarted mysqld
Dan Buettner wrote:
> Murthy, do you have
Murthy, if you want to dump database A and restore into database B, it's
basically a 3-step process. You have to first create B, then dump A,
then pipe the dump of A into B. Using the --no-data option with
mysqldump will dump only structure, no data.
something like this:
mysql -u root -psec
At 6:14 -0700 6/14/06, murthy gandikota wrote:
I'm getting the following error
ERROR 1016 (HY000): Can't open file: 'agent.ibd' (errno: 1)
This is the output from mysqld
060613 19:59:34 InnoDB error:
Cannot find table sfgnew/agent from the internal data
*mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 14, 2006 8:12 AM
To: murthy gandikota
Cc: mysql@lists.mysql.com
Subject: Re: ERROR 1016 (HY000): Can't open file: 'agent.ibd' (errno: 1)
Murthy, doing some quick reading on InnoDB table definitions, it appears
that MySQL itself keeps s
ing similar to recreate your tables and move them. HTH.
-phpninja
-Original Message-
From: Dan Buettner
[*mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 14, 2006 8:12 AM
To: murthy gandikota
Cc: mysql@lists.mysql.com
Subject: Re: ERROR 1016 (HY000): Can't open file: 'agent
murthy gandikota
Cc: mysql@lists.mysql.com
Subject: Re: ERROR 1016 (HY000): Can't open file: 'agent.ibd' (errno: 1)
Murthy, doing some quick reading on InnoDB table definitions, it appears
that MySQL itself keeps some info in the .frm file, while InnoDB keeps some
info within the table
u don't
have execute permission for the mysql user on that dir, MySQL can't
list
the contents ...
Dan
murthy gandikota wrote:
I'm getting the following error
ERROR 1016 (HY000): Can't open file: 'agent.ibd' (errno: 1)
This is the output from mysqld
060613 19:59:34
(777 works, or 775/770 if
> owned by mysql user) on your new directory ('sfgnew')? If you don't
> have execute permission for the mysql user on that dir, MySQL can't
> list
> the contents ...
>
> Dan
>
> murthy gandikota wrote:
> >
> >
rote:
>
> I'm getting the following error
> ERROR 1016 (HY000): Can't open file: 'agent.ibd' (errno: 1)
>
> This is the output from mysqld
>
> 060613 19:59:34 InnoDB error:
> Cannot find table sfgnew/agent from the
(777 works, or 775/770 if
owned by mysql user) on your new directory ('sfgnew')? If you don't
have execute permission for the mysql user on that dir, MySQL can't list
the contents ...
Dan
murthy gandikota wrote:
>
> I'm getting the following error
> ER
tting the following error
ERROR 1016 (HY000): Can't open file: 'agent.ibd' (errno: 1)
This is the output from mysqld
060613 19:59:34 InnoDB error:
Cannot find table sfgnew/agent from the internal data dictionary
of InnoDB though the .frm file for the table exists. May
I'm getting the following error
ERROR 1016 (HY000): Can't open file: 'agent.ibd' (errno: 1)
This is the output from mysqld
060613 19:59:34 InnoDB error:
Cannot find table sfgnew/agent from the internal data dictionary
of InnoDB though the .frm file for the
> > 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
; New setup. mysql_install_db was run.
> > On startup, the error log shows the following error message:
> > """
> > Fatal error: Can't open privilege tables: Can't find file:
> > './mysql/host.frm' (errno: 13)
> > ""&quo
lack 10.0
>
> New setup. mysql_install_db was run.
> On startup, the error log shows the following error message:
> """
> Fatal error: Can't open privilege tables: Can't find file:
> './mysql/host.frm' (er
Using 4.0.20 on Slack 10.0
New setup. mysql_install_db was run.
On startup, the error log shows the following error message:
"""
Fatal error: Can't open privilege tables: Can't find file:
'./mysql/host.frm' (errno: 13)
""
Hello,
I hope that you have not destroyed the ibdata file. The tables are
there. Did you edit the my.cnf in the upgrade? What does mysqld print to
the .err log?
when we changed from 4.0.20 to 4.1.9 we moved to a new server and copied
only the database directories, but no error-logs or ibdata fil
Marten,
- Original Message -
From: "Marten Lehmann" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Thursday, January 20, 2005 5:47 PM
Subject: 4.0.20 -> 4.1.9 Can't open file: 'Autor.ibd'
Hello,
some weeks ago we switched from mysql 4.
Hello,
some weeks ago we switched from mysql 4.0.20 to 4.18 and later to 4.1.9.
A customer now told us, that he can't access his old InnoDB-tables. He gets
#1016 - Can't open file: 'Autor.ibd' (errno: 1)
if he tries to access the table "Autor". This happens to oth
>
> I am trying to run mysql 4.0.21 server on a freeBSD 5.3 box. I tried
> to run mysqld_safe to add a root password but i can't seem to run the
> safe command because it shuts down immediately.
>
> The following error is presented to me:
>
> Fatal error: Can&
n immediately.
The following error is presented to me:
Fatal error: Can't open privilege tables: File
'/usr/local/share/mysql/charsets/?.conf' not found (Errcode: 2)
I would like it to load the latin1.conf charset.
I can't find any variable that influences this choice. Probably the
Hi
I am trying to run mysql 4.0.21 server on a freeBSD 5.3 box. I tried
to run mysqld_safe to add a root password but i can't seem to run the
safe command because it shuts down immediately.
The following error is presented to me:
Fatal error: Can't open privilege tables: File
'/
yes mr egor
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Michael Arndt <[EMAIL PROTECTED]> wrote:
> a) what could be reason /solution for the following Problem:
>
> ERROR 1016: Can't open file: '#sql-407f_f.MRG'. (errno: 144)
[EMAIL PROTECTED] egor]$ perror 144
Error code 144: Unknown error 144
144 = Table is cras
Hello *,
a) what could be reason /solution for the following Problem:
ERROR 1016: Can't open file: '#sql-407f_f.MRG'. (errno: 144)
b) in which directory the below reported intermediate file should
be generated
mysql> use syslog
Database changed
mysql> AL
: MICHAEL_WU
Cc: [EMAIL PROTECTED]
Subject: Re: FW: Could not start MySQL after reinstall - Can't open
privilege tables: Table 'mysql.host' doesn't exist
Did you change the permissions for the files to include
read/write/change for the user/account MySQL uses on your system? T
wing error
persists:
Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't
exist
Everything should be wiped out I thought. Does MySQL saves some data
somewhere other than
the installation directory? More help, please?
Michael Wu
-Original Message-
From:
Since the database I created was not critical, I could simply throw it away.
Therefore,
delete the whole MySql installation directory and unzip the alpha release
zip file again
to create the installation directory tree. However, the following error
persists:
Fatal error: Can't
lling mySQL 4.1.1 today. When I
tried to start the service on my Windows2K, I got the following error:
040527 15:37:49 Fatal error: Can't open privilege tables: Table
'mysql.host' doesn't exist
Can some one tell me how to solve the problem?
Thanks in advance!
Micha
Hello,
I run into a problem after re-installing mySQL 4.1.1 today. When I
tried to start the service on my Windows2K, I got the following error:
040527 15:37:49 Fatal error: Can't open privilege tables: Table
'mysql.host' doesn't exist
Can some one tell
Hi!
May I have the reason why this error occured in my Localhost.
When I try to connect to MySQL on the Localhost I met the error
*Can't open named pipe to host: . pipe: MySQL (2)*
I have used;
Windows 2000 SP 4
MySQL Server 4.0.17 max-debug
Upon looking the document
Hello!
I get this error from my MySQL-database:
Error: 1016 Can't open file: 'tablename.MYI.
(errno: 145).
I know what to do to fix this, but I need to know what causes this error.
If anyone know, please respond.
Best regards
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
>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 privilege tables:
Hi There,
errno 145 means:
'Table was marked as crashed and should be repaired'
You can Type on the commandline (dosbox, bash, etc-): perror
to get information about errors.
prosit
Klaus
P.S.:REPAIR TABLE (manual chapter 4.4.5) might help.
--
MySQL General Mailing List
For list a
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
Fo
"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
Dear all,
what is the meaning of
Can't open file: 'products_description.MYI'. (errno: 145)
in mysql?
Regards,
_DT
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
t;describe my_table" and I get:
ERROR 1016: Can't open file: 'my_table.MYD'. (errno: 145).
I freed up some space under /var but I still recieve the above
messages. Does this mean that my table has been corrupted? Is there
any wa
Hello all,
My /var partition has become full, and now when I try load my db (the files
are in /var/lib/mysql/db/) I get the following message for the table
"my_table":
use db;
Didn't find any fields in table 'my_table'
I then do "describe my_table" and
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
, perhaps my.cnf and/or mysql itself.
Best regards
Nils Valentin
2003年 6月 4日 水曜日 12:36、Nils Valentin さんは書きました:
> Hi Mysql list members,
>
> I added a Innodb database to the existing MyISAM databases and now MySQL
> doesnt start up. From the InnoDB logfile I saw this error message
&g
Hi Mysql list members,
I added a Innodb database to the existing MyISAM databases and now MySQL
doesnt start up. From the InnoDB logfile I saw this error message
Can't open privilege tables: Table 'mysql.host' doesn't exist
Does any body know what this error comes fro
I'm trying to set up my own web server . . . the typical
Linux/apache/perl/php/mysql combination. I've got all these components
working *except* that I am unable to connect to a MySQL database from
perl or php.
PHP & Perl are working fine with Apache and I can run MySQL commands
from the shell
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>
In using MySQLGui v 1.75, I get the following message when I try to
connect to the database:
Can't connect to local MySQL server through socket "(111)
What can I do in addition to following the configuration for .my.sql
in MySQL.help? I can access the database through the text based mysql
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
essage when I try to use the table in a
>query:
>
> mysql> select * from action;
> error 1016: Can't open file: 'action.MYD'. (errno: 145).
>
> The record in this table is temporary, after I delete all record from action.
>Everything is seem to ok.
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 use the table in a query:
mysql> select * from action;
error 1016: Can't open file: 'action.MYD'. (errno: 145).
http://www.mysql.com/doc/W/i/Windows_vs_Unix.html
Can't open named pipe error
If you use a MySQL 3.22 version on NT with the newest mysql-clients you will
get the following error:
error 2017: can't open named pipe to host: . pipe...
This is because the release version of MySQL
QL-Front?
>>
>>InnoDB returns the error "Can't open file mytable.InnoDB"
>>when it cannot find the table in its internal data
>>dictionary. Maybe the case of letters in the database name
>>is wrong?
>>
>>Brent,
>>
>>if you look
Hi *.*
> what could cause the problem Brent reports in MySQL-Front?
>
> InnoDB returns the error "Can't open file mytable.InnoDB"
> when it cannot find the table in its internal data
> dictionary. Maybe the case of letters in the database name
> is wrong?
Sor
Ansgar,
what could cause the problem Brent reports in MySQL-Front?
InnoDB returns the error "Can't open file mytable.InnoDB"
when it cannot find the table in its internal data
dictionary. Maybe the case of letters in the database name
is wrong?
Brent,
if you look at the MySQL s
he pane on the left. If I try and select one of
my InnoDb tables from underneath the database node, I'll get an error
window saying "MySQL Error - 1016 Can't open file "mytable.InnoDB'. (errno:
1)". Clicking on the database name says one or more of the InnoDb table
Hi,
I have a table:
CREATE TABLE WI_PICTUREFILES (
SECTIONID VARCHAR(50) BINARY NOT NULL,
PICTUREID VARCHAR(50) BINARY,
PICTUREFILE VARCHAR(200) BINARY NOT NULL,
PICFILEXT VARCHAR(5) BINARY NOT NULL,
SHEETNO VARCHAR(2) BINARY,
Check for /etc/my.cnf or .my.cnf in mysql's var directory.
One of these must have a line misdefining the socket as mysqld.sock.
Chad Nantais wrote:
>> Description: on start, MySQL creates a socket (mysqld.sock), in the /tmp directory
>by default, and tries to start
>
> by opening socket mysql
>Description: on start, MySQL creates a socket (mysqld.sock), in the /tmp directory by
>default, and tries to start
by opening socket mysql.sock. this might be a configuration error. the
following fix worked.
>How-To-Repeat:
try to start mysql by running ./safe_mysqld
>Fix:
I'm running a simple master/slave configuration with mysql-3.23.29-gamma
under Solaris 2.6. Sometime last night, one of the tables disappeared
on the slave. I got thousands of errors like this:
Can't open file: 'netgroup.MYD'. (errno: 144)
I fixed it with `drop
mirror-ed DB at our end.
We were successful in mirroring our tables initially using
LOAD TABLE FROM MASTER.
But some of the tables on Slave server have very short life. They
presumabely die, giving this sort of Error :
Error 1016: Can't open file: 'ftp_customer.MYD'.
This al
72 matches
Mail list logo
