Re: Missing database file names

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

Re: Missing database file names

2010-06-04 Thread Jesse F. Hughes
"Jesse F. Hughes" 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 1844

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 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 h

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 fo

Re: Missing database file names

2010-06-03 Thread Jesse F. Hughes
Dan Nelson 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: >> >>

Re: Missing database file names

2010-06-03 Thread Jesse F. Hughes
Dan Nelson 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: >> >>

Missing database file names

2010-06-02 Thread Jesse F. Hughes
e if I can keep 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*." -

Need help with query optimization

2010-03-16 Thread Jesse
AchievementID | 5 | NULL| 161685 | Using where | ++-+++-+---+-+-++-+ What is the best way to optimize this query so that it doesn't take 40 sec

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

2010-02-25 Thread Jesse
;'SHOW VARIABLE'' makes no sense at all. I have 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

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

2010-02-25 Thread Jesse
had the same problem. My plan is to move the app 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: MySQL server has gone away...

2009-03-24 Thread Jesse
tions? Thanks, Jesse - Original Message - From: "Gary Smith" To: "Jesse" ; 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 the pool issu

Re: MySQL server has gone away...

2009-03-24 Thread Jesse
suddenly loose connection? Jesse - Original Message - From: "Jesse" To: 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 (someti

Re: MySQL server has gone away...

2009-03-24 Thread Jesse
ormale use 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, Jes

Re: MySQL server has gone away...

2009-03-24 Thread Jesse
users 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

MySQL server has gone away...

2009-03-24 Thread Jesse
MySQL 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 unsubscrib

Optimizing IN queries?

2009-01-26 Thread Jesse Sheidlower
PRIMARY key: PRIMARY 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
to stop using 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]

Installing MySQL Twice

2008-11-13 Thread Jesse
a problem? Are there any "got '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-13 Thread Jesse
ing the net, I found 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]

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:/

Error: "Got error 139 from storage engine"

2008-11-03 Thread Jesse
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. Tha

"access denied" error

2008-10-10 Thread Jesse
'@'localhost' (using 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.c

MySQL 5.1 Function Creation

2008-09-27 Thread Jesse
lhost' FUNCTION `Age`(dob DATE) 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;

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 log

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

Re: Error stops replication

2008-08-26 Thread Jesse
uot;general log", you mean the log named machine.err, 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 cou

Error stops replication

2008-08-25 Thread Jesse
quot; file log these sort of errors? If not, where can I look to see 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 y

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]

MySQL compatibility with Windows Server 2008

2008-08-15 Thread Jesse
P.Net 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:

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 '

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

2008-07-21 Thread Jesse
s-maint -p, type in the password and get the "Access denied" error 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]

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" <[EMAI

Need help figuring out mk-table-checksum

2008-07-17 Thread Jesse
I'm hoping 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
'@'localhost' (using 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 Maur

Re: Accessing remote machine (Ubuntu) from Window

2008-07-17 Thread Jesse
ists a foreign 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.mysq

Accessing remote machine (Ubuntu) from Window

2008-07-17 Thread Jesse
l installed on the Ubuntu server, because I have it connecting to my server 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: Function Still Not Working

2008-06-15 Thread Jesse
to a non-binary 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

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

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: http://lists.mys

Re: Function Still Not Working

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

Function Still Not Working

2008-06-12 Thread Jesse
LOWER(SUBSTRING(cInput FROM 2))); 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, run

Function Not Working

2008-06-10 Thread Jesse
ut FROM 2))); 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

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

2007-10-24 Thread Jesse
it is runnning, 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

Re: Replication still stopping...

2007-10-24 Thread Jesse
g: this binlog was not closed properly. Most probably mysqld 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 li

Replication still stopping...

2007-10-22 Thread Jesse
,400 times, which I guess took almost a day to do, and just gave up. Why would it be able to connect initially to the server, then suddenly 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]

Re: DROP TRIGGER IF EXISTS throws error??

2007-10-05 Thread Jesse
me why the message didn't 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]

DROP TRIGGER IF EXISTS throws error??

2007-10-05 Thread Jesse
EXISTS `alumni`; 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

Re: MySQL Manager Issue

2007-10-05 Thread Jesse
unction pick box. Again, interestingly enough, when I tried this again, it didn't do 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 Manager Issue

2007-10-04 Thread Jesse
e by popping up function, 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

Re: Replication Issues

2007-10-01 Thread Jesse
big mess and jumble. I think I'm going to attempt 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: Replication Issues

2007-10-01 Thread Jesse
s a DELETE 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
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 mysq

Proper way to Re-cync in Replication

2007-10-01 Thread Jesse
rked for me. Don't know why, 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]

Replication Issues

2007-10-01 Thread Jesse
ve to just stop replicating? There was no explanation at all 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]

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" Sent: Saturday, Ma

InnoDB Disabled?

2007-05-19 Thread Jesse
yone have any suggestions? Thanks, 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
t's 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 Ge

Create Foreign Key Issue

2007-05-18 Thread Jesse
s if necessary, but I've done 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
t to? Or, is there a better way to do this by changing my query? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

ROLLUP and Text on total lines

2007-05-02 Thread Jesse
ay 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]

Re: Need help with query

2007-05-01 Thread Jesse
hen trying to use them 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]

Need help with query

2007-05-01 Thread Jesse
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 Mailin

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 PRO

Stopping Replication

2007-04-24 Thread Jesse
I need to do to stop 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]

Possible Replication Issue?

2007-04-24 Thread Jesse
ook for this. Does anyone 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]

Event Log Error

2007-04-23 Thread Jesse
eed to look for this. Does anyone 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]

Re: Query to return Multiple values in a field?

2007-04-06 Thread Jesse
M SectionSchedule SS) As SS 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]

Query to return Multiple values in a field?

2007-04-06 Thread Jesse
p in my program 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: 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

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: Not Sorting Correctly

2007-03-23 Thread Jesse
not storing "001","002","003", etc in there. Jesse ----- Original Message - From: "Zhaowei" <[EMAIL PROTECTED]> To: "Jesse" <[EMAIL PROTECTED]>; Sent: Friday, March 23, 2007 5:03 AM Subject: Re: Not Sorting Correctly Hi

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

Re: Not Sorting Correctly

2007-03-22 Thread Jesse
BartonGreg 003BeatyBrooke 001BrownPaige 002BynumWesley 008ClarkAndrew 008ClarkRamsey Etc... As you can see, it's out of order. Jesse - Original Message - From: "Ales Zoulek" <[EMAIL PROTECTED]> To: "Jesse" <[EMAI

Not Sorting Correctly

2007-03-19 Thread Jesse
n Peterson 2 Bryan Wilton I finally ended up 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 archive

ORDER BY issue

2007-03-16 Thread Jesse
n Peterson 2 Bryan Wilton I finally ended up 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 archive

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: Sent: Thursday, February 15,

Export Results?

2007-02-15 Thread Jesse
if it even exists. I'm using MySQL version 5 Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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 unsubscrib

Re: Replication not working?

2007-01-31 Thread Jesse
ry-time: 60 retries: 86400 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: &q

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" Sent: Tuesday, January 30, 2007 7:57 PM Subject: Re: Replication not working? Should be almost

Re: Replication not working?

2007-01-31 Thread Jesse
name, and I've been abel to connect using that user name and password now. I don't know if this has now stopped replication. If so, how do I restart it? Thanks, Jesse - Original Message - From: "Michael DePhillips" <[EMAIL PROTECTED]> To: "Jesse

Replication not working?

2007-01-30 Thread Jesse
ecord 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
wered 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:

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

2007-01-17 Thread Jesse
5 Lite, It presents a check box for the field value. When I view 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

Assigning Variable to a BIT Field

2007-01-16 Thread Jesse
2005 Lite, It presents a check box for the field value. When I view 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

Re: Need SUPER Privilidge for UPDATE?

2007-01-08 Thread Jesse
I can 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

Need SUPER Privilidge for UPDATE?

2007-01-08 Thread Jesse
ssword, or Families.`Password`. Any ideas why I would be getting this error? This same exact query works fine on another database with the same structure and every thing. Using version 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]

Linux Installation

2006-12-15 Thread Jesse
y network, there would be located 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
x27;Date' 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? Tha

Re: Mass E-mail Options

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

Re: Mass E-mail Options

2006-08-31 Thread Jesse
does this might be a candidate for being added to a special 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? Wow, this is getting complicated! All I want to do is

Re: Mass E-mail Options

2006-08-31 Thread Jesse
ry 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

Mass E-mail Options

2006-08-30 Thread Jesse
OT spam, and second, some 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
nyone have any ideas? 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
appen. 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"

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]

Re: Help with query

2006-08-21 Thread Jesse
. I really appreciate your help. Jesse - Original Message - From: Douglas Sims To: Jesse Cc: MySQL List Sent: Monday, August 21, 2006 12:07 PM Subject: Re: Help with query I think you are trying to use a regular expression in the like phrase. I wasn't aware that MS SQL

  1   2   3   >