> -Original Message-
> From: Tommy McNeely [mailto:[EMAIL PROTECTED]
> I am building an IRC based application "bot" (using libmysql) .. that
> will take commands from users (!mybugs, !mybugs KEY !newbugs,
> etc), do
> SQL queries and of course dump formatted results back to the channel.
> -Original Message-
> From: Roger Baklund [mailto:[EMAIL PROTECTED]
> This definition (from the manual) is self-contradicting: 1 OR NULL
> should evaluate to 1 because "any operand is non-zero", but it should
> also evaluate to NULL because "any operand is NULL".
>
> http://dev.mysql.c
> -Original Message-
> From: Michael Stassen [mailto:[EMAIL PROTECTED]
> This tells the recipient's email client that your message is
> a reply, not a new message, despite your efforts to change the subject and
> recipients. Many email clients use that header to decide which thread a
me
> -Original Message-
> From: Jeff Smelser [mailto:[EMAIL PROTECTED]
> On Tuesday 05 October 2004 01:56 pm, David Brodbeck wrote:
>
> > Saves having to retype the list address, or look it up. I
> don't see what
> > difference it makes...
>
> Click
> -Original Message-
> From: Brian Mansell [mailto:[EMAIL PROTECTED]
> What build of MySQL are you running? I don't believe an electronic
> ignition is included in 4.0 or 4.1.
It's slated for 5.0, to complement the turbocharger and MegaSquirt support.
--
MySQL General Mailing List
For l
> -Original Message-
> From: Jeff Smelser [mailto:[EMAIL PROTECTED]
> Whats the deal and this list? No one can ever just hit new
> message, they
> always hit reply and put a new subject in..
Saves having to retype the list address, or look it up. I don't see what
difference it makes...
> -Original Message-
> From: Sparks [mailto:[EMAIL PROTECTED]
> I want to have an automatic backup done of my SQL databases,
> but cant quite
> figure out how to use mysqldump to do this properly...
I use a script that I run as a nightly cron job. Here's the one I use:
---
#!/bin/sh
> -Original Message-
> From: Eric Gunnett [mailto:[EMAIL PROTECTED]
> Depends on what file system you are running that is a
> ext2 limit if you move to ext3 or reiser you should be fine.
> But then a default config on MySQL will run into a 4.29 Gig
> limit, which you can change.
> -Original Message-
> From: Hassan Schroeder [mailto:[EMAIL PROTECTED]
> [EMAIL PROTECTED] wrote:
>
> > When I do
> > mysql>SHOW TABLES \p less;
> > I get the error message "You have an error in your SQL syntax near
> > 'less' in line 1" I am using dos, not unix.
>
> 1) that's not
> -Original Message-
> From: David Griffiths [mailto:[EMAIL PROTECTED]
> MySQL really should throw an exception/error rather than just quietly
> trim your data and accept it. When your data is critical, and your
> business depends on it, you can't have bad data quietly going
> into th
> -Original Message-
> From: Michael McTernan [mailto:[EMAIL PROTECTED]
> > if you don't have error checking in yourself, that's your problem
> > not mysql's problem.
>
> True, but still doesn't help when someone inexperienced with
> MySQL makes a
> mistake and buggers the database...
> -Original Message-
> From: Wesley Baker [mailto:[EMAIL PROTECTED]
> What I want is to know how to build a SELECT statement which will
> return all components of mynewpc and navigate down the
> bill-of-materials
> and also return all the components for the case, the powersupply and
>
> -Original Message-
> From: Madscientist [mailto:[EMAIL PROTECTED]
> We use this mechanism, but we do our mysqldumps from a slave
> so the time doesn't matter.
Excellent idea.
> Interesting side effect: A GZIP of the data files is _huge_.
> A GZIP of the
> mysqldump is _tiny_. For
> > -Original Message-
> > From: Michael Collins [mailto:[EMAIL PROTECTED]
> > Is there any "best-practices" wisdom on what is the most preferable
> > method of backing up moderately (~10-20,000 record) MySQL 4
> > databases? A mysql dump to store records as text, the
> format provided
>
> -Original Message-
> From: Andrew Kuebler [mailto:[EMAIL PROTECTED]
> Can anyone explain why:
>
> SELECT ROUND(.012345, 5)
> -> .01234
>
> Why doesn't mysql round the 5 up to .01235? How do I get it
> to round up?
Oftentimes standard practice is to round up if the digit before the
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Somehow the mysql mailserver got listed in spamcop?
Probably the usual SpamCop GIGO problem. If people send false reports,
systems that don't deserve it get listed. I don't use Spamcop anymore for
that reason.
-
> -Original Message-
> From: Bob Loeffler [mailto:[EMAIL PROTECTED]
> I have my rule in Outlook set up as:
>
> "Apply this rule after the message arrives
> with lists.mysql.com in the message header
> move it to the MySQL and PHP folder"
I was about to suggest the same thing, except th
> -Original Message-
> From: Matt Babineau [mailto:[EMAIL PROTECTED]
> I am running 4.0.15-standard on RH9. My mysql database just stopped
> working, is there a way I can log information about why it stops like
> this? the *.err was unhelpful.
Did you just install a glibc upgrade/bugfix
> -Original Message-
> From: Travis Reeder [mailto:[EMAIL PROTECTED]
> Is there a way to give mysql a lower priority?
If you're on a UNIXish operating system, you could try running it with the
'nice' command. 'nice' lets you set the priority of the process you launch
with it.
Note that
> -Original Message-
> From: Scott Haneda [mailto:[EMAIL PROTECTED]
> Pretty much every time I post to mysql list, I get one of the
> below back,
> what is this all about and how can I stop it...
Looks like, somehow, the Internet Oracle got subscribed. Maybe a virus
forged mail that a
> -Original Message-
> From: Keith C. Ivey [mailto:[EMAIL PROTECTED]
> It's true that mysqldump doesn't put the data for the index itself
> into the dump file. That does not automatically mean that the dump
> files will be smaller than the .MYD, .MYI, and .frm files combined.
> The
> -Original Message-
> From: Keith C. Ivey [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 26, 2003 5:49 PM
> The dump file will be larger than the MyISAM data file for the
> original table -- especially if you have many non-text columns
> (dates, numbers, ENUM columns, etc.). In som
> -Original Message-
> From: Lenz Grimmer [mailto:[EMAIL PROTECTED]
> Actually, you can create larger files on 32bit Linux systems
> as well. It's
> just that the file system and the C library must have support for LFS
> (Large File Support):
>
> http://www.suse.de/~aj/linux_lfs.html
> -Original Message-
> From: Fred van Engen [mailto:[EMAIL PROTECTED]
> Sorry, you'll need a backup. If your backup is not recent
> enough and you
> have a binary log (e.g. for replication), you can use that
> log to restore
> the database state.
If you have a backup and the update lo
MySQL can use indexes to sort, but not when your WHERE clause contains a
column other than the one being sorted on.
I think the MySQL manual has a good section on what 'filesort' means and
when MySQL uses it. Basically it's selecting all the rows that meet your
WHERE clause, then running a quicks
> -Original Message-
> From: MyLists [mailto:[EMAIL PROTECTED]
> The main thing you should realize right off the bat is that
> Access gives you
> a lot of functionality with buttons and other controls and
> they are quite
> easy to control with macros and/or VBA. However, depending on
> -Original Message-
> From: Peter Rønning [mailto:[EMAIL PROTECTED]
> I'm planning to set up an MySQL database on a server, and
> connect to it
> over the internet (no connection to a website or anything, just a
> private db server). Just wondering what is the recomended way
> to do it,
> -Original Message-
> From: mos [mailto:[EMAIL PROTECTED]
> I could encrypt certain table fields, but this will make
> writing the front
> end a pain because all SQL statements will now need to be
> changed any time
> a new column is encrypted.
It also won't help you any, because t
> -Original Message-
> From: Seth Brundle [mailto:[EMAIL PROTECTED]
> > I don't have to wait for some remote, overloaded server
> > to respond.
>
> I dont understand this one at all.
Every web forum I've used has been slow. I don't want to have to wait 10-20
seconds to pull up each me
> -Original Message-
> From: Seth Brundle [mailto:[EMAIL PROTECTED]
> This makes no sense as message I post to a Yahoo! Group get emailed to
> opt-in members and appears on the group within seconds, while
> I may not
> receive something I posted to the MySQL list for minutes or
> somet
> -Original Message-
> From: Seth Brundle [mailto:[EMAIL PROTECTED]
> I've worked with MySQL for about 7 years
> and have never
> found it convenient.
Fair enough. But I've worked with probably half a dozen web boards and have
yet to see one I liked better than an email list. All the
> -Original Message-
> From: Seth Brundle [mailto:[EMAIL PROTECTED]
> H...seems like some Yahoo! employee has never used
> Yahoo! Groups ;)
I know a lot of people who refuse to use Yahoo Groups because of Yahoo's
very open and ever-changing privacy policy.
Most of the other comb
> -Original Message-
> From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
> I really hate on-line forums. They're difficult to track because I
> must remember visit them daily.
Agreed. I don't need yet another web page to keep track of. I prefer to
let my mail reader thread up the messag
Would MyODBC do what you want? I'm using it to connect MS Access to MySQL,
and also to connect a Borland Delphi application to a MySQL database. It
works pretty well. Consult the FAQ for known glitches with specific
applications.
> -Original Message-
> From: LaBranche, Kevin [mailto:[EM
ception saying that 4294967295 is not a valid value for this
field.
Do I have any options other than giving up and using a signed BIGINT field?
--
David Brodbeck, System Administrator
InterClean Equipment, Inc.
Ypsilanti, M
Have you checked for network problems? You might try FTPing a file to and
from the production server, or something similar, just to rule this out.
I've had slowness problems with various apps that were driving me *nuts*
until I found a network issue causing them. In a few cases I had a duplex
mi
> -Original Message-
> From: Michael T. Babcock [mailto:[EMAIL PROTECTED]]
> I would E-mail the reiserfs list and ask for whether ReiserFS
> would be
> better for a MySQL-only partition than ext3 and see what answers you
> get. In the worst case, you'll have some extreme "resierfs is
> -Original Message-
> From: Steve Quezadas [mailto:[EMAIL PROTECTED]]
> I notice that sometimes when I establish a connection with
> myODBC with
> Microsoft Access, and send it occasional sql statements it
> works fine at
> first. But if you let it sit for, say, 30 minutes and comes
> Stupid filter fodder: sql,query,queries,smallint
> > -Original Message-
> > From: Dean Householder [mailto:[EMAIL PROTECTED]]
>
> > The problem is with the new glibc-2.2.5-40 package released
> > on October 3,
> > 2002. Apparently its a known issue, and people are aware of
> > it. T
> -Original Message-
> From: Michael T. Babcock [mailto:[EMAIL PROTECTED]]
> Csongor Fagyal wrote:
>
> > Oh and one more thing I am not really sure of: sometimes
> defining the
> > day as 3600*24 or the year as 3600*24*365 is not the best
> idea... just
> > think about leap
> -Original Message-
> From: Mike Wexler [mailto:[EMAIL PROTECTED]]
> The best answer is, "try it and see." If your tables are
> small. Adding
> and removing indices is very quick. And testing queries is
> also very quick.
Enabling the slow query log, and enabling log-long-format can
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> I can FTP and telnet in to my site as "admin" or a user, but
> all the files in
> /var are owned by root so cannot be deleted, with the
> exception of several
> mysql files owned by mysql, which I also cannot
> -Original Message-
> From: Joe Stump [mailto:[EMAIL PROTECTED]]
> We hit the 2gb file limit in Linux (NOT a MySQL problem) and
> moved to Solaris without incident.
This appears to have been largely fixed in Linux, too, if you use a recent
kernel and glibc. I recently tried creating
I used MySQLFront. It wasn't entirely automatic, but it did a reasonable
job. There are some gotchas.
Take your time, and be sure to read the notes for using Access and MyODBC
with MySQL, if that's how you're going to do it -- some column types are not
recommended. You'll want to add a TIMEST
> -Original Message-
> From: Pae Choi [mailto:[EMAIL PROTECTED]]
> Seems like all against I see are coming from MySQL team.
> I know MySQL is stealing a lot of code from the public
> domain, inclduing the SSL part. How funny!
By definition you can't "steal" anything from the public doma
> -Original Message-
> From: Neil Tompkins [mailto:[EMAIL PROTECTED]]
> Can anyone recommend a software app. I could buy to be able
> to dump data and
> table structures to a text file. Ideally as mentioned before
> I need to run
> this on a hourly basis.
Backing up the entire data
-Original Message-
> From: David Brodbeck [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 27, 2002 9:09 AM
> To: '[EMAIL PROTECTED]'
> Subject: MySQL hangs on remote connections
>
>
> I'm having a rather bizarre problem...at least, it seems
>
x27;s been made is the RedHat glibc update to fix the
name resolver security hole was done, and mysql wasn't restarted until now,
so it would have been running on the old glibc until the reboot. I checked
all the tables with myisamchk and they're okay.
Any ideas?
--
Da
48 matches
Mail list logo
