Hello.
Select syntax is correct on my 4.1.10a MySQL instance.
EXPLAIN is telling me 'Impossible WHERE' until I put
values in the tables so the query could produce at
least several rows. After that everything was OK.
Graham Anderson <[EMAIL PROTECTED]> wrote:
> this sql works on mys
Privet:)
See:
http://dev.mysql.com/doc/mysql/en/upgrading-to-arch.html
http://dev.mysql.com/doc/mysql/en/moving.html
"Denis Gerasimov" <[EMAIL PROTECTED]> wrote:
>
> Hello list,
>
> I have two MySQL 4.1 servers, one local and one remote. I need to transfer
> database from
Hello.
If you can reproduce this problem on several different installations, you
may open a new bug (because #312 is closed) and leave there a note about bug
#312.
"Stephen Moretti (cfmaster)" <[EMAIL PROTECTED]> wrote:
> Gleb Paharenko wrote:
>
> Thanks for the reply.
>
>>S
hai, i was trying to install mysql 4 server on
windows 2000 when configuringthe server i received the below error
in mysql server instance configuration "could not start
the service mysql error:0" can i know how to solve the
error regards p
rao
No virus found in this outgoing messag
Hi,
I searched for previous discussion on this topic, but didn't find any.
I would like to see a centralized MySQL hosted UDF archive and development
project. The only existing 'archives' seem to be somewhat poorly
maintained (sorry), and suffer for their duplicated efforts and being
loosely di
- Original Message -
From: "Denis Gerasimov" <[EMAIL PROTECTED]>
To: "MySQL General List"
Sent: Wednesday, March 30, 2005 1:12 AM
Subject: The best way to transfer data to another server
>
> Hello list,
>
> I have two MySQL 4.1 servers, one local and one remote. I need to transfer
> da
Wow, you are asking a lot, especially since an inexpensive UPS could be
had for less than $50. You don't need one to keep the system up for a
long time, just long enough for writes to finish. A few minutes should
be plenty.
I don't see a problem with IDE drives. Your drive access patterns are
That is a really good idea - though I am not sure there is much of
those out there to justify the cause, nor many developers actually
using UDFs.
Still, having them all in one place could be nothing but a good thing.
MarkP
On Wed, 30 Mar 2005 14:39:11 +0100 (BST), Dan Bolser
<[EMAIL PROTECTED]>
- Original Message -
From: "David Blomstrom" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, March 29, 2005 11:29 PM
Subject: Need Help with 813-MDB File
> I acquired a CD-ROM that lists many thousands of
> animal species. The main file is a 813-MB MDB file.
> I'm not sure if it's a spreadsheet
Hi!
MySQL-5.0.3 is probably the most important new MySQL release in several
years. On the MySQL side, a vast number of new features, like stored
procedures and views, have been implemented in 5.0. On the InnoDB side, we
changed the table format to a more space-saving one, and implemented the
2-
Is there a description of tables anywhere on CD-ROM for Access database.
Mikhail
-Original Message-
From: Rhino [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 30, 2005 9:10 AM
To: David Blomstrom; mysql@lists.mysql.com
Subject: Re: Need Help with 813-MDB File
- Original Message
> >
> > Hello list,
> >
> > I have two MySQL 4.1 servers, one local and one remote. I need to
> transfer
> > database from one server to another. What actually is the best way of
> > handling this task?
> >
> > Are there any standard MySQL tools available for doing that (I mean
> MySQL
> > Adminis
On Wed, 30 Mar 2005, Denis Gerasimov wrote:
>
>> >
>> > Hello list,
>> >
>> > I have two MySQL 4.1 servers, one local and one remote. I need to
>> transfer
>> > database from one server to another. What actually is the best way of
>> > handling this task?
>> >
>> > Are there any standard MySQL too
On Wednesday 30 March 2005 10:49, Brent Baisley wrote:
> Wow, you are asking a lot, especially since an inexpensive UPS could be
> had for less than $50. You don't need one to keep the system up for a
> long time, just long enough for writes to finish. A few minutes should
> be plenty.
Yeah, remem
On Wed, 30 Mar 2005, Mark Papadakis wrote:
>That is a really good idea - though I am not sure there is much of
>those out there to justify the cause, nor many developers actually
>using UDFs.
Cheers :)
I think with the right infra more people would start using and developing
UDF's, especially if
Thanks for all the tips. I was able to import it with
Navicat. In fact, I was amazed at how smoothly it
went. I think it imported about 30 separate tables -
nearly 4 million rows - before Navicat froze. But I
was working on some other programs and probably ran
out of memory.
It recorded over 8,000
I also think this would be a good idea. I have written some UDF's
for specific internal use and often wondered if they would be useful
to others. It would be nice if there was a centralized place to search
for UDFs, so you don't have to re-invent the wheel everytime you need
a function. I thin
hey...
i now have FC2 running mysql-4.1.10a, php5, apache 2.0.51.
for some reason, the mysql rpms that i got from rpmfind.net/rpm.pbone,
etc... didn't seem to work, as i kept getting weird lib related errors...
i started using mysql-3.23 on FC2.
i basically followed the path/instructions from
Hello,
maybe this is a silly question but how useful it is to create indexes on
columns containing only values 0 and 1 (true and false)?
TIA,
Dusan
Du?an Pavlica <[EMAIL PROTECTED]> wrote on 30/03/2005 16:35:40:
> Hello,
>
> maybe this is a silly question but how useful it is to create
> indexes on columns containing only values 0 and 1 (true and false)?
Since I believe that MySQL ignores indexes if it expects to get more than
30% hits, i
Does MySQL 4.1 support the use of GROUP BY and ORDER BY used in
conjunction with one another? I have tried to execute several queries
with both these clauses but the result set I get is different from what I
expect. My queries read as follows:
SELECT *, *, * FROM *
WHERE *
GROUP BY * ORDER BY *
A
>maybe this is a silly question but how useful it is to create indexes on
>columns containing only values 0 and 1 (true and false)?
Perhaps, instead of the index, you might revise your schema a bit.
Why do you have this boolean column? What are you trying to
achieve?
With regards,
Martijn Tonie
I have data in a table listed as
44:22:22
333:33:33
It stands for hhh:mm:ss
I want to break each part of the data into different parts based on the ':' to
separate them. Then I want to take that data and sum it. I wrote an if
statement to parse through this table but I can't get it to work. I
On Wednesday, March 30, 2005 09:49, Christopher Vaughan wrote:
> I have data in a table listed as
> 44:22:22
> 333:33:33
> It stands for hhh:mm:ss
If you convert it to a time field you can use mysql built-in functions
to do what you want. You are limited to the range -838:59:59 to
838:59:59 th
On Wednesday, March 30, 2005 10:24, Christopher Vaughan wrote:
> Tom Crimmins on Wednesday, March 30, 2005 at 11:10 AM -0500 wrote:
>> If you convert it to a time field you can use mysql built-in
>> functions to do what you want. You are limited to the range
>> -838:59:59 to 838:59:59 though.
>
I think I remember a match_at(":") or pat_index(":") UDF which would
return the position of the first ":" for you, but I can't find it if it
does exist.
On Wed, 30 Mar 2005, Christopher Vaughan wrote:
>I have data in a table listed as
>44:22:22
>333:33:33
>It stands for hhh:mm:ss
>I want to b
Hi All,
When you do a insert into a MySQL database and the disk is full, the
insert just hangs waiting for that table to become available.
This is fine for applications that care about data integrity. In this
case I care more about availability and speed and would prefer it if the
inserts grac
"Christopher Vaughan" <[EMAIL PROTECTED]> wrote on 30/03/2005 16:48:47:
> I have data in a table listed as
> 44:22:22
> 333:33:33
> It stands for hhh:mm:ss
> I want to break each part of the data into different parts based on
> the ':' to separate them. Then I want to take that data and sum it.
Just forwarding this to the list.
On Wednesday, March 30, 2005 10:43, Christopher Vaughan wrote:
> Tom Crimmins on Wednesday, March 30, 2005 at 11:31 AM -0500 wrote:
>> Look at the functions HOUR(time), MINUTE(time), SECOND(time). These
>> will give you interger output for each part of the time
Hello.
See:
http://dev.mysql.com/doc/mysql/en/windows-troubleshooting.html
Search in archives at http://lists.mysql.com/mysql for more advices about
solving this problem. For example see:
http://lists.mysql.com/mysql/178152
"prathima rao" <[EMAIL PROTECTED]> wrote:
> [--
Duan Pavlica writes:
>maybe this is a silly question but how useful it is to create indexes
>on columns containing only values 0 and 1 (true and false)?
Most of the time I'd say such an index would not be real useful. If
the distribution of this column's values is equally distributed between
thes
My response intermixed...
"Denis Gerasimov" <[EMAIL PROTECTED]> wrote on 03/30/2005 09:29:00
AM:
>
> > >
> > > Hello list,
> > >
> > > I have two MySQL 4.1 servers, one local and one remote. I need to
> > transfer
> > > database from one server to another. What actually is the best way
of
> >
Hi,
I'm getting this strange error when there are more than 1100 mysql
connections connected to the same server.
[EMAIL PROTECTED] mysql]# bin/mysql
bin/mysql: connect to server at 'localhost' failed
error: 'Can't create a new thread (errno 11). If you are not out of
available memory, you can con
Asad Habib <[EMAIL PROTECTED]> wrote on 03/30/2005 10:53:38 AM:
> Does MySQL 4.1 support the use of GROUP BY and ORDER BY used in
> conjunction with one another? I have tried to execute several queries
> with both these clauses but the result set I get is different from what
I
> expect. My querie
On Wed, 30 Mar 2005 08:49:13 -0500, Brent Baisley <[EMAIL PROTECTED]> wrote:
> Wow, you are asking a lot, especially since an inexpensive UPS could be
> had for less than $50. You don't need one to keep the system up for a
> long time, just long enough for writes to finish. A few minutes should
> b
David
Please also have a look at MYdbPAL for MySQL. Freeware again - this will
sort out any schema conversions you might need - auto corrections. Plus you
can model the schema.
MDB conversion is shown in the tutorials.
Tim Hayes
-Original Message-
From: David Blomstrom [mailto:[EMAIL PR
Peter Brawley wrote:
Perhaps Oracle also has such a setting too. MySQL doesn't.
As a matter of fact, Oracle goes the other way in that if you store ''
into a VARCHAR field, it actually stores a NULL there. But it's
inconsistent in that doesn't consider a NULL varchar column to be = ''
(a literal
We finally split our huge logging aspect of an application to its own system,
and we changed the table type from InnoDB to MyIsam. This is a logging table,
1 log writer, many, many selects from customer care reps looking up the last
500 or so records. These are logs of timed events, so they al
Using MySql Connect/J (mysql-connector-java-3.1.7.tar)
on Linux Fedora 2.
I use a Statement object and do the following query:
String myquery = "SELECT * FROM term WHERE name REGEXP (\'"+ name
+"\') and term_type=\'"+ ontology +"\' LIMIT 20";
table term has 6 columns.
MySql
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
l'eau wrote:
>
> Using MySql Connect/J (mysql-connector-java-3.1.7.tar)
> on Linux Fedora 2.
>
> I use a Statement object and do the following query:
>
> String myquery = "SELECT * FROM term WHERE name REGEXP (\'"+ name
> +"\') and
I've got a good deal of experience using mysql, but never in a large
production environment with many concurrent users.
Using the InnoDB engine, what is the general practice for ensuring
data integrity when multiple users are writing to the same table?
Should I explicitly lock the table before I
Hi all,
I'm getting the following error when attempting to run a hot backup of a
4.0.18 MySQL database using ibbackup:
ibbackup: We wait 10 seconds before starting copying the data files...
050330 14:26:33 ibbackup: Copying /mysqldata/mysqld1/ibdata1
ibbackup: Error: log scan was only able to
Hi,
I tried searching for this problem, but I couldn't find any reference
to it, so here goes...
using mysql 4.0.23, I created two tables, one of them whose key is
packed. My goal is to see the effect on the size of the index file.
mysql> show create table Unpacked;
+--+--
Sorry for the confusion. In this case I am using the * to denote a field
name instead of the wild card character.
- Asad
On Wed, 30 Mar 2005 [EMAIL PROTECTED] wrote:
> Asad Habib <[EMAIL PROTECTED]> wrote on 03/30/2005 10:53:38 AM:
>
> > Does MySQL 4.1 support the use of GROUP BY and ORDER BY u
If the power is "yanked" a journaled file system knows exactly what it
was doing at the time of failure, what didn't finish, and can recover
from any errors caused by the failure.
A non-journaled file system would need to run a check to see if
everything is ok. This could take a long time on a b
In the last episode (Mar 30), Julian Pellico said:
> I tried searching for this problem, but I couldn't find any reference
> to it, so here goes...
>
> using mysql 4.0.23, I created two tables, one of them whose key is
> packed. My goal is to see the effect on the size of the index file.
>
> for
Hi all,
I need to move a database from a 4.0.20 MySQL server to a 4.0.17
server. I expect it will work fine when simply scp-ing the whole
/var/lib/mysql/MY-DATABASE to the other server's /var/lib/mysql
directory, with only a minor version difference.
Can anyone confirm this is going to work and
Hi,
Anyone know how to find out what are the rows that are reported by
mysqlimport as "deleted"?
Thanks
HT
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Just keep in mind that the ORDER BY will require MySQL to take the
full resultset and reorder it in a temporary table. MySQL has
extended the GROUP BY clause as of version 3.23.34 so that you can
also specify ASC and DESC after columns named in the clause.
On Wed, 30 Mar 2005 10:53:38 -0500 (EST)
Thanks Dan,
I ran myisamchk as you suggested. The detailed results are below, but
in summary there's no difference between the two indices. Perhaps
mysql doesn't want to pack the key for some reason? I'm running
FreeBSD 4.1.
Checking MyISAM file: /home/y/var/mysql/data/Test/Unpacked.MYI
Data reco
If I try to read table 'b' after locking table 'a', I expect to get
the error message "Table 'b' was not locked with LOCK TABLES".
However, if my query that accesses table b is stored in the query
cache, I don't get the error. This causes a problem in the following
scenario:
User 1:
LOCK TABLES
I posted this late last Friday. I'm hoping everyone missed it and that
someone has an answer. :-)
We have a quote server on both a 2003 server and an XP machine. The quote
server is an asp.net server.
The XP machine is closing the connections without a problem.
For some reason
update
_cached_LinesNotTolling LNT inner join TelecomLinePosting TLP
on LNT.Line=TLP.Line
inner join TelecomAccountPosting TAP
on TLP.TelecomLinePostingID=TAP.DanPK
inner join PhoneTypes
on TLP.LineType=PhoneTypes.ID
set
AnnualService=sum(TLP.Service)
>Description:
I installed MySQL-server-4.0.15-0 and am getting the following error
message:
050330 12:09:32 [ERROR] Character set information not found in
'/usr/share/mysql/english/errmsg.sys'. Please install the latest version of
this file.
050330 12:09:32 [ERROR] Aborting
>How-To-Repea
On Wednesday, March 30, 2005 22:25, Daniel Kasak wrote:
> update
> _cached_LinesNotTolling LNT inner join TelecomLinePosting TLP
> on LNT.Line=TLP.Line
> inner join TelecomAccountPosting TAP
> on TLP.TelecomLinePostingID=TAP.DanPK
> inner join PhoneTypes
> on T
As my company and I understand it, if you intend on distributing mySQL on
this appliance and the appliance is a sealed box with your own proprietary
code (like PHP or C or Java or whatever) that interfaces to the
STOCK/Untouched RDBMS, you NEED a mySQL Commercial License.
This license is a ridicu
Hi All,
below is my /etc/init.d/mysql content, but, mysql is not starting at
boot on Fedora3. Have I missed something fundamental.? I need mysql to
start at boot for snort to connect to it. Currently, snort gives an
error stating it can't connect. Cheers.
Mark Sargent.
[EMAIL PROTECTED] ~]# cat
MySql loses money from many vendors on this very point. Of which they do
not budge.
We have a Point of Sale software company who can distribute Oracle cheaper.
They only require a percentage of the final product price that their product
is packaged with. When the company explained they would rat
On Wednesday, March 30, 2005 23:26, Mark Sargent wrote:
> Hi All,
>
> below is my /etc/init.d/mysql content, but, mysql is not starting at
> boot on Fedora3. Have I missed something fundamental.? I need mysql to
> start at boot for snort to connect to it. Currently, snort gives an
> error statin
Yeah. It's silly. The whole hardware x86 1U rack mount we use with 2.4Ghz
proc, 256MB, 40GB HD, dual Gbps NICs is only $500. I don't know what crack
the mySQL AB guys are smoking to think that they are competitive. We've
already started to wrap our product SQL calls in our own API so we can
migrate
Hi Folks,
Take a deep breath and see how much an Oracle license is for a Solaris
box with 4 cpus, AFAIK start looking in the thousands of dollars. Try
SQL server, Sybase or Informix. None of the above mentioned are
particularly cheap, some of these are costing over $595.00 per seat not
per unit.
Tom Crimmins wrote:
>On Wednesday, March 30, 2005 22:25, Daniel Kasak wrote:
>
>
>
>>update
>>_cached_LinesNotTolling LNT inner join TelecomLinePosting TLP
>>on LNT.Line=TLP.Line
>>inner join TelecomAccountPosting TAP
>>on TLP.TelecomLinePostingID=TAP.DanPK
>>inner jo
Tom Crimmins wrote:
On Wednesday, March 30, 2005 23:26, Mark Sargent wrote:
Hi All,
below is my /etc/init.d/mysql content, but, mysql is not starting at
boot on Fedora3. Have I missed something fundamental.? I need mysql to
start at boot for snort to connect to it. Currently, snort gives an
erro
> > > > Are there any standard MySQL tools available for doing that (I mean
> > > MySQL
> > > > Administrator/Query Browser etc.)
>
> Have you looked at mysqldump and mysqlhotcopy?
I know about standard mysqldump utility but I actually needed something with
GUI interface.
> > I assume that tha
Hi,
I'm working with JBoss and MySQL 4.0.22 (and 4.0.18 on Testsystem). But
under the load, I get sometimes Exceptions like this:
java.sql.SQLException: Deadlock found when trying to get lock; Try
restarting transaction message from server: "Lock wait timeout exceeded;
Try restarting transactio
Hi!
last night we try to upgrade from 4.0.15 to 4.0.24. We thought, that it
is possible without dumping data. We upgrade only server (clients were
still 4.0.15). In changelogs in versions higher than 4.0.15 there were
no info about some incompatible changes and those bound with InnoDB were
conn
To have mysql to start at boot you need to inform the inetd (daemon) that
mysql should be launched at one of the 6 levels:
Use chkconfig to have mysql start in one of the level (2,3,4,5,6)
5 being X windows.
There are two ways to check that mysql will be loaded:
- 1 - by checking the file in /
>maybe this is a silly question but how useful it is to create indexes on
columns containing only values 0 and 1 (true and false)?
Perhaps, instead of the index, you might revise your schema a bit.
Why do you have this boolean column? What are you trying to
achieve?
I use boolean columns as a fla
--- Daevid Vincent <[EMAIL PROTECTED]> wrote:
> As my company and I understand it, if you intend on
> distributing mySQL on
> this appliance and the appliance is a sealed box
yes
> with your own proprietary
> code (like PHP or C or Java or whatever) that
> interfaces to the
> STOCK/Untouched RDBM
Okay so I'm stumped. What I want to do is run a query that can tell me
the average number of selected values in a set column.
With the column:
mySetCol SET ('cat','dog','mouse','giraffe','lion')
A row with the value "dog,mouse,lion" would return 3
A row with the value "cat,giraffe" would return 2
Dan,
What is a "2003 server?" Do you mean Win2K? I'm not aware of any OS
that references 2003. Perhaps that is part of the reason for no response?
I don't have any MySQL systems running on Windows machines, so I can't
answer your question, but perhaps there are those out there who can
Robert-
I apologize for not being clearer.
The operating system is Windows 2003 Server.
Dan
-Original Message-
From: Robert Dunlop [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 30, 2005 3:09 PM
To: Daniel Cummings; mysql@lists.mysql.com
Subject: Re: mysqlconnecernet not closing conne
Dan,
My fault. I've drifted away from MS implementations; I wasn't aware of
the Win 2003 server designation.
Bob
- Original Message -
From: "Daniel Cummings" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, March 30, 2005 3:18 PM
Subject: RE: mysqlconnecernet not closing connections w/2003
Suppose i distribute MySQL-4.1 with an appliance,
which is a sealed x86 machine running a Linux
distribution made by another entity (ok, it's Red
Hat). I don't write any code that's directly linked to
MySQL, I'm only using the existing php-mysql, etc.,
packages already provided by the distribution,
Luke Bowerman wrote:
With the column:
mySetCol SET ('cat','dog','mouse','giraffe','lion')
A row with the value "dog,mouse,lion" would return 3
A row with the value "cat,giraffe" would return 2
I've been able to get the MySQL server to give me a binary version of
the data...
SELECT RPAD(BIN(mySetC
At 16:06 -0800 3/30/05, Hassan Schroeder wrote:
Luke Bowerman wrote:
With the column:
mySetCol SET ('cat','dog','mouse','giraffe','lion')
A row with the value "dog,mouse,lion" would return 3
A row with the value "cat,giraffe" would return 2
I've been able to get the MySQL server to give me a binary
Hi Pat,
I thought that was discussed before over and over on this mailinglist. I
am surprised that many people have isues with that topic. Basically it
boils down to 2 questions.
1) Will you include and ditsribute the source code and the changes (if
any) and the GPL license in your product ?
If
--- [EMAIL PROTECTED] wrote:
>
> I thought that was discussed before over and over on
> this mailinglist. I
> am surprised that many people have isues with that
> topic.
Well...
1. Licensing in general can be quite confusing for a
non-lawyer geek
2. I want to make 101% sure I don't take any wrong
78 matches
Mail list logo
