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
T
have same hardware configration.
> >>
> >> Now i want to know, should i use slave server for fetching read only
> >> queries.
> >> if yes, then how ?.
> >
> > You could do it in the application logic, i.e. create a separate
> > connection to the slave
gt;>
>> Now i want to know, should i use slave server for fetching read only
>> queries.
>> if yes, then how ?.
>
> You could do it in the application logic, i.e. create a separate
> connection to the slave server that you use for reading, or perhaps this
> would
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 fet
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
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
At
t; 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,
> then restarting will allow the database to be in read-only mode, but
> need
> -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
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
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
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
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
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
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
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
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 be
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 indi
t; -Sheeri
>
Thanks Sheeri,
when I combine your suggestion (3) with using merge 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 databas
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 to use a different
&
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 to
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
the
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
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, '
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 t
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 righ
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 num
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
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
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 s
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
n some perl client tries 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
> pr
(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. mysqld runs under
user mysql. Mysql datadir and ALL database files are owned by it and
have 770 privilege mas
: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 lates
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 has
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 direct
AIL 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 pages.
>
>The questi
--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 pages.
The qu
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
-- Lee Zelyck <[EMAIL PROTECTED]> wrote:
> 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 d
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
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
> **
> #1
:
> 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
> **
&g
5.2 .
> the edition is MySQL-3.23.58-2.aix5.1.ppc
> but when I used phpmyadmin to manage the mysql
> it told me
>
**
&g
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
te 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 tab
I am 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
anyon
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 Gener
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 Gener
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&#
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
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 attribu
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
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
k.
Ownership 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.
ient
Best Regards
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: &#
e-you-installed
> > 3.- try using mysql client
> >
> > Best Regards
> > 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
> > >
>
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 'u
et 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.
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 th
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.
-
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 & t
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.
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
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 check
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 check
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 [f
bject: Re: Strategies for optimizing 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
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
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. E
); no range searches with <, >, BETWEEN, etc.; and you
can 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? M
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)
>
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 en
ou running?
When I execute grant statements, 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.&quo
At 11:00 AM 8/17/2003 +0200, Petre Agenbag wrote:
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
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 b
d 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?
-Benne
between different machines. At
this point, it would be much easier to change the one little thing (it's
always one little thing) that's probably 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 d
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 cal
new machine and load the tracerlock
database, "show tables" shows all the tables 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
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`)?
==Efforts
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
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 prob
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 su
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
--
M
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
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.
ds 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?
&g
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 privil
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 '
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
Gods Of Music Reviewer/Editor
[EMAIL PROTECTED]
http://www.GodsOfMusic.com
>
> Does the user
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
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 not
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
> tabl
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
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
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
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 un
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
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
1 - 100 of 174 matches
Mail list logo
