On Fri, 07 Sep 2007 07:05:31 +0200, Ashok Chauhan [EMAIL PROTECTED]
wrote:
Hi All,
I'm using Mysql 5 (with replication) on CentOS 4.4 OS with 2 CPU and 8GB
of RAM.
Master Slave servers have same hardware configration.
Now i want to know, should i use slave server for fetching read only
On Fri, 07 Sep 2007 07:05:31 +0200, Ashok Chauhan [EMAIL PROTECTED]
wrote:
Hi All,
I'm using Mysql 5 (with replication) on CentOS 4.4 OS with 2 CPU and 8GB
of RAM.
Master Slave servers have same hardware configration.
Now i want to know, should i use slave server for fetching read only
+0200, Ashok Chauhan [EMAIL PROTECTED]
wrote:
Hi All,
I'm using Mysql 5 (with replication) on CentOS 4.4 OS with 2 CPU and
8GB
of RAM.
Master Slave servers have same hardware configration.
Now i want to know, should i use slave server for fetching read only
queries.
if yes
Ashok Chauhan wrote:
Hi All,
I'm using Mysql 5 (with replication) on CentOS 4.4 OS with 2 CPU and 8GB
of RAM.
Master Slave servers have same hardware configration.
Now i want to know, should i use slave server for fetching read only
queries.
if yes, then how ?.
Thanks
Ashok
The simple
Hi All,
I'm using Mysql 5 (with replication) on CentOS 4.4 OS with 2 CPU and 8GB
of RAM.
Master Slave servers have same hardware configration.
Now i want to know, should i use slave server for fetching read only
queries.
if yes, then how ?.
Thanks
Ashok
--
MySQL General Mailing List
Clyde Lewis - DBA a écrit :
The idea here is to perform this change without restarting the server.
Is that possible? I know that by updating the config file, then
restarting will allow the database to be in read-only mode, but need to
know if it is possible without restarting.
Thanks,
CL
Is this possible with MYSQL using the innodb engine? If so, what is
the command/process to make this happen.
Thanks in advance,
~
Clyde Lewis
Database Administrator
-Original Message-
From: Clyde Lewis - DBA [mailto:[EMAIL PROTECTED]
Sent: 03 August 2007 16:55
To: MySQL List
Subject: Re: MySQL in read-only mode
The idea here is to perform this change without restarting the
server. Is that possible? I know that by updating the config file
The idea here is to perform this change without restarting the
server. Is that possible? I know that by updating the config file,
then restarting will allow the database to be in read-only mode, but
need to know if it is possible without restarting.
Thanks,
CL
At 11:46 AM 8/3/2007, Clyde
List
Subject: Re: MySQL in read-only mode
The idea here is to perform this change without restarting the
server. Is that possible? I know that by updating the config file,
then restarting will allow the database to be in read-only mode, but
need to know if it is possible without restarting
Would like to see this, there is a TMD temp table created during an optimize
is there any reason read only access cant take place during the optimize
process? Update/delete/insert shouldn't, but read access should be
allowed on myisam
any thoughts on this?
--
MySQL General Mailing List
I use MySQL version 4.1.18 with redhat-linux-gnu
(i686). I have created a InnoDB database consisting of
210 GB ibdata files. I used InnoDB to allocate more
memory and speed up the load. I want use it for
read-only purpose and it works fine with one MySQL
server instance.
I am trying to run
pradhuman jhala wrote:
I use MySQL version 4.1.18 with redhat-linux-gnu
(i686). I have created a InnoDB database consisting of
210 GB ibdata files. I used InnoDB to allocate more
memory and speed up the load. I want use it for
read-only purpose and it works fine with one MySQL
server instance
Hello,
I'm trying to set up a replication slave as read-only, but the read-only
part doesn't seem to be working.
Replication between the master and the slave works fine. I have added the
read-only keyword to the slave's my.cnf, and looking at the output of show
variables indicates that read
Are you inserting rows as a root user? The root user will be able to
write to tables even if read-only is set to 'ON'.
--Ravi
Rod Heyd wrote:
Hello,
I'm trying to set up a replication slave as read-only, but the read-only
part doesn't seem to be working.
Replication between the master
On 6/14/06, ravilr [EMAIL PROTECTED] wrote:
Are you inserting rows as a root user? The root user will be able to
write to tables even if read-only is set to 'ON'.
Ah, yes. That was it. I forgot about that.
Thanks.
-Rod
Rod Heyd wrote:
Hello,
I'm trying to set up a replication slave as read-only, but the read-only
part doesn't seem to be working.
Replication between the master and the slave works fine. I have added the
read-only keyword to the slave's my.cnf, and looking at the output of show
variables
tables (another hint I
got), it looks like it does what I want.
Cheers
Frank
On 4/7/06, Frank [EMAIL PROTECTED] wrote:
Hi,
is there a possibility to configure a MySQL database in such a way that I
can store the database on a read-only medium (say a CD), but still be
able to write
Hi,
is there a possibility to configure a MySQL database in such a way that I
can store the database on a read-only medium (say a CD), but still be able
to write to the database (without having to copy the datafiles to disk or
memory first)?
What I have in mind is something like telling MySQL
in such a way that I
can store the database on a read-only medium (say a CD), but still be able
to write to the database (without having to copy the datafiles to disk or
memory first)?
What I have in mind is something like telling MySQL to use a different
datafile for the new data.
Could partitioning
Hi,
If you really sure that your MySQL is not in read only option, better
you give us the my.cnf configuration
also mount result for all filesystem partition so we sure that the data
MySQL is not mounted read-only
I can be sure, because usually these inserts are working well. And all
Hi,
I get these errors:
[31-Jan-2006 17:25:59] PHP Fatal error: The MySQL server is running
with the --read-only option so it cannot execute this statement
query: INSERT INTO sessions (sid, uid, hostname, timestamp) VALUES
('22177a73e9b93b88e376c2226d000f7b', 0, '68.142.250.172
Hi
If you really sure that your MySQL is not in read only option, better
you give us the my.cnf configuration
also mount result for all filesystem partition so we sure that the data
MySQL is not mounted read-only
Thx
BÁRTHÁZI András wrote:
Hi,
I get these errors:
[31-Jan-2006 17:25
Very odd problem. I do have a larger database, with many myisam tables.
A couple days ago, some of them turned 'read only'.
Symptom:
delete from day_48392 where id=28398776259;
ERROR 1036 (HY000): Table 'day_48392' is read only
I checked:
- table file permissions are right ('660 mysql:daemon
Well, I found the reason for these table becoming 'read only':
These tables where part of a merge table, which included some read only
tables (read only set in file system).
Now even after the merge table was dropped, all member tables stayed
'read only' regardless of their individual file
Hey yall,
I'm trying to use a DVD (containing a number of packed MyISAM tables in a
directory) as the datadir in my my.cnf but I can't start the server: mysqld
is trying to write to the datadir - error log, etc - and when it can't the
server craters.
Is there anyway of using a readonly directory
Hey, sorry everyone - I figured it out.
I had to add the following to my.cnf
read-only
skip-innodb
I guess I shoulda kept googling before asking... mybad.
/JP
On 9/21/05, Jake Peavy [EMAIL PROTECTED] wrote:
Hey yall,
I'm trying to use a DVD (containing a number of packed MyISAM tables
Is there a way to make MySQL Slaves read only in regards to all UPDATE, INSERT,
DELETE, DROP, TRUNCATE, etc, except for the replication thread? I know you can
just change the user accounts to disallow write access to the tables, but I'm
thinking it would be convenient to simply have a switch
There is an option starting in 4.0.14 called read-only that will allow
only the slave i/o thread and users with the super priv to execute write
queries.
Jeremiah Gowdy wrote:
Is there a way to make MySQL Slaves read only in regards to all UPDATE, INSERT,
DELETE, DROP, TRUNCATE, etc, except
Hi,
After upgrading to mysql 4.1.10nt
I am being told that some of my tables are read-only
I cannot find where or how you might specify that a table is read/write to
whatever
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Speaking of the --read-only option, I don't suppose there's
any way to run --read-only but allow CREATE TEMPORARY TABLE,
is there? We run several reports against a slave server
which require temporary tables for speed, and have had a
problem with the occasional accidental write to the slave
to execute INSERT or UPDATE query via
DBD::mysql it from time to time (but NOT always ) gets error 1036
(Table 'XX' is read only).
Meanwhile:
1) Mysql user who tries to execute a query has all necessary
priveleges
2) File system priveleges are also correctly set
'XX' is read only).
Meanwhile:
1) Mysql user who tries to execute a query has all necessary
priveleges
2) File system priveleges are also correctly set. mysqld runs under
user mysql. Mysql datadir and ALL database files are owned by it and
have 770 privilege mask.
3) The problem
:47 PM
To: Hathaway, Scott L
Cc: [EMAIL PROTECTED]
Subject: Re: Windows 2003 read-only problem
Have you tried connecting with this user directly from the MySQL
monitor?
Hathaway, Scott L wrote:
I have a server that is Windows 2003 server. It is running php from
IIS 6. I access the latest 4.0x
I have a server that is Windows 2003 server. It is running php from IIS
6. I access the latest 4.0x MySQL and am having some trouble. My
database access is readonly. The user that I connect as has update
privileges (all privileges, actually). We checked the file permissions
to the Mysql
Have you tried connecting with this user directly from the MySQL monitor?
Hathaway, Scott L wrote:
I have a server that is Windows 2003 server. It is running php from IIS
6. I access the latest 4.0x MySQL and am having some trouble. My
database access is readonly. The user that I connect as
in command
Anil
DBA
-Original Message-
From: Lee Zelyck [mailto:[EMAIL PROTECTED]
Sent: Monday, October 11, 2004 7:30 AM
To: [EMAIL PROTECTED]
Subject: Read-Only DB User
Hi All,
I'm sorry to access such a basic question, but I
couldn't find a specific answer to it in the mysql
manual
To: [EMAIL PROTECTED]
Subject: Read-Only DB User
Hi All,
I'm sorry to access such a basic question, but I
couldn't find a specific answer to it in the mysql
manual pages.
The question is, how would someone create a basic
read-only user for a single db? I just intend
Hi All,
I'm sorry to access such a basic question, but I
couldn't find a specific answer to it in the mysql
manual pages.
The question is, how would someone create a basic
read-only user for a single db? I just intend for it
to be used by a script to validate data in the db
itself
sorry to access such a basic question, but I
couldn't find a specific answer to it in the mysql
manual pages.
The question is, how would someone create a basic
read-only user for a single db? I just intend for
it
to be used by a script to validate data in the db
itself.
Anyway
Thanks James!
The actual command that worked for me was as
follows:
mysql GRANT SELECT ON db.* TO [EMAIL PROTECTED]
IDENTIFIED BY '2user3';
Query OK, 0 rows affected (0.09 sec)
I receieved errors while trying to include the
'PASSWORD' option, as that seemed to be wanting a the
password in hex
have installed mysql some software on aix5.2 .
the edition is MySQL-3.23.58-2.aix5.1.ppc
but when I used phpmyadmin to manage the mysql
it told me
**
#1036 - Table 'gbook' is read only
Hi
I have installed mysql some software on aix5.2 .
the edition is MySQL-3.23.58-2.aix5.1.ppc
but when I used phpmyadmin to manage the mysql
it told me
**
#1036 - Table 'gbook' is read only
-3.23.58-2.aix5.1.ppc
but when I used phpmyadmin to manage the mysql
it told me
**
#1036 - Table 'gbook' is read only
installed mysql some software on aix5.2 .
the edition is MySQL-3.23.58-2.aix5.1.ppc
but when I used phpmyadmin to manage the mysql
it told me
**
#1036 - Table 'gbook' is read only
or a delete on this table (and only on this
table), but with a join on a compressed table in the where clause, I
get
an error : 'table [mycompressedtable] is read only'. The problem is
that I
am not trying to write to this table !
For example, let's say I have a memory based table 'tmpTable
I get an
error DBD::mysql::db do failed: Table 'x' is read only at
/path/to/cgi/script line xxx. referrer /path/to/cgi/script
I have checked all of the file permissions and they are all correct. Can
anyone shed light on what the problem may be.
Thank you
Mike
--
MySQL General Mailing
I get an
error DBD::mysql::db do failed: Table 'abcd' is read only at
/path/to/cgi/script line xxx. referrer /path/to/cgi/script
I have checked all of the file permissions and they are all correct. Can
anyone shed light on what the problem may be.
Thank you
Mike
--
MySQL General Mailing
able
to request info and get results but whenever I try to insert data I get an
error DBD::mysql::db do failed: Table 'abcd' is read only at
/path/to/cgi/script line abc. referrer /path/to/cgi/script
I have checked all of the file permissions and they are all correct. Can
anyone shed light
servers in the chain will get the changes. I have no problem
setting up the multi-master environment.
I want to take it a step farther. I would like to set up the slaves in this
multi-master as read-only. Then, once they become the master, I want to drop the
read-only attribute. I see
Sorry for the second post, I realized that my first post might not be clear...
I want the failover and the switch from read-only to non read-only to be dynamic,
no downtime.
Thanks
-Original Message-
From: [EMAIL PROTECTED]
Sent: Wednesday, May 12, 2004 4:07 PM
To: Mysql General (E
On Wed, May 12, 2004 at 04:11:41PM -0400, Tucker, Gabriel wrote:
Sorry for the second post, I realized that my first post might not be clear...
I want the failover and the switch from read-only to non
read-only to be dynamic, no downtime.
You can't do that. The read-only setting cannot
On Monday 15 March 2004 01:02, Chuck Gadd wrote:
Smartyone wrote:
The database used to work, but then something must have broke, because
now it is suddenly Read-Only (reports Read Only when I try to add a
record using MySQLCC).
Make sure the owner and group of the database files is set
is mysql:root, permissions are 660 to all files.
The database used to work, but then something must have broke, because now it
is suddenly Read-Only (reports Read Only when I try to add a record using
MySQLCC).
If I copy the whole database (the whole directory) to a new directory, eg.
cp -R dataset1
Smartyone wrote:
The database used to work, but then something must have broke, because now it
is suddenly Read-Only (reports Read Only when I try to add a record using
MySQLCC).
Make sure the owner and group of the database files is set
to mysql.
--
MySQL General Mailing List
For list
wrote:
Ok, I have installed MySQL many times and have never come across this...
when try to run
./bin/mysqladmin -u root password 'new-password'
I get the following
./bin/mysqladmin: unable to change password; error: 'Table 'user' is
read only'
I've never had this happen
-password'
I get the following
./bin/mysqladmin: unable to change password; error: 'Table 'user' is
read only'
I've never had this happen, and unfortunately do not know enough about
read/write perms on tables to try to debug it.
I promise that I'll study up
On Tue, 2004-03-02 at 21:55, Jonathan Villa wrote:
Ok, I have installed MySQL many times and have never come across this...
when try to run
./bin/mysqladmin -u root password 'new-password'
I get the following
./bin/mysqladmin: unable to change password; error: 'Table 'user' is
read only'
I've
Ok, I have installed MySQL many times and have never come across this...
when try to run
./bin/mysqladmin -u root password 'new-password'
I get the following
./bin/mysqladmin: unable to change password; error: 'Table 'user' is
read only'
I've never had this happen, and unfortunately do
'user' is
read only'
I've never had this happen, and unfortunately do not know enough about
read/write perms on tables to try to debug it.
I promise that I'll study up on it, but right now I'm kinda of in
rush...
I'm using : mysql-standard-4.0.18-pc-linux-i686.tar.gz
thanks
Hello All,
I am Swetha.I am facing the above mentioned problem while adding/updating a recordset
in the my_dao table.I tried a lot i am not getting the reason for this.So please let
me know the reason the solution for this problem.
With Regards,
Swetha.
hi swetha,
Pl. check the privilege tables for the user access.
-Aman.
Swetha S.N. wrote:
Hello All,
I am Swetha.I am facing the above mentioned problem while adding/updating a recordset in the my_dao table.I tried a lot i am not getting the reason for this.So please let me know the reason
Hello All,
I am Swetha.I am facing the above mentioned problem while
adding/updating a recordset in the my_dao table using DAO recordset.I tried a lot i am
not getting the reason for this.So please let me know the reason the solution for
this problem.
With Regards,
Swetha.
I see there is an exact situation described above regarding
'read-only tables' that was not answered as yet. I have done the dev.
work on win32 and now trying to get tables with data up to the Redhat
7.3 server. There are various problems. In some tables, doing
'repair' shows a number
I am trying to learn PHP using the tutorial for DWMX on macromedia.com. I was doing
pretty good until it came time to edit a record. When I tried the page, it said the
'album' table was read only. I had copied the database files from my computer to the
server so I went back and checked all
I am trying to learn PHP using the tutorial for DWMX on macromedia.com. I was doing
pretty good until it came time to edit a record. When I tried the page, it said the
'album' table was read only. I had copied the database files from my computer to the
server so I went back and checked all
Matt W wrote:
Hi Jeremy,
Sorry, it seems like I'm saying this a lot lately. Is it not true that
if the whole table will fit in [free] RAM, that the OS will cache the
file data and there is no need for a RAM disk. I don't really see how
performance would be any different than using a RAM disk.
Harald Fuchs wrote:
In article [EMAIL PROTECTED],
gerald_clark [EMAIL PROTECTED] writes:
Matt W wrote:
Hi Jeremy,
Sorry, it seems like I'm saying this a lot lately. Is it not true that
if the whole table will fit in [free] RAM, that the OS will cache the
file data and there is no
a read-only table
Hi Jeremy,
Sorry, it seems like I'm saying this a lot lately. Is it not true that
if the whole table will fit in [free] RAM, that the OS will cache the
file data and there is no need for a RAM disk. I don't really see how
performance would be any different than using a RAM disk
On Mon, Nov 10, 2003 at 05:03:35PM +0100, Harald Fuchs wrote:
In article [EMAIL PROTECTED],
gerald_clark [EMAIL PROTECTED] writes:
Matt W wrote:
Hi Jeremy,
Sorry, it seems like I'm saying this a lot lately. Is it not true that
if the whole table will fit in [free] RAM, that the OS
only use the full index length, no prefixes. However, none of this
is true in 4.1+, since you can have BTREE indexes with HEAP tables, not
just HASH. :-)
But you know what should actually be the best thing for your read-only
table? MySQL 4's query cache! :-) Have you thought about this? Or do
your
On Tue, Nov 04, 2003 at 08:45:08PM -0500, Jonathan Terhorst wrote:
I could have sworn I posted this once before, but apparently it got
lost somewhere. Apologies if you're seeing this twice:
I'm wondering what I can do with MySQL to optimize reads (SELECTs)
on a read-only table where data
I could have sworn I posted this once before, but apparently it got lost somewhere.
Apologies if you're seeing this twice:
I'm wondering what I can do with MySQL to optimize reads (SELECTs) on a read-only
table where data will never be INSERTed or UPDATEd. Okay, that's not entirely
correct
Hi Bennett
I had a similar problem on my system a while back. With my particular
case, the problem was the the default priv's on the new server for it's
users did NOT include INSERT rights.
Basically what I'm saying is: these are the reasons for a table to be
(or appear to be) read-only:
1
:
Hi Bennett
I had a similar problem on my system a while back. With my particular
case, the problem was the the default priv's on the new server for it's
users did NOT include INSERT rights.
Basically what I'm saying is: these are the reasons for a table to be
(or appear to be) read-only:
1) Table
, they usually work without any flush
priveleges or a restarting of the server. But I always do these two
steps, just to be on the safe side.
You know, I wouldn't like some user be welcomed with an ugly message
that goes Table is read-only. I will be the loser.
But anyways.. as you've got your problem
as expected, and I can perform
SELECT statements on them and get the correct results. But when I try
doing INSERT statements on one of the tables that was copied over, I get:
mysql INSERT INTO test VALUES(3);
ERROR 1036: Table 'test' is read only
However, if I create a new table called test2, I can
Bennett Haselton wrote:
I'm trying to port my MySQL tables for a database called tracerlock
from one server to another. On the old server, in the
/var/lib/mysql/tracerlock directory, there was a .MYD, .MYI and
.frm file for every table in the database. So after creating a
database called
making the tables read-only.
Also try logging in as root, and try inserting records, and see if that
works.
Thanks; I tried it, but it didn't work.
-Bennett
[EMAIL PROTECTED] http://www.peacefire.org
(425) 497 9002
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
that, and then did flush privileges, then logged out and logged
back in to mysql as bhaselto, but I still got the error table 'test' is
read only when trying to insert rows into it.
Any idea on how to do something differently with GRANT to make it work?
-Bennett
At 04:16 PM 8/16/2003 -0700, Bennett
Greetings:
Long time reader, first time poster. Here we go:
==Specific question:
Does there exist in MySQL a privilege configuration which will allow an account
to issue `SHOW MASTER STATUS` and `SHOW SLAVE STATUS`, but will disallow the
running of any other commands (such as `KILL`)?
dear all,
i has a problem to installing phpbb using mysql database. An error has occured
during installation (An error occured trying to update the database
Table 'phpbb_config' is read only).
what is the problem ? please help me
this is a phpbb specific question notice its a custom error message
-Original Message-
From: HA. Mooduto [mailto:[EMAIL PROTECTED]
Sent: Saturday, July 05, 2003 8:13 PM
To: [EMAIL PROTECTED]
Subject: database table is read only
dear all,
i has a problem to installing phpbb using mysql
I'm trying to update a table and I get this error
message.
ERROR 1036: Table 'list' is read only
J.
__
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
--
MySQL General Mailing
On Saturday 29 March 2003 10:32, Joseph Bannon wrote:
I'm trying to update a table and I get this error
message.
ERROR 1036: Table 'list' is read only
Is your table compressed with myisampack?
Check also permissions on the table files.
--
For technical support contracts, goto https
Any ideas why the following upgrade from ISAM to MyISAM fails:
mysql alter table users type = MYISAM;
ERROR 1036: Table 'users' is read only
This only occurs for about half the tables I tried to upgrade.
Thanks!
Paul
Hey everyone. I figured it out.
Packed tables are read only.
Thanks!
Paul
-Original Message-
From: Paul Borghese [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 17, 2003 9:26 PM
To: [EMAIL PROTECTED]
Subject: Upgrade from ISAM to MyISAM fails with read only error
Any ideas why
Check that mysql has write privileges at the operating system level.
Loren McDonald wrote:
Just tried. Nope...
mysql grant all privileges on mysql.* to ext identified by 'ext1tex2'
with grant option;
ERROR 1036: Table 'user' is read only
On Tuesday 14 January 2003 01:45, Loren McDonald wrote:
Just tried. Nope...
mysql grant all privileges on mysql.* to ext identified by 'ext1tex2'
with grant option;
ERROR 1036: Table 'user' is read only
Check permissions on the privilege table files, like host.frm, user.frm etc
MisterrMac
Gods Of Music Reviewer/Editor
[EMAIL PROTECTED]
http://www.GodsOfMusic.com
-Original Message-
From: gerald_clark [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 14, 2003 9:20 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: mysql.users read only?
Check that mysql
Does the user 'mysql' have write access to the mysql database and files?
Loren McDonald wrote:
Im not sure what has gone wrong but the mysql.users table is set as
read only. I am trying to grant user privileges but cant because of
this. How can I change the status so that I can add
Just tried. Nope...
mysql grant all privileges on mysql.* to ext identified by 'ext1tex2'
with grant option;
ERROR 1036: Table 'user' is read only
--
Loren McDonald AKA MisterrMac
Gods Of Music Reviewer/Editor
[EMAIL PROTECTED]
http://www.GodsOfMusic.com
Does the user 'mysql' have write
Im not sure what has gone wrong but the mysql.users table is set as
read only. I am trying to grant user privileges but cant because of
this. How can I change the status so that I can add to it?
I am logging in (localhost) using the (unchanged default) u root
account, so I know thats
On Monday 23 December 2002 03:05, Ray Kiddy wrote:
I had used MySQL's myisampack utility to pack my tables, which makes
them read-only, but now I want them to be write-able again.
I have used myisamchk --recover --unpack (tried -ru as well) and the
table is still read-only.
What
I had used MySQL's myisampack utility to pack my tables, which makes
them read-only, but now I want them to be write-able again.
I have used myisamchk --recover --unpack (tried -ru as well) and the
table is still read-only.
What is the actual incantation one must use here? I can backup
On Friday 20 December 2002 04:48, cable at ionbits dot net wrote:
i cant create SQl tables andoso cant del the tables.. it always shows
table is read only.. anyway to solve?
Is your table packed with myisampack utility?
Check also that MySQL server has permissions to write in these files
i cant create SQl tables andoso cant del the tables.. it always shows
table is read only.. anyway to solve?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
anyway to solve this SQL problems?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To
Have you checked that your network/database administrator has given you
write access to this database?
Phil.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 6:48 PM
To: [EMAIL PROTECTED]
Subject: Tables read only
i cant
Hi all,
I'm testing the fail-safety of InnoDB with MySQL, and I find that when
the data files are read-only, the process exits early instead of
returning an error code.
In the file innobase\os\os0file.c, the function os_file_handle_error()
does not recognize the error code 5, and so
1 - 100 of 170 matches
Mail list logo