But my updates are coming from a web server on the localhost so will
this still block connections? Sounds like the answer is no.
I forgot to say that I am running MySql 5.0 on Solaris 10 if that makes
a difference.
-Original Message-
From: Rolando Edwards [mailto:redwa...@logicworks.ne
Do 'service mysql restart --skip-networking'
This prevents all TCP/IP connections
You can login as r...@localhost and the client program will use the socket file
rather than TCP/IP.
Do all your DDL work.
When done, 'service mysql restart'
Rolando A. Edwards
MySQL DBA (CMDBA)
155 Avenue of the
Well, in 90% of our cases it is. Most often caused by some dumb-ass (usually
me) doing an INSERT or UPDATE on the slave on accident since I'm often
logged into it doing SELECTs but I sometimes need to 'debug' or 'test'
something and forget which box I'm on. So I happily do my altering of the
slave'
How do I start MySQL in maintenance/single user mode so I can create
indexes on a table that is being updated often?
I prefer for the update transactions to fail immediately with a
connection error rather than to wait for a lock to be released.
In Oracle you can startup nomount. What is the equ
Please note that this is *NOT* a way to "get them synched again"
In fact if you have to skip a replication statement on the slave then it is
usually a sign your slave has different data than you master already. Skipping
statements/errors may keep replication running, but you're just masking
pr
Hello,
I would like to do a select on a table to get back the IDs of some of
the records.
Then take those IDs and do a single update using a WHERE clause like
(recordID IN (2,44,21))
My question is:
Can I build a string using a cursor that has all of the IDs and then
issue an update using the s
I already posted about this:
http://lists.mysql.com/mysql/215100
or google for "moving from 3.23.58 to 5.0.45"
I never recommend to install mysql as default package, is way too limiting.
I manage to have as many mysql installations on the same server as the
hardware can carry,
but not software
Yeah Daevid! I know very well the issue!
first set the slave to READ ONLY
[mysqld]
read-only
then there is a configuration option to tell the server to skip some type of
errors automatically
slave-skip-errors=
http://dev.mysql.com/doc/refman/5.1/en/replication-options-slave.html#option_mysqld
OK I tried this exact syntax and I get the same error. I tried it on mysql
client for 6.0.10
On Wed, May 20, 2009 at 2:22 PM, Gavin Towey wrote:
> Interesting. This syntax is only supposed to be available as of 5.4, but
> it doesn't even work there. The reference I found was at :
> http://dev.
We have a master / slave setup and as you know, one bad query can ruin your
whole day. Or if you accidentally write to the slave when you meant to write
to the master, or any number of other things that break the fragility of a
replication setup.
The magic incantation to get them synched again se
Hi,
I don't know what Linux distro you're using, but I'd make a backup of
/var/lib/mysql dir before you do anything (in case the mysql package
decides to nuke your stuff). If you have a dump of your dbs, that's fine
too. And maybe a backup of your my.cnf.
Just install the new mysql package,
Interesting. This syntax is only supposed to be available as of 5.4, but it
doesn't even work there. The reference I found was at :
http://dev.mysql.com/tech-resources/articles/mysql-54.html
But I couldn't find other references to the new signal support.
This is listed as the example on that p
Hi Folks,
I am getting syntax error with the mysql signal. I have a trigger
that needs a signal for raising an error condition if a row with
specific value is removed.
CREATE TRIGGER my_trig BEFORE DELETE ON my_tbl
FOR EACH ROW BEGIN
DECLARE mysig CONDITION FOR SQLSTATE '45000';
Michael,
Thanks. Thats what I was looking for, I just couldn't remember what it was.
Gary
From: Michael Dykman [mdyk...@gmail.com]
Sent: Wednesday, May 20, 2009 9:17 AM
To: Gary Smith
Cc: mysql@lists.mysql.com
Subject: Re: Large insert question
On Wed,
Hi,
aren't there any other clues before restarting?
2009/5/20 Duane Hebert
> I'm having a problem where every day or so, the mysql service is
> restarting. This is MySql 5 running on a win2003 server.
> The error in the event log says:
>
> Faulting application mysqld-nt.exe, version 0.0.0.0, fa
On Wed, May 20, 2009 at 12:02 PM, Gary Smith wrote:
> Hello,
>
> I'm working on a project that will be inserting very large text streams into
> a database. They range from 100K to 100M. I suspect that the average will
> be about 2M per insert. This is a low volume (under 20 inserts per day).
Hello,
I'm working on a project that will be inserting very large text streams into a
database. They range from 100K to 100M. I suspect that the average will be
about 2M per insert. This is a low volume (under 20 inserts per day). I don't
really need to optimize much on this but I had a qu
I'm having a problem where every day or so, the mysql service is restarting.
This is MySql 5 running on a win2003 server.
The error in the event log says:
Faulting application mysqld-nt.exe, version 0.0.0.0, faulting module
mysqld-nt.exe, version 0.0.0.0, fault address 0x001fa173.
In MySql's
On Wed, May 20, 2009 at 10:27:51AM +0200, Webmaster Studio Informatica wrote:
> Hi,
>
>
>
> I need to upgrade Mysql 4 to Mysql 5 on Linux.
>
>
>
> I will uninstall version 4 and install version 5.
>
>
>
>
>
> With uninstallation usually database files remain in /var/lib/mysql/
>
>
This Message was undeliverable due to the following reason:
Your message was not delivered because the destination computer was
not reachable within the allowed queue period. The amount of time
a message is queued before it is returned depends on local configura-
tion parameters.
Most likely ther
On May 20, 2009, at 1:27 AM, Webmaster Studio Informatica wrote:
I need to upgrade Mysql 4 to Mysql 5 on Linux.
Sometimes
I will uninstall version 4 and install version 5.
With uninstallation usually database files remain in /var/lib/mysql/
I want to know if with the installation of My
Hi,
I need to upgrade Mysql 4 to Mysql 5 on Linux.
I will uninstall version 4 and install version 5.
With uninstallation usually database files remain in /var/lib/mysql/
I want to know if with the installation of Mysql 5 those database will be
"recognized and imported" to
22 matches
Mail list logo
