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
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
--
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
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
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
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
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
- 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 following
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 now, you'll have
- 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 have tried reseting, flushing,
rebooting
the
server. Please
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
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 [EMAIL PROTECTED]
Sent: Tuesday
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
This is a handy page to bookmark, if you're doing replication:
http://www.mysql.com/doc/en
- 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:
Also, I am intersted in a way to reset the entire replication thing. In
other
14 matches
Mail list logo