Is this a release candidate as the version in your message subject would
imply, or is it an actual release, as your message states? Or does
MySQL AB even bother to differentiate the two?
- Original Message -
From: Lenz Grimmer [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc:
No, you don't want a table for each monitor. One table for the data will
be _much_ easier to work with. If you want a history then you need to
insert a new record for each datapoint that you get, with, as Frank
suggested, a date/time column. How large your table will get will depend
on the
We're running an application that creates table names in a numeric
sequence. For example:
jst998_foo
jst998_bar
jst999_foo
jst999_bar
jst0001000_foo
jst0001000_bar
jst0001001_foo
jst0001001_bar
I need to write a maintenance app that first needs to determine the
numeric range of
. Dictated by this (old as alabama)
application. They refuse to support newer versions of MySQL.
- Original Message -
From: Eric Bergen [EMAIL PROTECTED]
To: Jim McAtee [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Monday, May 02, 2005 11:31 AM
Subject: Re: Determining if a table exists
I
I have a table that tracks events by month and year. The field names are
(you guessed it) 'month' and 'year'. I need to do queries over some date
range from variables beg_month, beg_year to end_month, end_year.
How can I do this?
SELECT state,
SUM(borks) AS borkcount
FROM borkstats
Say a row is inserted into a table with an auto_increment column and then
deleted before another record is inserted. When a new row is inserted,
will the value of the auto_increment column be the same as the deleted
record's, or will it be one greater?
--
MySQL General Mailing List
For list
The reason I asked about auto_increment behavior is that I'm looking at
the output from mysqldump --opt and there are no commands to preserve/set
the auto_increment value. Is there a mysqldump option to do this? Or
will restoring from a dump always leave the auto_increment value one
greater
Is it recommended to create a MySQL user for doing backups? Running
mysqldump from a script, the username and password will have to be
embedded in plain text.
If I were to create a MySQL user expressly for doing nightly backups what
are the minimum permissions needed?
--
MySQL General
- Original Message -
From: Daniel Kasak [EMAIL PROTECTED]
To: Jim McAtee [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Wednesday, February 23, 2005 2:39 PM
Subject: Re: Backup User
Jim McAtee wrote:
Is it recommended to create a MySQL user for doing backups? Running
mysqldump from
A server running MySQL 3.23 crashed yesterday. Since bringing it back
online, doing inserts into a particular table will throw an error
regarding a duplicate key value in an auto_increment field. I assume that
something is corrupted.
There are 779239 records, the most recently added having
record if
found, otherwise create one in one query.
- Original Message -
From: Eric Bergen [EMAIL PROTECTED]
To: Jim McAtee [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, December 04, 2004 2:40 PM
Subject: Re: More efficient way?
Depending on how your application works you might
I have an application which keeps a table of daily event counters related
to other records in a databse. Since the trackingrecords are kept on a
daily basis new records are created each day for items being referenced.
In pseudo-code:
// Check for the existance of daily tracking record
SELECT
- Original Message -
From: [EMAIL PROTECTED]
To: Jim McAtee [EMAIL PROTECTED]
Cc: MySQL List [EMAIL PROTECTED]
Sent: Thursday, November 18, 2004 8:28 AM
Subject: Re: copy data only from one table to another table
A semi-generic solution:
You have tableA with columns (col1, col2, col3
- Original Message -
From: Daniel Kasak [EMAIL PROTECTED]
To: Chip Wiegand [EMAIL PROTECTED]; MySQL List
[EMAIL PROTECTED]
Sent: Wednesday, November 17, 2004 5:04 PM
Subject: Re: copy data only from one table to another table
Chip Wiegand wrote:
How do I copy all data only from one
I have a web application using MySQL 3.2x server. In the application
theres an HTML form used for searching an ISAM table of about 500k
records. To populate select (drop down) fields in the form I do a couple
of SELECT DISTINCT queries against this table.
What's the best indexing strategy to
| Extra |
+-+
438710 | Using index |
+-+
- Original Message -
From: Michael Stassen [EMAIL PROTECTED]
To: Jim McAtee [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, November 16, 2004 10:03 PM
Subject: Re: Speed up SELECT DISTINCT
Can I run two different versions of MySQL on the same server? I've got a
commercial application for which the vendor will only support MySQL 3.x
and makes no guarantees if running MySQL 4. But I'd like to migrate a
number of our own web applications to MySQL 4. My choices are take my
(Apologies in advance for the crossposting, but I asked the same questions
on the MySQL Windows list and didn't get any replies)
I need a simple backup mechanism for MySQL (3.2x) that will backup all
databases on a server. Something that can be run from a scheduled Windows
batch file. From what
Does MySQL have a string contatenation operator, or must you use the
CONCAT() function?
SELECT firstname + ' ' + lastname AS fullname
FROM customers
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Are the TEXT column types padded out to their max length by spaces?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
- Original Message -
From: Richard Davey [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, March 01, 2004 11:02 AM
Subject: Re: Type TEXT
Hello Jim,
Monday, March 1, 2004, 5:44:22 PM, you wrote:
JM Are the TEXT column types padded out to their max length by spaces?
No,
We're running MyODBC 3.51 on Windows 2000 Ssrver with IIS5 and ColdFusion 5
applications and don't see any memory leaks. In a very hight traffic
application, you'll want to keep connections open as long as possible anyway.
There's also a MyODBC list that you might try.
- Original Message
[EMAIL PROTECTED] wrote:
I say go with RAID 5, on a controller card.
Mirroring just gives you backup, and you lose half your diskspace. It
offers
no performance benefit, and actually the computer might have to work
harder
to make sure the drives are in sync.
I do not think it is
Quick question or two regarding the IP addresses MySQL listens on:
Does MySQL automatically listen on all IP addresses bound to the machine on
which it runs? (MySQL 3.23.xx on Windows 2000).
I've got a multi-homed server with dual NICs. To date I've always connected
from other servers on an IP
- Original Message -
From: Pascal Délisle [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, August 03, 2003 1:02 PM
Subject: Re: Nested SELECT statements problem
Finally, I solved my problem by creating a temporary table that holds
the result of the subquery. So, it looks like
Is there any means of running MySQL (3.23, mostly MyISAM tables running on
Win2k Server) so that escaped character sequences (those preceded by a
backslash \) are _not_ interpretted as anything other than literals? We're
trying to port a large number of web applications that previously used MS
Why does the client doing the importing need to run on Linux? Don't you have
access to a Windows machine anywhere on the network? It shouldn't matter where
the target MySQL server is or what OS it's running on.
- Original Message -
From: Robert Morgan [EMAIL PROTECTED]
To: mysqllist
Either do two queries or suppress the display of customer information within
your application code. I'd probably do two queries, especially if asking for a
lot of customer info or there were potentially a large number of orders for a
given customer. Doing a join in either case gives you a lot of
- Original Message -
From: Mysql List [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, July 24, 2003 11:15 AM
Subject: Re: Huge Server configuration
I have RAID 5 with 5 hardisks, so usuable number of spindle will only be 4.
Unless you've designated one drive as a spare,
We have a very large MySQL database, and the designer of the database no
longer works for us. I need to re-create the same table structure, but
without the content, on a separate machine.
I know I can do a show tables on the existing db, and also a describe on
those tables, so I know what
the name of the
'CREATE TABLE' column that is returned?
SHOW CREATE TABLE mytable
- Original Message -
From: Jackson Miller [EMAIL PROTECTED]
To: Jim McAtee [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Friday, July 25, 2003 9:42 PM
Subject: Re: How to export db or table
Does MySQL automatically handle deleted row cleanup, or is it necessary to
periodically do this manually for tables with a lot of deletions? If it's
manual, what are the SQL commands to do this?
Also, what happens when changes are made to a field definition? From, say, int
to smallint, or
Since I received no responses, maybe someone can take a moment to explain why
this is such a stupid question.
- Original Message -
From: Jim McAtee [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 23, 2003 1:28 PM
Subject: Is it necessary to compress tables?
Does MySQL
Since I received no responses, maybe someone can take a moment to
explain why this is such a stupid question.
Maybe not stupid, but definitely please see the manual questions.
Answers to Question 1:
http://www.mysql.com/doc/en/DELETE.html
http://www.mysql.com/doc/en/Optimisation.html
What tools are available for importing delimted text files into MySQL tables?
I've got several very large, but simple (just seven columns of integer and
varchar) text files to import into a table.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Michael Satterwhite wrote:
So I can add the column, and I can set it to have an auto_increment, but
will that start out at 201? or will it start at 1 and propogate through?
If you don't modify the table definition, it will start at 1 and propagate
throughout: e.g.
Are you saying that it
Michael Satterwhite wrote:
Are you saying that it will propogate through the _existing_ rows, or only
on rows added later?
It will number all existing rows and continue with rows added later.
Interesting. In the case where you want to begin numbering existing rows at 1,
is it necessary
What's wrong with the following query? The application used to use Access via
ODBC, now running MySQL 3.23.xx, MyISAM table, accessed via MyODBC 3.51.01.
// Return last 20 searches
SELECT TOP 20 h.historyid, h.searchstring, h.serverid, s.shortname
FROM history h
INNER JOIN servers s ON
If storage space is really a big motivator, you can roll your own by using
something like unsigned integers, each of which will accomodate 32 bit fields.
Then use bitmasks to read/write the values. Probably makes writing WHERE
clauses a bit tedious, and doing joins on the bit fields may not be
Not sure where these came from, but in my users I've got a [EMAIL PROTECTED] and a
[EMAIL PROTECTED] Is this redundant, or is there a reason for this? The original
MySQL
install was done by an application we're running, but we've since added
additional databases.
thanks,
Jim
--
MySQL
Is there any way to seed a column set to autoincrement? Say I wanted it to
begin at 1.
- Original Message -
From: Greg Donald [EMAIL PROTECTED]
To: wael fareed [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, July 06, 2003 4:42 PM
Subject: Re: need help
my coulmn (id) is
David Lloyd wrote:
What would be the ideal RAID configuration for a dedicated MySQL db
server running on FreeBSD?
We're also running some MySQL databases on Windows 2000 Servers. What
about the best configuration for a dedicated W2k server running MySQL?
That depends on what your
Jim McAtee wrote:
David Lloyd wrote:
What would be the ideal RAID configuration for a dedicated MySQL db
server running on FreeBSD?
We're also running some MySQL databases on Windows 2000 Servers. What
about the best configuration for a dedicated W2k server running MySQL
What would be the ideal RAID configuration for a dedicated MySQL db server
running on FreeBSD?
We're also running some MySQL databases on Windows 2000 Servers. What about
the best configuration for a dedicated W2k server running MySQL?
Thanks,
Jim
--
MySQL General Mailing List
For list
..
Be sure to use a good raid controller, multiple channels for the disks if
possible..
On Sat, 5 Jul 2003, Jim McAtee wrote:
What would be the ideal RAID configuration for a dedicated MySQL db server
running on FreeBSD?
We're also running some MySQL databases on Windows 2000 Servers. What
45 matches
Mail list logo