kup occurs each night
automatically. I've downloaded the backup to my machine, and tried to restore
it using MySQL Administrator, and it goes through the motions, but the data has
not been changed in my database here. What could I be doing wrong here?
Thanks,
Jesse
but I
don't have an explanation. Does anyone else?
Jesse
- Original Message -
From: "Jesse" <[EMAIL PROTECTED]>
To: "MySQL List"
Sent: Tuesday, May 16, 2006 3:30 PM
Subject: Restore Problem
I've got a backup that is scheduled by MySQL Administrator,
nced "My Sequel", or is it
pronounced "My S-Q-L"? I mean, generally speaking?
Thanks,
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I guess perfectionism in a lot of what I do is a problem I've got to deal
with. But I hate saying it one way and looking stupid when talking with
"real guru's". :-)
Thanks,
Jesse
- Original Message -
From: "Peter Lauri" <[EMAIL PROTECTED]>
To: &q
ronounce it right.
Most of my technical conversations occur through e-mail or newsgroups like
this one, in which I spell it MySQL, and the way it's pronounced doesn't
matter. :-)
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
didn't have a MySQL
backup of the data and that's why I'm going this route. I'm using MySQL 5.0
on a Windows XP Pro machine (my development machine). Could someone please
point me in the right direction for restoring all the physical files?
Thanks,
Jesse
--
MySQL General
iew the tables themselves. Does
anyone know how to fix this problem? I'm using MySQL 5.0 on a Windows XP
Pro (my development machine) environment.
Thanks,
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
;t receive any answers at all
from this question, and I needed to move on with it, so I had no choice but
to start from scratch. :-( The bit about the inno engine not starting is
good to know, though.
Thanks,
Jesse
- Original Message -
From: "Duzenbury, Rich" <[EMA
Oh, OK. Well, guess which driver I'm using... InnoDB. :-) Oh well.
Thanks,
Jesse
- Original Message -
From: "Quentin Bennett" <[EMAIL PROTECTED]>
To: "Jesse" <[EMAIL PROTECTED]>; "MySQL List"
Sent: Sunday, June 18, 2006 5:28 PM
Subjec
perly. Is
there another way to do this?
Thanks,
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
L Query Browser takes just as long (as one would expect).
The tables are all InnoDB. Is there anything else I can do to help speed
this query up?
Thanks,
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ecute this query in
MySQL Query Browser, and it returns 215 rows. I've recently converted this
table from InnoDB to MyISAM, which seems to be faster, but I can't figure
out why it would say it was at EOF when it's not! I've got other queries
that don't return EOF, why w
ay, it actually increased the time
of this query from about 48 seconds to about 1:40 or so. More than twice as
much. However, I've noticed that other things do seem to be running faster
since converting to MyISAM, but this query is not.
Thanks,
Jesse
- Original Message -
Yes, some of the fields have null values, but not the main key values. I've
also got another report I run in ASP which has null values in it as well,
but it doesn't report EOF. But how could a null value in one of the fields
make it appear EOF?
Thanks,
Jesse
- Origin
s critical that
it work properly. Does anyone have any information on this?
Thanks,
Jesse
- Original Message -
From: "Jesse" <[EMAIL PROTECTED]>
To: "MySQL List"
Sent: Monday, June 26, 2006 4:58 PM
Subject: ASP Reporting EOF?
When I run the following query i
Found the problem. I upgraded to version 3.51.12 of the ODBC driver, and the
problem was solved.
Jesse
- Original Message -
From: "Jesse" <[EMAIL PROTECTED]>
To: "MySQL List"
Sent: Monday, June 26, 2006 4:58 PM
Subject: ASP Reporting EOF?
When I run the
null values were not the problems. It was a bug in version 3.51.11 of the
ODBC driver, which I was using. I downloaded and installed version 3.51.12,
and the problem seems to have been resolved.
Thanks,
Jesse
- Original Message -
From: "J.R. Bullington" <[EMAIL PR
How do I output messages to the screen during the execution of a Stored
Procedure? In other words, what command in a stored procedure will allow me
to sent output to the screen to indicate progress?
I'm using MySQL 5.
Thanks,
Jesse
--
MySQL General Mailing List
For list archives:
pterType) AS sq ORDER BY State, Sub, ChapterType
Anyway, thanks for your help.
Jesse
- Original Message -
From: "Dan Buettner" <[EMAIL PROTECTED]>
Cc: "Jesse" <[EMAIL PROTECTED]>; "mysql"
Sent: Monday, June 26, 2006 8:18 PM
Subject: Re: Query S
MySQL?
DELETE FROM ConfInvDet
FROM ConfInvDet H LEFT JOIN ConfInvoices I ON I.InvoiceNo=H.InvoiceNo
WHERE I.ID IS NULL;
Basically, I'm trying to delete orphan records. I'm using MySQL 5.
Thanks,
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
r two that doesn't use it at
all, and it seems to work fine. What's the difference?
Thanks,
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
p_GetNextInv(-1,@cInvNo);
SELECT @cInvNo;
...and it returns 65973. Does anyone have a clue why it's doing that?
Thanks,
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Aaah. OK. That's what the "@" stands for. I could not figure out what the
@ was for, and I posted a message on the list yesterday and did not receive
a response. You're right. That solved the problem.
Thanks,
Jesse
- Original Message -
From: "Chris White
timing. However, if I can get your more efficient query working, I
would like to. Any ideas why it's not working?
Thanks,
Jesse
- Original Message -
From: "Jay Pipes" <[EMAIL PROTECTED]>
To: "Jesse" <[EMAIL PROTECTED]>
Cc: "mysql"
Sent
Integer,
adParamInput, 16, nChapterID)
adocmd.Parameters.Append adocmd.CreateParameter("InvNo", adVarChar,
adParamOutput,7)
adocmd.Execute
GetNextInv = adocmd.Parameters("InvNo").Value
set adocmd=Nothing
end function
I know that the proper way to call this function from the MySQL co
Input, 16, nChapterID)
adocmd.Parameters.Append adocmd.CreateParameter("InvNo", adVarChar,
adParamOutput,7)
adocmd.Execute
GetNextInv = adocmd.Parameters("InvNo").Value
set adocmd=Nothing
end function
I know that the proper way to call this function from the MySQL command l
7;t know if there are other text editors that will not do this, or even
better, if there is a way to add a hard line break after each inserted
record. I realize this will increase the size of the backup file, but to
me, it's worth it.
Any ideas?
Thanks,
Jesse
--
MySQL General Mail
way it is at the 16384th column.
Thanks,
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--opt) and will
get a single INSERT for each row.
I thought this may be the way I needed to go, but wasn't sure. I will give
this a try and see if it works.
Thanks,
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
e found a way to backup so that it wraps the lines correctly now, so I
can use my old editor, which I'm used to. I may look into GVIM, though,
just for grins-and-giggles.
Thanks,
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Oh, OK. I use MySQL Administrator frequently, but didn't realize that it
could selectively restore. I don't like to use it for backups, because it
doesn't get --routines and --triggers, and also doesn't backup in the format
that I use. But I'll consider that.
Than
ay, resolved for now,
and I'll never throw away old faithful Multi-Edit (unless something better
comes along).
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ht syntax to use near '{ call sp_GetNextInv(326,
'') }'" I have double-checked, and it appears to be putting curley brackets
around the function call. I have tried this sp in straight MySQL command,
and it works fine, it's just calling it from ASP and ASP.net that seems
= '2006-01-06' AND I.InvoiceDate <= '2006-01-31' AND
MatSentDate IS NULL
Thanks,
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
VB is not case sensitive, so changing the case didn't make any difference.
I'm still getting the same non-sensical error message.
Jesse
- Original Message -
From: "DG @ NEFACOMP" <[EMAIL PROTECTED]>
To: "Jesse" <[EMAIL PROTECTED]>; "MySQ
I'm using version 5.?.
Excellent. That seemed to do the trick.
Thanks,
Jesse
- Original Message -
From: "Remo Tex" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, July 05, 2006 2:31 AM
Subject: Re: UPDATE Based on Relation
Jesse wrote:
I need to be able to do
ppening, 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]
it's parent record. I've stored the Parent Key value in
the field CTID in the Child table (custpoints), which points to the ID field
in the parent record (custtournaments).
Is my understanding flawed?
Any more light you can shed on this is appreciated.
Thanks,
Jesse
--
MySQL
uble(5,1) default '0.0',
`ScoreKeep` varchar(30) default NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `karate`.`custpoints`;
CREATE TABLE `karate`.`custpoints` (
`ID` int(11) NOT NULL auto_increment,
`Status` varchar(3) default NULL,
`Associat
s a script?
If so, does anyone know where can I get the latest copy? I've checked
MySQL.com, but can't seem to find it there.
Thanks,
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have a backup that was created by a MySQL 5 server using MySQLDump. When
I try to restore the database using the following command:
mysql -u root -p -D BPA < c:\backup\mydata.sql
I get the error:
ERROR 1064 (42000) at line 29765: You have an error in your SQL syntax;
check the manual that c
Windows XP Pro on my development, and Windows Server 2003 on our
actual production machine. While I've got access to Linux here on my
development network, I do not on our server. So, I will stick to MySQLDump
for the backup then.
Thanks for the help.
Jesse
--
MySQL General Mailing Lis
line becuase the delimiter was changed before
hand.
Any ideas why this won't execute? I could go through the entire backup file
and remove the comments, but this would take quite a while, and I'd rather
it execute properly to begin with, but not sure why it's not executing now.
n't know if I should look into this
or not.
Thanks,
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
. There are no duplicate ID's in the ConfInvDet table. Any
idea what this error means, 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]
Is this a InnoDB table.
Yes, sorry, I should have mentioned that. The rest of my tables are MyISAM,
and I discovered that it does not support Foreign Keys. So, I converted
these tables to InnoDB so that I can put the Foreign Keys in.
Thanks,
Jesse
--
MySQL General Mailing List
For list
t seem to
find anything on the MySQL web site. I looked around for a comparison chart
like that, and just couldn't find it. I guess I'm not reading enough.
Thanks,
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ed in
setting up each? What would be the cost of doing such for a business who
has a "mission critical" web application accessed from all over the U.S.?
Thanks,
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.m
tends to be a bit vague, covering all sorts of failures.
Aaah. I had forgotten about that. I was able to find and solve a problem
with that one time before. I'll make a special note of that and hopefully
remember to do that next time.
Thanks,
Jesse
--
MySQL General Mailing Lis
mean?? I
ran it on one of my databases, and most of them said "OK", and some of them
said "table is already up to date." But I still have no idea what it did,
if anything.
Thanks,
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
OK, I missed it this time because I partially typed in something when
searching for this in the manual. I searched for "optimiz", and stopped
there and ran across "optimization" But missed the OPTIMIZE TABLE entry.
Sorry about that. I'll read through that.
Tha
me,LA.LastName,LA.EMailAddress, 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 B
. 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
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]
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"
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]
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]
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]
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
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
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]
figure out how to do this sort of thing with,
or I would probably have just coded it. If I can find a SQL Solution, that
would be best here.
Anyone 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]
x27;ve set that to allow port 3306 through. I have also gone in
and created an application in IIS for my program. I've also copied the
MySql.Data.dll file into my bin folder in my application. I think I've done
everything I need to, but obviously not.
Any ideas?
Thanks,
Jesse
ror message when I should have been.
Jesse
----- Original Message -
From: "Jesse" <[EMAIL PROTECTED]>
To: "MySQL List"
Sent: Monday, December 19, 2005 2:15 PM
Subject: Possible Connection Issue
I have finished my ASP.Net/MySQL 5.0 application on my development
MySQL Administrator 1.0\MySQLAdministrator.exe"
"-UDC:\Documents and Settings\Jesse Castleberry\Application Data\MySQL\"
"-c" "-bpBackupData" "-btC:\junk\MySQLBackup" "-bxBackupData"
Thinking that there needed to be a space between "-bp
t? I'm using MySQL
5.?? on a Windows XP Pro (development machine).
Thanks,
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
One other restriction that I found was that both columns must be of the same
type. That was my problem. I had one column set to INTEGER and the other set
to INT(10). I set the INT(10) to INTEGER, and it worked fine.
Thanks,
Jesse
- Original Message -
From: [EMAIL PROTECTED
ot;Foreign" component is the child table.
Is that not right? If it is, how do I add records?
Thanks,
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
need to go back to the drawing
board, or do this manually?
Thanks,
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I thought that might be the only solution to this problem, but didn't know
if there was a way to keep it intact. I will split the tables up.
Thanks,
Jesse
- Original Message -
From: "Danny Stolle" <[EMAIL PROTECTED]>
To: "Jesse" <[EMAIL PROTECTED]&g
nyone give me a hand here?
Thanks,
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
heir age at the time of
camp, which means that I need to pull a date from a config file. Therefore,
instead of putting that long calculation in my query every time, I'm looking
for a simpler solution, a more automatic one.
Jesse
- Original Message -
From: "Jesse" <[E
le instead?
Thanks,
Jesse
- Original Message -
From: "Peter Brawley" <[EMAIL PROTECTED]>
To: "Jesse" <[EMAIL PROTECTED]>
Cc: "MySQL List"
Sent: Wednesday, December 28, 2005 10:20 AM
Subject: Re: Need Help Writing a Trigger
Jesse,
>Ther
That was perfect. I had done some research, and tried set today=(select
campstartdate from config) and various other arrangements of this, but none
of it worked. Yours worked perfectly.
Thanks for the help!
Jesse
- Original Message -
From: "Peter Brawley" <[EMAIL PR
E FamilyID=1
If I replace the CAST(ID AS Char) statement with 1, and remove the quotes
around it ('Select Items') it works just
fine. So, I know that it's the ID field, and how I'm trying to get that to be
part of the link that it's got a problem with. So, what is the correct way to
do this?
Thanks,
Jesse
Never mind,
I've found that if I use CONCAT(), it works just fine. It's hard for me to
get used to using CONCAT instead of just using the "+". I've made this
mistake several times.
Thanks,
Jesse
- Original Message -
From: "Jesse" <[EMAIL PROTE
? If so, where can I find it.
2) How do I enter Triggers onto a table?
Thanks,
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Are there any documents, help files, tutorials, or anything on the MySQL
Workbench program? I've played with it, and just can't figure out how to
use some of it's features.
Thanks,
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsub
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
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
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
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
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
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
;'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
AchievementID | 5 | NULL| 161685 | Using where
|
++-+++-+---+-+-++-+
What is the best way to optimize this query so that it doesn't take 40
sec
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]
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]
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
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]
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]
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
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
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
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]
,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]
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
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
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
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
1 - 100 of 261 matches
Mail list logo
