MySQLHotCopy - No tables to hot-copy HUH?!

I have a problem using mysqlhotcopy. Everything was fine until I recently moved to a different server. Old one was running mysql 4.0.15 on FreeBSD 4.8, new is mysql 4.0.16 on FreeBSD 4.9. The error returned is "No tables to hot-copy at /usr/local/bin/mysqlhotcopy line 379." I ran w/ --debug and h

Round Robin Replication, Add a server; Renumber

I currently have three mysql machines replication from A-B-C-A type fashion. I need to replace A. I am thinking that I could add D and have it pull from C. Then once A is removed restart D as A. Is this a good way to do this or is there a better way that I should do this? Thanks! Lewis -- MySQL

Re: Need Distinct and Min...

yup, that was exactly it. Sorry about the simple question. I didn't realize that was what group by does Lewis - Original Message - From: "Roger Baklund" <[EMAIL PROTECTED]> To: "mysql" <[EMAIL PROTECTED]> Cc: "Lewis Watson" <[EMAIL P

Need Distinct and Min...

I have a table with three fields. In the first field I have a range of numbers 1-20; all repeated more than once. In the third field I have a number ranging from 1 to 20 in each row. I need to choose the lowest amount in the third column for each distinct value in the fist column. Will some

Delete duplicate rows

I need to delete duplicate rows. Each row that is in the table has an exact duplicate of itself. There are four columns. No one column could be defined as a primary key; however, two columns together could. What's going to be the best way to do this? Thanks. Lewis mysql, thanks -

Re: Replication Errors *NEWEST*

NEWEST** I am now getting this error while trying to Replicate to a second MySQL server. 021125 0:41:01 Slave: Failed reading log event, reconnecting to retry, log 'bsd1-bin.001' position 73 021125 0:41:01 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replicatio

Replication Problems

I am getting this error while trying to Replicate to a second MySQL server. 021124 23:40:25 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position 4 021124 23:40:25 Error reading packet from server: Binary log is not open (server_errno=2000) I have

MySQL and amanda

Hey MySQL users! I have been using amanda as backup software. It seems that it is working fine as a backup for the MySQL data directory but I am wondering is there a better way to backup up the databases? They are production Db's so I really do not want to stop the server, but isn't this necessary

Re: Lost Connection

- Original Message - From: "Mark Matthews" <[EMAIL PROTECTED]> To: "Lewis Watson" <[EMAIL PROTECTED]> Sent: Thursday, October 24, 2002 8:40 PM Subject: Re: Lost Connection > Lewis Watson wrote: > > > >>>I am getting this same error. I

Re: Lost Connection

> > > > I am getting this same error. I have tried reseting, flushing, rebooting the > > server. Please let me know if you find anything on this... > > Thanks. > > Lewis > > This is RedHat GLIBC upgrade badnessSearch the mailing list over the > last 4 weeks, you'll see what I mean. > > For no

Re: Lost Connection

- Original Message - From: "Mauro Romano Trajber" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 24, 2002 4:09 PM Subject: Lost Connection > Hi > Im trying to connect to a remote mysql server (/usr/local/mysql/bin/mysql -u > root -h myhost -p ) > and i get the follow

Re: Replication Error

- Original Message - From: "walt" <[EMAIL PROTECTED]> To: "Lewis Watson" <[EMAIL PROTECTED]> Cc: "mysql" <[EMAIL PROTECTED]> Sent: Tuesday, October 22, 2002 2:08 PM Subject: Re: Replication Error > Lewis Watson wrote: > > > A

Re: Replication Error

;Jeff Kilbride" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; "Lewis Watson" <[EMAIL PROTECTED]> Cc: "mysql" <[EMAIL PROTECTED]> Sent: Tuesday, October 22, 2002 2:45 PM Subject: Re: Replication Error > RESET MASTER > RESET SLAVE > > Thi

Re: Replication Error

Also, I am intersted in a way to reset the entire replication thing. In other words, just remove all hints of replication and start over... Is there a way I can do this? Thanks. Lewis - Original Message - From: "Lewis Watson" <[EMAIL PROTECTED]> To: "mysql"

Replication Error

I had replication running fine between two mysql server machines on linux. Then I added yet another slave but goofed and put in the same server-id. Now I am getting errors on the master server and proccesses being killed and restarted. It comes with this error. ./bin/safe_mysqld: line 273: 12250 S