best configuration for ip failover

This is our situation: We have two servers running RHES3 with samba connections to a server running RHES4. (No, it's not dns. Believe me when I say I don't ever want to go through *that* pain again) Our ES4 server contains shared data that is not controlled through cvs. Our two ES3 servers contain

question about showing db and/or table size

I know there must be a command line query to show the size of the database or of specific tables. What is it? I've been unable to find anything in the online manual (of course that presupposes I've been looking in the right place). Thanks, Susan -- MySQL General Mailing List For list archives:

RE: Temporary table question

Thanks y'all. It seems that the temporary table is the way I want to go for my particular situation. Susan -Original Message- From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED] Sent: Thursday, October 16, 2003 11:05 AM To: Nitin; Susan Ator; [EMAIL PROTECTED] Subjec

Temporary table question

I would like to know the circumstances in which a temporary table would be used. What is the rationale behind temporary tables? I have searched the manual and the 'net but only find out information about creating or manipulating them. Thanks, Susan -- MySQL General Mailing List For list archive

RE: Why is this query not working?

Thank you. Changing it to: $max_esn = mysql_result($max_esn_result,$i); did the trick. sa -Original Message- From: Jennifer Goodie [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 6:33 PM To: Susan Ator; [EMAIL PROTECTED] Subject: RE: Why is this query not working

Why is this query not working?

id` ) ) TYPE = MYISAM AUTO_INCREMENT = 601; When I run: SELECT MAX(esn) FROM address in phpMyAdmin I get the expected result which is 515. What in the world am I missing?!?!?! Susan Ator Online Services Engineer National Public Radio Distribution Division [EMAIL PROTECTED]

update to 4.0 mySQL question

I have updated mySQL to the 4.0.13-standard and had no problems UNTIL I attempted to run mysql_fix_privileges. This is the error I get: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) /tmp is: drwxrwxrwt6 root root 4096 Jun 23 1

RE: query question

Thank y'all very very much. Each day I learn something new ;) susan -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Thursday, June 12, 2003 1:35 PM To: Susan Ator; [EMAIL PROTECTED] Subject: RE: query question [snip] Is there a way to check if a field

query question

Is there a way to check if a field has x number of characters in it? I have a table with a column (phone) which, for the moment is varchar(25). I need to find those entries which have less than 10 characters. Can this be done? Thanks susan -- MySQL General Mailing List For list archives: http

RE: Join problem

Friday, May 30, 2003 3:42 PM To: [EMAIL PROTECTED] Cc: Susan Ator Subject: RE: Join problem > Well, I'm running 3.23.54 on Red Hat 7.3. Given this, how in the world > do I accomplish the following: > > I have these tables: > dacspriv - with d

RE: Join problem

Well, I'm running 3.23.54 on Red Hat 7.3. Given this, how in the world do I accomplish the following: I have these tables: dacspriv - with dacspriv_id,dacspriv_name,short_name users - with user_id,username dacs_access - with dacsaccess_id,dac

Join problem

users.username='sator') Susan Ator Online Services Engineer National Public Radio Distribution Division [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]