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 here is the result... mysqlhotcopy drew /storedarea/drew -u alloweduser -p notpostedhere --debug Filtering tables with '(?-xism:.*)' $VAR1 = [ { 'index' = [], 'src' = 'drew', 'raid_dirs' = [], 'tables' = [], 'files' = [ 'homework.MYD', 'homework.MYI', 'homework.frm', 'teacher.MYD', 'teacher.MYI', 'teacher.frm', 'users.MYD', 'users.MYI', 'users.frm' ], 't_regex' = '.*', 'target' = '/storedarea/drew' } ]; No tables to hot-copy at /usr/local/bin/mysqlhotcopy line 379. Here is a show tables from the terminal... mysql show tables; ++ | Tables_in_drew | ++ | homework | | teacher| | users | ++ 3 rows in set (0.00 sec) I would greatly appreciate some help here. Thanks. Lewis -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 someone help me out with this query? Thanks. Lewis mysql, thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 added the following to the master: [mysqld] socket=/tmp/mysql.sock server-id=1 log-bin And added this to the slave: [mysqld] server-id=2 master-host=192.168.0.16 master-user=replicate master-password=mypasshere It looks like the bin files are not being created on the master server. I could find very little regarding this problem. Any ideas? Thanks. Lewis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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',replication resumed in log 'bsd1-bin.001' at position 73 021125 0:41:17 Error reading packet from server: Could not open log file (server_errno=2) 021125 0:41:17 Slave: Failed reading log event, reconnecting to retry, log 'bsd1-bin.002' position 86 021125 0:41:17 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'bsd1-bin.002' at position 86 021125 0:41:17 Error reading packet from server: Could not find first log (server_errno=65535) 021125 0:41:37 Slave thread killed while waiting to reconnect after a failed read 021125 0:41:37 Slave thread exiting, replication stopped in log 'bsd1-bin.002' at position 86 021125 0:41:37 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at position 4 I have added the following to the master: [mysqld] socket=/tmp/mysql.sock server-id=1 log-bin [safe_mysqld] socket=/tmp/mysql.sock server-id=1 log-bin And added this to the slave: [mysqld] server-id=2 master-host=192.168.0.16 master-user=replicate master-password=mypasshere Any ideas on this? Thanks. Lewis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 to properly backup up the db directory? Thanks. Lewis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 following answers. on the server : /usr/local/mysql/bin/safe_mysqld: line 273: 31252 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21 Number of processes running now: 1 mysqld process hanging, pid 31255 - killed 021024 17:52:19 mysqld restarted on the client: ERROR 2013: Lost connection to MySQL server during query PS:root@myhost have permission to connect to server on mysql.user. PS2:the same situation occurs when a try to connect via telnet on port 3306 PS3:Linux RedHat 7.3 / MySQL 3.23.53 build from source!! Thanks for any help. Mauro Romano Trajber 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 now, you'll have to use our (MySQL AB's) binaries, as we compile and link statically with our own version of GLIBC, so you don't have this problem. Download 3.23.53a, and this problem goes away. -Mark Hey Mark, I am running FreeBSD. Thanks, Lewis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 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 to use our (MySQL AB's) binaries, as we compile and link statically with our own version of GLIBC, so you don't have this problem. Download 3.23.53a, and this problem goes away. -Mark Hey Mark, I am running FreeBSD. Thanks, Lewis Are you using your own binary, or one of ours? -Mark OPS. Sorry, I have had my head up this bsd machine so intensely that I forgot which machine it happened on... Please forgive me, it did happen on a Redhat 7.0? 7.1 build of Redhat! I compiled it from source ./config --prefix=/usr/local. I am so sorry. This is a production machine... What's the best way to upgrade from this to 3.23.53a? I greatly appreciate your help. Lewis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21 I have tried flushing both master and slave. I have also reset eac. I have also deleted the log files and the master.info file on the slave. Nothing is allowing these the master and original slave to communicate anymore. Any ideas? Thanks, Lewis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 [EMAIL PROTECTED] Sent: Tuesday, October 22, 2002 12:06 PM Subject: 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 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21 I have tried flushing both master and slave. I have also reset eac. I have also deleted the log files and the master.info file on the slave. Nothing is allowing these the master and original slave to communicate anymore. Any ideas? Thanks, Lewis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication Error
Thats exactly what I did. Still the same error Show master status shows it running with a positive number. Slave is running. Netstat -na shows them connected. I read that one page for two hours last night... over and over and over :) Thanks. Lewis - Original Message - From: 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 This is a handy page to bookmark, if you're doing replication: http://www.mysql.com/doc/en/Replication_SQL.html --jeff - Original Message - From: walt [EMAIL PROTECTED] To: Lewis Watson [EMAIL PROTECTED] Cc: mysql [EMAIL PROTECTED] Sent: Tuesday, October 22, 2002 12:08 PM Subject: Re: Replication Error Lewis Watson wrote: 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, October 22, 2002 12:06 PM Subject: 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 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21 I have tried flushing both master and slave. I have also reset eac. I have also deleted the log files and the master.info file on the slave. Nothing is allowing these the master and original slave to communicate anymore. Any ideas? Thanks, Lewis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Lewis, As far as I've been able to see, there are only a few files that control replication. I'd try removing replication stuff from my.cnf (server-id, log-bin, etc..) and stopping mysql on both the master and the slave. Then delete log files on the master including the *.index file. I'd then delete any files on the slave that deal with replication (master.info). Once all this is done, try restarting the master to see if it still has problems. walt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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: 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 Lewis, As far as I've been able to see, there are only a few files that control replication. I'd try removing replication stuff from my.cnf (server-id, log-bin, etc..) and stopping mysql on both the master and the slave. Then delete log files on the master including the *.index file. I'd then delete any files on the slave that deal with replication (master.info). Once all this is done, try restarting the master to see if it still has problems. walt Thanks Walt. I will try that... Lewis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php