Re: Select rows containing identical values in two columns

I have a table that has a column with the id of the person that created the row. In another column in the same row there is a column with the id of the person that modified that row. Is there a way to write a SELECT statement that will return all the rows where the value in the creation colum

Re: secure mysql port

Of course the best way is to use OS's firewall; iptables, ipfw or pf. Regards, Kelly Opal wrote: > > Hi > Is there any way to restrict access to the tcp port on mysql. I only > want my 5 class C's to be able to access the port but it is a public > server. > > Any help would be greatl

Re: MySQL - master/slave replation question

I wrote this Nagios (http://nagios.org/ - a monitoring tool) specific Perl plugin a few years ago, but you can easily use it for your needs. The version I have online does not support mysql 5.0+ but that is easily remedied.. info; http://www.byveka.com/files/README.check_replic script;

Select rows containing identical values in two columns

I have a table that has a column with the id of the person that created the row. In another column in the same row there is a column with the id of the person that modified that row. Is there a way to write a SELECT statement that will return all the rows where the value in the creation co

ERROR 3 (HY000): Error writing file (Errcode: 5)

I'm baffled as to why this isn't working... I am 'root'. I have full perms and all that stuff. I use these DBs every day. Yesterday, I deleted a table that had FKs because I wanted to change a column name, but couldn't because of the restraint *sigh*. After that I couldn't re-create the table agai

Re: innodb rollback question

How do you import the data? Load data from file is faster thought so better to export myisam -> file and then you do load data from file make sure you set autocommit=0 to make it faster On Nov 17, 2007 12:29 AM, B. Keith Murphy <[EMAIL PROTECTED]> wrote: > I have something to throw out. I just

Re: innodb rollback question

Use smaller transactions that don't have 140 million rows. When attempting an action with important data, make sure you can survive the actions failure. If you can't, then you need to think of a different way of doing it that will allow a recoverable failure. - Original Message From:

RE: Problem with master/slave replication

From: B. Keith Murphy [mailto:[EMAIL PROTECTED] > show slave status after it stops copying should give you some type of > error information about the failure. What does it show? In addition to the error, what do the following fields show? Slave_IO_Running Slave_SQL_Running Seconds_Behind_Mast

Re: Problem with master/slave replication

Ryan, show slave status after it stops copying should give you some type of error information about the failure. What does it show? Keith Ryan Klein wrote: I am having an issue that I cannot determine the cause. We have a master server that is actually a production server and a slave server

Problem with master/slave replication

I am having an issue that I cannot determine the cause. We have a master server that is actually a production server and a slave server that is a fall back but after around 10 days, it stops coping data and the servers fall out of sync. Here is my my.cnf file for the master server: key_buffer

innodb rollback question

I have something to throw out. I just got done importing 140 million rows from a myisam table to a innodb table. While it worked I had a thought about 3/4ths of the way through. What if the transaction had been canceled about 130 million rows in? It would have taken weeks to roll back. Th