values and they would be updated from the
matching ftp_server that did have values in the url_server and url_port.
I imagine that this might require a join and perhaps a temporary table.
Please advise.
Dirk Bremer - Senior Systems Engineer - Utility - AMS
NISC Lake St. Louis MO - USA Central
That appear to have been it, thanks to all for the assist and have a
great weekend!
Dirk Bremer - Senior Systems Engineer - Utility - AMS
NISC Lake St. Louis MO - USA Central Time Zone
636-755-2652 fax 636-755-2502
dirk.bre...@nisc.coop www.nisc.coop
-Original Message-
From: Johnny
. All servers are using
the same version of 4.1.22-community-nt.
I feel a bit naked without the replication so your assistance in helping
me getting it up and running will be very appreciated.
Dirk Bremer - Senior Systems Engineer - Utility - AMS
NISC Lake St. Louis MO - USA Central Time Zone
.
I followed the instructions here:
http://forums.mysql.com/read.php?26,9390,242387#msg-242387
With negative results.
Dirk Bremer - Senior Systems Engineer - Utility - AMS
NISC Lake St. Louis MO - USA Central Time Zone
636-755-2652 fax 636-755-2502
dirk.bre...@nisc.coop www.nisc.coop
Indiana has two time zones as I recall. The state is divided roughly in
half between the two.
Dirk Bremer - Senior Systems Engineer - Utility - AMS - NISC Lake St.
Louis MO - USA Central Time Zone
636-755-2652 fax 636-755-2502 [EMAIL PROTECTED] www.nisc.coop
-Original Message-
From: Hiep
-Original Message-
From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 27, 2006 22:40
To: Dilipkumar; Dirk Bremer; mysql@lists.mysql.com
Subject: RE: Mysqlcheck issues
The trouble with myisamchk is that it requires the server to
be offline
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 27, 2006 22:42
To: Dirk Bremer
Cc: mysql@lists.mysql.com
Subject: Re: Mysqlcheck issues
Dirk Bremer wrote:
I am using MySQL server 4.1.10 on Windows 2003 Server with MyISAM
tables. I have an issue
understand what is causing the service to abort.
Your thoughts?
Dirk Bremer - Senior Systems Engineer - ESS/AMS - NISC Lake St. Louis MO
- USA Central Time Zone
636-755-2652 fax 636-755-2503
[EMAIL PROTECTED]
www.nisc.coop
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
-digit number)
I have about 350 of these files and they all appear to be held open by
the mater, i.e. they cannot be deleted from Windows. I assume that these
files have something to do with replication.
How can I purge these files to a more manageable number?
Dirk Bremer - Senior Systems Engineer
query?
Dirk Bremer - Senior Systems Engineer - ESS/AMS - NISC Lake St. Louis MO
- USA Central Time Zone
636-755-2652 fax 636-755-2503
[EMAIL PROTECTED]
www.nisc.coop
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
the relay-bin
files. Thankfully, the relay-bin files are small in size, but I would
still like to prune them.
Thoughts?
Dirk Bremer - Senior Systems Engineer - ESS/AMS - NISC Lake St. Louis MO
- USA Central Time Zone
636-755-2652 fax 636-755-2503
[EMAIL PROTECTED]
www.nisc.coop
-Original
inserted, from lowest-ID to the highest-ID. This will prevent the query
from showing possible hundreds of results.
There are multiple customers in the table.
Dirk Bremer - Senior Systems Engineer - ESS/AMS - NISC Lake St. Louis MO
- USA Central Time Zone
636-755-2652 fax 636-755-2503
[EMAIL
I should add I ran a FLUSH LOGS on the master and this had no effect on
the relay-bin files.
Dirk Bremer - Senior Systems Engineer - ESS/AMS - NISC Lake St. Louis MO
- USA Central Time Zone
636-755-2652 fax 636-755-2503
[EMAIL PROTECTED]
www.nisc.coop
-Original Message-
From: Dirk
. There is also a corresponding file:
MAILCD3-relay-bin.index
In this instance, MAILCD3 is the name of the server. There are least 346
of the relay-bin files.
Dirk Bremer - Senior Systems Engineer - ESS/AMS - NISC Lake St. Louis MO
- USA Central Time Zone
636-755-2652 fax 636-755-2503
[EMAIL
limit 50)
order by ftp_transfers.queue.ident asc
I'm not in an immediate position to upgrade to 5.x at this point in time
and this is a non-critical issue for me. Thanks for you help and advice.
If someone has another solution, please chime in.
Dirk Bremer - Senior Systems Engineer - ESS/AMS - NISC
-Original Message-
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Monday, May 01, 2006 16:55
To: Dirk Bremer
Cc: mysql@lists.mysql.com
Subject: Re: Finding duplicates, etc.
Dirk,
I would like to know where there ar duplicate accounts that
do not have
duplicate
a way to accomplish number 3 but know that in the
given data set that this condition does occur.
Dirk Bremer - Senior Systems Engineer - ESS/AMS - NISC Lake St. Louis MO
- USA Central Time Zone
636-755-2652 fax 636-755-2503
[EMAIL PROTECTED]
www.nisc.coop
--
MySQL General Mailing List
For list
-Original Message-
From: David Godsey [mailto:[EMAIL PROTECTED]
Sent: Friday, February 17, 2006 08:42
To: Dirk Bremer
Cc: Gordon Bruce; [EMAIL PROTECTED]; gerald_clark;
mysql@lists.mysql.com; David Godsey
Subject: RE: Byte Swapping (Re Post)
Endianess is byte ordering not bit
Rather than changing the function of the mysqldump program, why not
massage its output to your specifications.
Dirk Bremer - Senior Systems Engineer - ESS/AMS - NISC Lake St. Louis MO
- USA Central Time Zone
636-755-2652 fax 636-755-2503
[EMAIL PROTECTED]
www.nisc.coop
-Original Message
and
little-endian, then if you can get the bytes in a string REVERSE()
should flip the order.
REVERSE would alter the order of the bytes. To convert between
big-endian and little-endian, I believe that you need to reverse the
order of the bits in either a byte or a word.
Dirk Bremer - Senior Systems
\. status.sql
\. active.sql
Save this file. Execute this file from the client. I did not try nesting
more than this example (1-level), but suppose it would work for more.
Note that the '\.' equates to the 'source' command.
Dirk Bremer - Senior Systems Engineer - ESS/AMS - NISC Lake St. Louis MO
- USA
).
Dirk Bremer - Senior Systems Engineer - ESS/AMS - NISC Lake St. Louis MO
- USA Central Time Zone
636-755-2652 fax 636-755-2503
[EMAIL PROTECTED]
www.nisc.coop
-Original Message-
From: Kieran Kelleher [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 28, 2005 16:21
To: Brian Dunning
Cc: mysql
request.)
I am using the command-line client. I have it working but it is off by
one-month, run as is, it is showing July data rather than August. I am
checking into it.
Dirk Bremer - Systems Programmer II - ESS/AMS - NISC St. Peters
USA Central Time Zone
636-922-9158 ext. 8652 fax 636-447-4471
- Original Message -
From: [EMAIL PROTECTED]
To: Dirk Bremer (NISC) [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, September 27, 2004 11:40
Subject: Re: Date Range
To compute the date range for two months ago. (if the current month is
September, this will return July's data
- Original Message -
From: [EMAIL PROTECTED]
To: Dirk Bremer (NISC) [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, September 27, 2004 14:30
Subject: Re: Date Range
I think you are very close but you are missing the LAST day of each month.
I think you need to change your WHERE
handy
for some things.
Dirk Bremer - Systems Programmer II - ESS/AMS - NISC St. Peters
USA Central Time Zone
636-922-9158 ext. 8652 fax 636-447-4471
[EMAIL PROTECTED]
www.nisc.cc
- Original Message -
From: Eamon Daly [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 20, 2004 13
the MySQL server complain about the logfile size from a
.cnf file? Should I be using a .cnf file and where should it be located? I
have but a single, small database with only two tables.
Dirk Bremer - Systems Programmer II - ESS/AMS - NISC St. Peters
USA Central Time Zone
636-922-9158 ext. 8652 fax 636
4.1.x has a lot more date/time functions, but I'm wondering if
something similar can be arrived at under the version that I am using.
Dirk Bremer - Systems Programmer II - ESS/AMS - NISC St. Peters
USA Central Time Zone
636-922-9158 ext. 8652 fax 636-447-4471
[EMAIL PROTECTED]
www.nisc.cc
09:23:44 | 00:33:34 |
2014 |
| 1314 | 2004-06-11 09:24:32 | 2004-06-11 09:24:45 | 00:00:13 |
13 |
+---+-+-++--
--+
15 rows in set (0.00 sec)
Dirk Bremer - Systems Programmer II - ESS/AMS - NISC St. Peters
USA
Looking at the results further reveals that a numeric subtraction is being
performed on the two datetime fields rather than a date-type subtraction.
Any thoughts on how to perform a date subtraction in version 4.0.18?
Dirk Bremer - Systems Programmer II - ESS/AMS - NISC St. Peters
USA Central
Bremer - Systems Programmer II - ESS/AMS - NISC St. Peters
USA Central Time Zone
636-922-9158 ext. 8652 fax 636-447-4471
[EMAIL PROTECTED]
www.nisc.cc
- Original Message -
From: gerald_clark [EMAIL PROTECTED]
To: Dirk Bremer (NISC) [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, June
Bingo, Shawn wins the virtual beer(s). I never looked at the unix_timestamp
function. Thanks to everyone else and wishing you virtual beers as well!
Dirk Bremer - Systems Programmer II - ESS/AMS - NISC St. Peters
USA Central Time Zone
636-922-9158 ext. 8652 fax 636-447-4471
[EMAIL PROTECTED
(*)?
Dirk Bremer - Systems Programmer II - ESS/AMS - NISC St. Peters
USA Central Time Zone
636-922-9158 ext. 8652 fax 636-447-4471
[EMAIL PROTECTED]
www.nisc.cc
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
select job_coop as 'Job/Coop', count(*) as Count from queue group by
job_coop order by Count;
The other alternative is to omit the 'as Count' and use this query:
select job_coop as 'Job/Coop', count(*)
from queue
group by job_coop
order by 2;
where the '2' in the 'order by' is the
At 16:03 -0500 4/20/04, Dirk Bremer (NISC) wrote:
I have a couple of questions concerning the MySql client program.
1. Are the option for the client program, i.e. --auto-rehash, etc.
documented anywhere? I searched the included HTML file and could not find
a
reference to the client options
the
database server program residing on a different machine?
Dirk Bremer - Systems Programmer II - ESS/AMS - NISC St. Peters
USA Central Time Zone
636-922-9158 ext. 8652 fax 636-447-4471
[EMAIL PROTECTED]
www.nisc.cc
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
I have a simple table where one of the columns is named queue_time and is
defined as a timestamp-type. I would like to query this table for all rows
where the queue_time equals the current date. I an a newbie and have been
wrestling with the docs for a solution. You help will be appreciated.
Dirk
- Original Message -
From: Victor Pendleton [EMAIL PROTECTED]
To: 'Dirk Bremer (NISC) ' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, April 16, 2004 15:06
Subject: RE: SQL Query Question
WHERE queue_time = Now() + 0
Are you wanting just the date or the datetime?
-Original
- Original Message -
From: Victor Pendleton [EMAIL PROTECTED]
To: 'Dirk Bremer (NISC) ' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, April 16, 2004 15:57
Subject: RE: SQL Query Question
If your data is stored in the following format
2004-04-16 00:00:00
you can do WHERE
39 matches
Mail list logo