Re: Missing database file names

2010-06-05 Thread Jesse F. Hughes
Jesse F. Hughes je...@phiwumbda.org writes: Jesse F. Hughes je...@phiwumbda.org writes: r...@pw:/var/lib/mysql/mythconverg# myisamchk -o recorded.MYI Warning: option 'key_buffer_size': unsigned value 18446744073709551615 adjusted to 4294963200 Warning: option 'read_buffer_size': unsigned

Re: Missing database file names

2010-06-04 Thread Jesse F. Hughes
Is it possible to build a .MYI file from scratch? I have found a file that I believe is recorded.MYD. I have the .frm file as well, but I don't think that recorded.MYI survived the file system event. -- No feeling sympathy for mathematicians who start marching with signs like 'Will work for

Re: Missing database file names

2010-06-04 Thread Jesse F. Hughes
(I emailed this to Martin and Jaime rather than to the discussion group, so I'm re-sending it.) Martin Gainty mgai...@hotmail.com writes: Jesse ..please keep us apprised on your progress..we would like to know how fubar the db can be before it becomes 'unrecoverable' Well, I'm not having much

Re: Missing database file names

2010-06-04 Thread Jesse F. Hughes
Jesse F. Hughes je...@phiwumbda.org writes: r...@pw:/var/lib/mysql/mythconverg# myisamchk -o recorded.MYI Warning: option 'key_buffer_size': unsigned value 18446744073709551615 adjusted to 4294963200 Warning: option 'read_buffer_size': unsigned value 18446744073709551615 adjusted

Re: Missing database file names

2010-06-03 Thread Jesse F. Hughes
Dan Nelson dnel...@allantgroup.com writes: In the last episode (Jun 02), Jesse F. Hughes said: After a recent hard drive kerfluffle and the results of fsck, I'm left with a slew of jumbled database files. The file command can tell me the file types, like so: #15901614: MySQL table

Re: Missing database file names

2010-06-03 Thread Jesse F. Hughes
Dan Nelson dnel...@allantgroup.com writes: In the last episode (Jun 02), Jesse F. Hughes said: After a recent hard drive kerfluffle and the results of fsck, I'm left with a slew of jumbled database files. The file command can tell me the file types, like so: #15901614: MySQL table

Missing database file names

2010-06-02 Thread Jesse F. Hughes
the mythtv database the same as before, but how can I tell which file is which? Any ideas? Thanks much. -- Jesse F. Hughes Me: Quincy, there's only *one* Truth, isn't there? Quincy (age 4): Yeah, and it's *mine*. -- A lesson in postmodernism goes awry. -- MySQL

Need help with query optimization

2010-03-16 Thread Jesse
? Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

What is unusually high for the # of connections to MySQL?

2010-02-25 Thread Jesse
to a WS03 server tonight in hopes that the issue is the O/S. Can anyone fill me in? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: What is unusually high for the # of connections to MySQL?

2010-02-25 Thread Jesse
not executed such a function in my code. Thanks, Jesse - Original Message - From: Claudio Nanni To: Jesse Cc: mysql@lists.mysql.com Sent: Thursday, February 25, 2010 6:28 PM Subject: Re: What is unusually high for the # of connections to MySQL? It depends, but 100

MySQL server has gone away...

2009-03-24 Thread Jesse
server has gone away This is driving me absolutely nuts. I don't see any errors in the Event Viewer, or the MySQL error log.Does anyone know of any reasons that this might happen? Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: MySQL server has gone away...

2009-03-24 Thread Jesse
are either connected at the time, or attempting to connect. Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: MySQL server has gone away...

2009-03-24 Thread Jesse
the .net connecter too, but this is a classic .asp application, so ODBC seemed to be my only choice. I'll try increasing the connection time out and see if that helps. Does the IIS memory pooling have anything to do with this, or is it a completely separate thing? Thanks, Jesse -- MySQL

Re: MySQL server has gone away...

2009-03-24 Thread Jesse
? Jesse - Original Message - From: Jesse j...@msdlg.com To: mysql@lists.mysql.com Sent: Tuesday, March 24, 2009 11:41 AM Subject: MySQL server has gone away... We are running MySQL Server version 5.0.67-community-nt-log on a WS03 server. It seems like every once in a while (sometimes

Re: MySQL server has gone away...

2009-03-24 Thread Jesse
? Thanks, Jesse - Original Message - From: Gary Smith g...@primeexalia.com To: Jesse j...@msdlg.com; mysql@lists.mysql.com Sent: Tuesday, March 24, 2009 2:55 PM Subject: Re: MySQL server has gone away... Netstat -an. How many 3306 entries do you have in there. What's the TTL on them. Once

Optimizing IN queries?

2009-01-26 Thread Jesse Sheidlower
key_len: 4 ref: rqs_incs.quotation.part_id rows: 1 --- Thanks very much. Jesse Sheidlower -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Stopping using a server as a slave

2008-11-25 Thread Jesse
a server as a slave? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error: Got error 139 from storage engine

2008-11-13 Thread Jesse
that there was a problem with InnoDB and this error, but nothing about how to prevent it. Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Installing MySQL Twice

2008-11-13 Thread Jesse
'cha's in this situation? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error: Got error 139 from storage engine

2008-11-04 Thread Jesse
is that the limit of a Text field is about 64K, right? I guess it's possible that limit was exceeded, but not very likely. I'll have to do some more checking. Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Error: Got error 139 from storage engine

2008-11-03 Thread Jesse
in the database, I get the error, #HY000Got error 139 from storage engine. Does anyone know what this is and how to fix it? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: access denied error

2008-10-10 Thread Jesse
Sorry to have bothered you. I believe I found the problem. I had a 1 (One) in the password instead of a l (L). it was working from the command prompt, because I was typing it in the same way, but from the application, it was stored. So, basically, I had the password wrong. Thanks, Jesse

access denied error

2008-10-10 Thread Jesse
password: YES) Can anyone tell me what the issue could be here? Why would I have access denied through the PHP application, but not through the MySQL client? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

MySQL 5.1 error

2008-09-27 Thread Jesse
I'm trying to get our new Windows Server 2008 running. I believe I heard that I have to install 5.1 on there to get it running. I think I'm aout to find out, because I'm giong to uninstall 5.1 and install 5.0.xxx At any rate, here's what's going on: I bring up the Query Browser GUI, and

MySQL 5.1 Function Creation

2008-09-27 Thread Jesse
) RETURNS int(11) DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER COMMENT '' BEGIN DECLARE today DATE; SELECT CampStartDate INTO today FROM config; RETURN DATE_FORMAT(FROM_DAYS(TO_DAYS(today) - TO_DAYS(dob)), '%Y') + 0; END; Any ideas what's going on? Jesse -- MySQL General

Re: Error stops replication

2008-08-27 Thread Jesse
Where can I find a general log if I've got one running? What's it's file name, and where it is usually located? Thanks, Jesse - Original Message - From: Ananda Kumar To: Jesse Cc: MySQL List Sent: Tuesday, August 26, 2008 8:03 AM Subject: Re: Error stops replication

Re: Error stops replication

2008-08-26 Thread Jesse
, I've checked that file on both master and slave, and there is no reference there at all to a AddSchool( function error. Other than that, I don't see that any other logs are activated (other than the binary logs, of course). Jesse - Original Message - From: Ananda Kumar To: Jesse

Error stops replication

2008-08-25 Thread Jesse
if it is happening on the master server? I'm running version 5.0.67-community-nt on the slave and version 5.0.51a-nt-log on the master. If anyone has any ideas on what might be causing this, please let me know what you think. Jesse -- MySQL General Mailing List For list archives: http

MySQL compatibility with Windows Server 2008

2008-08-15 Thread Jesse
applications on our servers now, and the new server will be used for the same. So, what about the MySQL .Net connector and the ODBC Driver? Are they compatible with WS2008? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: MySQL compatibility with Windows Server 2008

2008-08-15 Thread Jesse
.NET connector is fine. ODBC should be ok but I'm not 100% sure. How about MySQL itself? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Access denied for user 'debian-sys-maint'@'localhost'

2008-07-22 Thread Jesse
That was it. Once I removed PASSWORD, it went through, and I'm able to restart MySQL now. Thanks for your help. Jesse - Original Message - From: Ian Simpson To: Jesse Cc: MySQL List Sent: Tuesday, July 22, 2008 4:48 AM Subject: Re: Access denied for user 'debian-sys

Access denied for user 'debian-sys-maint'@'localhost'

2008-07-21 Thread Jesse
again. What's going on? Why can't I get this to work? Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Accessing remote machine (Ubuntu) from Window

2008-07-18 Thread Jesse
Do you have skip networkin in my.cnf ? No, no skip-networking is in the my.cnf file. Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Accessing remote machine (Ubuntu) from Window

2008-07-17 Thread Jesse
for replication, and that appears to be working fine. Are there some additional steps I need to take to make this work? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Accessing remote machine (Ubuntu) from Window

2008-07-17 Thread Jesse
address of *.* When I re-issue the command with -n, I can seee that it is, indeed, listening on port 3306. Can you think of any other reasons why the connection would fail? Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Accessing remote machine (Ubuntu) from Window

2008-07-17 Thread Jesse
password:YES)' This has been happening for a day or so, and I don't know if it's related to my problem or not. After changing the grant to use an IP address, I still cannot log in. Jesse - Original Message - From: Curtis Maurand [EMAIL PROTECTED] To: Jesse [EMAIL PROTECTED] Cc: MySQL

Need help figuring out mk-table-checksum

2008-07-17 Thread Jesse
that means that it worked, and that there are no record differences, am I correct? Is there a better way to be sure? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Accessing remote machine (Ubuntu) from Window

2008-07-17 Thread Jesse
My settings are the same, except I have the bind-address set to my local IP of 192.168.1.128. I tried 0.0.0.0, and I still cannot connect from other machines. Jesse - Original Message - From: Curtis Maurand [EMAIL PROTECTED] To: Jesse [EMAIL PROTECTED] Cc: MySQL List mysql

Re: Function Still Not Working

2008-06-15 Thread Jesse
string did you tried? Well, I thought I had tried this, but with all the other things that I'd tried, I guess I had everything mixed up. I started with a clean routine, used Convert(... using UTF8), and it works perfectly now. That's what it was. Thanks for the help! Jesse -- MySQL

Function Still Not Working

2008-06-12 Thread Jesse
; It's a very simple function used to properize a string sent to it. When I do a simple SELECT ProperCase('JESSE'); it returns JESSE on our server that is running 5.0.17-nt-log. On another server that I've got, running 5.0.51a-community-nt, this function returns Jesse as it should. The only

Re: Function Still Not Working

2008-06-12 Thread Jesse
. Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Function Still Not Working

2008-06-12 Thread Jesse
Any difference in default collation? Not sure what that is. I'm using a visual tool (EMS) to create my function, and it doesn't offer that option. I could update it using the command prompt, however. I may try that later. -- MySQL General Mailing List For list archives:

Re: Function Still Not Working

2008-06-12 Thread Jesse
does it work outside the function? Yes, If I run: select CONCAT(UPPER(SUBSTRING('JESSE',1,1)),LOWER(SUBSTRING('JESSE',2))); replacing cInput with 'JESSE', it returns Jesse as it should. did you tried SUBSTRING(cInput, 2)? Tried replacing SUBSTRING(cInput FROM 2) with SUBSTRING(cInput, 2

Function Not Working

2008-06-10 Thread Jesse
))); RETURN cReturn; END; It's a very simple function used to properize a string sent to it. When I do a simple SELECT ProperCase('JESSE'); it returns JESSE on our server that is running 5.0.17-nt-log. On another server that I've got, running 5.0.51a-community-nt, this function returns Jesse

Re: Replication still stopping...

2007-10-24 Thread Jesse
crashed writing it. ROLLBACK; Don't know why it would do this. However, I set the master_log_pos to 98 before re-starting the slave after re-setting it last time. Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: [OT] Memory Usage on Windows? Re: Replication still stopping...

2007-10-24 Thread Jesse
, as a test, I change a record on the master, and I notice that almost immediately, the same change is made on the slave. Works perfectly for a few hours, then it just stops working. It almost appears to be a network related issue, but I can't seem to track it down. Jesse -- MySQL General

Replication still stopping...

2007-10-22 Thread Jesse
not be able to connect any more? Any help or suggestions anyone can offer is greatly appreciated! Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

DROP TRIGGER IF EXISTS throws error??

2007-10-05 Thread Jesse
`; Seems perfectly valid to me. If I remove the IF EXISTS part, then I get the error, trigger doesn't exist. What's going on? This usually works fine. I'm running version 5.0.45-community-nt Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: MySQL Manager Issue

2007-10-05 Thread Jesse
that. In fact, I can't get it to do it again. Maybe it's turned off. We'll see. If not, maybe I'll try the ticket system if it's working now. Thanks for your help. Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: DROP TRIGGER IF EXISTS throws error??

2007-10-05 Thread Jesse
seem to indicate it properly, but I've got it working now. Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL Manager Issue

2007-10-04 Thread Jesse
, table, or field suggestions as I type. I have to constantly press the escape key to get rid of the box. Is there some way to turn this feature off that anyone's aware of? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Replication Issues

2007-10-01 Thread Jesse
that I could tell. Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Proper way to Re-cync in Replication

2007-10-01 Thread Jesse
, but it doesn't. Any ideas? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Replication Issues

2007-10-01 Thread Jesse
I can't think of anything other than looking deeper into the MySQL log files. I'm not sure where those are on Windows, but I imagine it's not all going to the event log. Maybe there is something in c:\program files\mysql 5\ (or wherever you installed MySQL). Try looking for a file named

Re: Replication Issues

2007-10-01 Thread Jesse
FROM query on the mysql.db table. Position 557 has a FLUSH PRIVILEGES command. The position doesn't make any sense to me. Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Replication Issues

2007-10-01 Thread Jesse
re-syncing things and re-starting things tonight and trying to start fresh again. I'll see what happens tomorrow. Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Create Foreign Key Issue

2007-05-19 Thread Jesse
stated the the types of fields need to be exactly the same, they're not kidding. I found that in one table the ID field was Unsigned, but in the other, it was not unsigned. I changed the other one to unsigned, and it's adding a foreign key now. Thanks, Jesse -- MySQL General Mailing List

InnoDB Disabled?

2007-05-19 Thread Jesse
? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: InnoDB Disabled?

2007-05-19 Thread Jesse
Found the problem. After searching for a while, I found where someone deleted the ib_logfile*.* in the data directory. I did that, and that cleaned it up. Jesse - Original Message - From: Jesse [EMAIL PROTECTED] To: MySQL List mysql@lists.mysql.com Sent: Saturday, May 19, 2007 4

Create Foreign Key Issue

2007-05-18 Thread Jesse
this before w/o problems. What else can I check to make this work? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Join Error

2007-05-10 Thread Jesse
tried setting SQL_BIG_SELECTS=1 in my.ini, but MySQL won't re-start in services when I do that. MAX_JOIN_SIZE is set to 4294967295. That seems pretty huge to me, But, I guess I can change it, but what do I change it to? Or, is there a better way to do this by changing my query? Thanks, Jesse

ROLLUP and Text on total lines

2007-05-02 Thread Jesse
to determine if the row is a subtotal or total row, and change the text to indicate which it is? Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Need help with query

2007-05-01 Thread Jesse
BY BusID) AS CounselorCount On CounselorCount.BusID=B.ID ORDER BY B.BusNum When I try to execute this, I get the error, Unknown column 'Kids' in 'field list' How do I properly add these together to get a total column? Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: Need help with query

2007-05-01 Thread Jesse
in the ORDER BY clause, and other places. Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Possible Replication Issue?

2007-04-24 Thread Jesse
pointers? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Stopping Replication

2007-04-24 Thread Jesse
the replication process? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Stopping Replication

2007-04-24 Thread Jesse
Thanks, I've removed these files. Also, there are a BUNCH of files named webserver2-relay-bin.{some#} in the data folder. Can I delete all of these (including the .index file)? Thanks, Jesse - Original Message - From: Brown, Charles [EMAIL PROTECTED] To: Michael Dykman [EMAIL

Event Log Error

2007-04-23 Thread Jesse
have any pointers? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Query to return Multiple values in a field?

2007-04-06 Thread Jesse
and create a query for each row to get the schedule information. Any help is appreciated. Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Query to return Multiple values in a field?

2007-04-06 Thread Jesse
ON SS.`SectionID`=S.ID WHERE ActivityID=65 GROUP BY S.ID THANKS FOR THE HELP! Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

UPDATE / not UPDATE??

2007-04-02 Thread Jesse
it, and if it is the same as the value that it's updating it with, it doesn't bother updating it again? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: UPDATE / not UPDATE??

2007-04-02 Thread Jesse
Don't know? 5.0.22-community-nt-log Win XP Pro InnoDB Jesse - Original Message - From: sol beach To: Jesse Sent: Monday, April 02, 2007 4:22 PM Subject: Re: UPDATE / not UPDATE?? Might this behavior be version dependent; which you neglected to provide. Same for OS name

Re: Not Sorting Correctly

2007-03-23 Thread Jesse
make an alias for the field you want as sort key and use that. you don't need to do the calculation twice. I would not be surprised if the sort started to behave. Didn't help. The results are exactly the same. Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: Not Sorting Correctly

2007-03-23 Thread Jesse
Strange. I'm running the same exact version, and it's not the same. What field types are you using? Mine are as follows: RoomNo VarChar(10) LastName VarChar(25) FirstName VarChar(25) the values that I put into Room No are 1,2,3, etc. I'm not storing 001,002,003, etc in there. Jesse

Re: Not Sorting Correctly

2007-03-22 Thread Jesse
BeatyBrooke 001BrownPaige 002BynumWesley 008ClarkAndrew 008ClarkRamsey Etc... As you can see, it's out of order. Jesse - Original Message - From: Ales Zoulek [EMAIL PROTECTED] To: Jesse [EMAIL PROTECTED] Cc: MySQL List mysql@lists.mysql.com Sent: Monday

Not Sorting Correctly

2007-03-19 Thread Jesse
with: ORDER BY CAST(RoomNo AS UNSIGNED), LastName, FirstName Which works perfectly, but I'm just wondering why the first attempt (right(concat...)) didn't work?? Any ideas? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

ORDER BY issue

2007-03-16 Thread Jesse
with: ORDER BY CAST(RoomNo AS UNSIGNED), LastName, FirstName Which works perfectly, but I'm just wondering why the first attempt (right(concat...)) didn't work?? Any ideas? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Export Results?

2007-02-15 Thread Jesse
Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Export Results?

2007-02-15 Thread Jesse
Thanks, Exactly what I was looking for. It helps to know what you are looking for when browsing the help file. Jesse - Original Message - From: Chris White [EMAIL PROTECTED] To: Jesse [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Thursday, February 15, 2007 4:34 PM Subject: Re

Replication LOAD DATA INFILE

2007-02-02 Thread Jesse
I've just performed a LOAD DATA INFILE on the master server, and I've waited a while now, and the data has not shown up in the SLAVE. Does Replication not handle LOAD DATA INFILE? Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Replication not working?

2007-01-31 Thread Jesse
if this has now stopped replication. If so, how do I restart it? Thanks, Jesse - Original Message - From: Michael DePhillips [EMAIL PROTECTED] To: Jesse [EMAIL PROTECTED] Cc: MySQL List mysql@lists.mysql.com Sent: Tuesday, January 30, 2007 7:57 PM Subject: Re: Replication not working

Re: Replication not working?

2007-01-31 Thread Jesse
Also, given the error I got: - Original Message - From: Michael DePhillips [EMAIL PROTECTED] To: Jesse [EMAIL PROTECTED] Cc: MySQL List mysql@lists.mysql.com Sent: Tuesday, January 30, 2007 7:57 PM Subject: Re: Replication not working? Should be almost instantaneous. Do a show slave

Re: Replication not working?

2007-01-31 Thread Jesse
There are a couple of issues hwere. Primary is that it's trying to connect on port 3306. I'm actually using 3307, but can't seem to find where I change this setting. Have any suggestions? Thanks, Jesse - Original Message - From: Michael DePhillips [EMAIL PROTECTED] To: Jesse [EMAIL

Replication not working?

2007-01-30 Thread Jesse
has not appeared. How often does the slave check for new records on the master? Also, is there some location that I can check for errors? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ASP.NET Access to MySQL BIT field????-Help

2007-01-19 Thread Jesse
there. Anyway... Apparently, MySQL Stores a BIT value as a character. Chr(0) = False, and Chr(1) = True. Once I discovered this, I was easily able to do a FirstTime.Checked = (RS(FirstTime) = Chr(1)), and it worked perfectly. Jesse - Original Message - From: Jesse [EMAIL PROTECTED

ASP.NET Access to MySQL BIT field????-Help

2007-01-17 Thread Jesse
it through the MySQL Query Browser, it presents the value as b'1' Any hints? I'm sure this is a basic issue, but I just can't seem to find a way to do it. Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Assigning Variable to a BIT Field

2007-01-16 Thread Jesse
it through the MySQL Query Browser, it presents the value as b'1' Any hints? I'm sure this is a basic issue, but I just can't seem to find a way to do it. Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Need SUPER Privilidge for UPDATE?

2007-01-08 Thread Jesse
5.0.22-community-nt. with InnoDB tables. Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Need SUPER Privilidge for UPDATE?

2007-01-08 Thread Jesse
tell, and I don't know how to tell if I've given the user name that I'm using on the other database the SUPER privilege or not. How do I give a user the SUPER privilege? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Linux Installation

2006-12-15 Thread Jesse
a Windows Server 2000 machine, and a Debian Linux machine. Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL Date Issues

2006-12-01 Thread Jesse
' is not valid.. I change change the above code to this: StartDate.Text = FormatDateTime(RS(StartDateTime).ToString,2) StartTime.Text = FormatDateTime(RS(StartDateTime).ToString,3) and it works... However, what can I do with the DataGrid column above? Thanks, Jesse -- MySQL General Mailing

Re: Mass E-mail Options

2006-08-31 Thread Jesse
to unorder the email addresses, so that large groups of yahoo and aol etc emails do not hit the outbound queue at the same time. They tend to look down on that activity, and throttle you back, making it take even longer to get your messages out. Thanks, Jesse -- MySQL General Mailing List For list

Re: Mass E-mail Options

2006-08-31 Thread Jesse
case handler to be shuttled to a low priority queue right off the bat. Might I suggest you set up a database for the special conditions and the queues you'd place them in? g Wow, this is getting complicated! All I want to do is send e-mails... Jesse -- MySQL General Mailing List For list

Re: Mass E-mail Options

2006-08-31 Thread Jesse
this at? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Mass E-mail Options

2006-08-30 Thread Jesse
recipients may have these servers black listed. What other alternatives are there? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Zip Code Distance

2006-08-29 Thread Jesse
? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Web Seminar Events

2006-08-25 Thread Jesse
. Is there another list somewhere of scheduled Web Seminars? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Outputting text in a

2006-08-24 Thread Jesse
You still get two lines, it's just that one of the lines is blank, and the other says, text to the screen. Jesse - Original Message - From: Wai-Sun Chia [EMAIL PROTECTED] To: Dan Buettner [EMAIL PROTECTED] Cc: Jesse [EMAIL PROTECTED]; MySQL List mysql@lists.mysql.com Sent: Thursday

Outputting text in a

2006-08-23 Thread Jesse
Is it possible to output text to the screen from a .sql script? If so, how? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Help with query

2006-08-21 Thread Jesse
, LA.UserName, U.Password FROM LocalAdvisors LA JOIN Users U ON U.UserName=LA.UserName WHERE EMailAddress '' AND EMailAddress IS NOT NULL AND (EMailPermission is NULL or EMailPermission=1) AND LA.LastName LIKE '[A-E]%' ORDER BY LastName,FirstName Thanks, Jesse -- MySQL General Mailing

  1   2   3   >