;"ca15027"
"Test" "Normal" "" "0"
I'd like to update the url_server and url_port fields in this example
for B15127 and B15227 to the values contained in B15027. There are other
examples as well. I w
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
rror-log.
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.n
well, stupid, but have
struggled with it the last few days to no avail. 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 Syste
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: 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 Se
> -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 se
x27;t 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.mysq
transfers.queue.test = @test
# and ftp_transfers.queue.cycle = @cycle
# and (@cur_date <= ftp_transfers.queue.queue_time)
# and param5 not like '%ebi%'
order by ftp_transfers.queue.ident desc limit 50)
order by ftp_transfers.queue.ident asc
I'm not in an immediate position to upgrade to 5
ectory. 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
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
were
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
[
erence to deleting 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.
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
a six-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 Eng
> -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 dupli
port on them.
I can't figure out 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
> -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)
>
>
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 Mess
is opposite between big-endian 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 eith
contains lines like this:
\. today.sql
\. 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
ctive).
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:
- 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 mont
- 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 curre
ore than one statement per
> 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-9
prove 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]&
ll. Why did 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 ex
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
issue.
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: "gerald_clark" <[EMAIL PROTECTED]>
To: "Dirk Bremer (NISC)" <[EMAI
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
1 09:03:30 | 2004-06-11 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
rsion 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]
w
> > 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
the count(*)?
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]
> 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
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
- 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
- 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()
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
39 matches
Mail list logo
