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
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
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
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/
I
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
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
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';
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
Hi,
aren't there any other clues before restarting?
2009/5/20 Duane Hebert duane.heb...@group-upc.com
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
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
On Wed, May 20, 2009 at 12:02 PM, Gary Smith g...@primeexalia.com 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
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,
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
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 gto...@ffn.com 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 :
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=
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
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
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
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
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
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
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
22 matches
Mail list logo