connection problems

2004-07-28 Thread Andrew Hall
Greetings, I have what I hope is an easy problem. I have installed mysql 4.0.20 and when I execute mysqladmin to set the root password using the -h flag my hostname is truncated, and I get a connection refused message. The hostname on this box is a fqdn like blah.1.2.3.net. My command line is

RE: connection problems

2004-07-28 Thread Andrew Hall
Yes I have. The hostname of the box returned with 'hostname' is the fqdn and is in the format of blah.1.2.3.net. Drew On Wed, 2004-07-28 at 17:16, Victor Pendleton wrote: Can you check the host name again? You have a five segment address. -Original Message- From: Andrew Hall

RE: connection problems

2004-07-28 Thread Andrew Hall
Message- From: Andrew Hall To: Victor Pendleton Cc: '[EMAIL PROTECTED] ' Sent: 7/28/04 4:35 PM Subject: RE: connection problems Yes I have. The hostname of the box returned with 'hostname' is the fqdn and is in the format of blah.1.2.3.net. Drew On Wed, 2004-07-28 at 17:16

RE: connection problems

2004-07-28 Thread Andrew Hall
apologies I was reading an ip address. Have you tried logging in from the server itself? Since this is the initial install I think root needs to log in from the localhost. -Original Message- From: Andrew Hall To: Victor Pendleton Cc: '[EMAIL PROTECTED] ' Sent: 7/28/04 4:35 PM

Re: replication/InnoDB errors

2003-12-10 Thread Andrew Hall
Greetings, Didn't find any fields in table 'blah' 031208 18:15:16 InnoDB error: Cannot find table db/blah from the internal data dictionary of InnoDB though the .frm file for the table exists. Maybe you have deleted and recreated InnoDB data files but have forgotten to delete the

replication/InnoDB errors

2003-12-08 Thread Andrew Hall
. Thank you in advance, Andrew Hall -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

replication question

2003-12-05 Thread Andrew Hall
Greetings, Firstly I have searched the archives and received exactly 0 results returned for 'START SLAVE 1064' so... I have a mysql server I wish to replicate, its running 3.23.54. I have two test FreeBSD 5.1 servers I installed and from ports version 3.23.58. I completed the following steps

RE: replication question

2003-12-05 Thread Andrew Hall
DUH!! I should have tried that... Thank you! Drew On Fri, 2003-12-05 at 15:49, Victor Pendleton wrote: Try slave start -Original Message- From: Andrew Hall [mailto:[EMAIL PROTECTED] Sent: Friday, December 05, 2003 2:46 PM To: [EMAIL PROTECTED] Subject: replication question

[Fwd: RE: replication question]

2003-12-05 Thread Andrew Hall
Didn't have the list cc-ed. -Forwarded Message- From: Andrew Hall [EMAIL PROTECTED] To: Mike Johnson [EMAIL PROTECTED] Subject: RE: replication question Date: Fri, 05 Dec 2003 16:17:14 -0500 Ok, at this point it appears my replication is working, but I have two questions

Re: Off Topic: MySQL Icons

2003-12-04 Thread Andrew Hall
Try google images... It's where I go every time I need to find an image that I don't have on hand. Drew On Thu, 2003-12-04 at 18:01, Daniel Kasak wrote: Hi all. I'm prettying up my Gnome desktop, and I'm after a MySQL icon for my MySQLCC launcher. Anyone know of some icons? -- Daniel

RE: mysql disaster recovery

2003-12-03 Thread Andrew Hall
excellent replication facility rather than NFS mount a drive. Having your data on an NFS mounted drive will significantly degrade the performance of your database. Replication will not. John Griffin --Original Message-- From: Andrew Hall [mailto:[EMAIL PROTECTED] Sent: Tuesday, December

mysql disaster recovery

2003-12-02 Thread Andrew Hall
Greetings Gurus, I have a mysql server that I need to create a disaster recovery system for. What I am planning on doing is putting the data dir on a NFS mounted directory so that I can start mysql on either of two servers in case one dies. The inbound connections would be load balanced in a