Hi there,
I have a strange problem.
I am using Server version: 5.0.45 SUSE MySQL RPM
I made a backup of a database by copying its directory like so:
mv urulu urulu_X
then I recreateded the database, played a little with it and then
dropped it again.
the I moved the old database in place again.
no
Dear Friends,
I am having 2 tables as follow:
Table 1-> customer_id | contacts | etc this table has unique
customer_id while Table 2 may have more than 2 records with the same customer_id
Table 2-> customer_id | visit_no | details of visit
I want to know an example of updating
In the last episode (Oct 31), Jose Romero said:
> Hi,I have a mail system on FreeBSD 6.2 + Exim 4.62 + MySQL 5.0. Exim
> was compiled with MySQL support, the MySQL database is external to
> the mail server. Although the system works, I have a lot of daily
> messages in exim's log with the following
On Tuesday 30 October 2007, Warren Young wrote:
> Tim Johnson wrote:
> >> It isn't "broken," per se.
> >
> > When you say that it isn't "broken", could you please elaborate?
>
> Once again: It seems to me that you're seeing a purposeful choice of
> configuration. It could very well be that the c
Tim Johnson wrote:
It isn't "broken," per se.
When you say that it isn't "broken", could you please elaborate?
Once again: It seems to me that you're seeing a purposeful choice of
configuration. It could very well be that the configuration makes sense
in some one's use. The fact that i
Hi,
If you are using binaries from mysql.com and extract the files and when u try
to start the database it says in the error frm/* not found...then u might try
out this option as
Try to run the ./configure file which will come with binaries, It will auto
create the frm and MY* files under the
On Tuesday 30 October 2007, Warren Young wrote:
> Tim Johnson wrote:
> > Is there a possible repair routine to run?
>
> It isn't "broken," per se.
When you say that it isn't "broken", could you please elaborate?
And thanks in advance, because, from where I'm sitting, time is money
and I
Tim Johnson wrote:
Is there a possible repair routine to run?
It isn't "broken," per se.
Someone chose to build it with this configuration, and presumably that
person made a choice that is sensible for their needs. If it doesn't
work for you, you can either build MySQL from source with the
On Tuesday 30 October 2007, Warren Young wrote:
> Tim Johnson wrote:
> > The file pattern is *not* as I expressed it above.
>
> Yeah, I figured that out, and ignored the error in my reply.
>
> The answer remains the same: unless you're purposefully doing something
> weird, there's a configuration e
Tim Johnson wrote:
The file pattern is *not* as I expressed it above.
Yeah, I figured that out, and ignored the error in my reply.
The answer remains the same: unless you're purposefully doing something
weird, there's a configuration error in that MySQL build. It's not that
the configurati
Hi,I have a mail system on FreeBSD 6.2 + Exim 4.62 + MySQL 5.0. Exim was
compiled with MySQL support, the MySQL database is external to the mail server.
Although the system works, I have a lot of daily messages in exim's log with
the following error: MYSQL connection failed: Can not connect to M
On Tuesday 30 October 2007, Warren Young wrote:
> Tim Johnson wrote:
> > Can't find file: './mysql/(database_name).frm' for numerous databases.
>
> That's the file the actual table data is stored in. Unless you're on a
> shared machine and are trying to run a private copy of MySQL, you
> probably
Tim Johnson wrote:
Can't find file: './mysql/(database_name).frm' for numerous databases.
That's the file the actual table data is stored in. Unless you're on a
shared machine and are trying to run a private copy of MySQL, you
probably don't mean to put store table data in a subdirectory of
using Distrib 5.0.45 on ubuntu 7.04, mysql was installed via adept manager.
I'm getting many error messages on the type:
Can't find file: './mysql/(database_name).frm' for numerous databases.
The mysql database was installed automatically during installation, and
I'm getting them for ./mysql/time
Hello all,
Using PHP+MySQL, I've noted that:
If I use 'localhost', I'm using socket to do the connection. If the
socket was wrong, the connections was failed.
If I use '127.0.0.1', I'm not using socket and I'll be connected if I
have permission.
Now the question: Which one have better performan
Chris,
What I want to do is find all the groups where the inserts all
happened with in say 10 seconds. So my group by would be more like..
Perhaps the easiest solution is to make a temp table of datetime ranges
from the resultset, then join from and group by those rowIDs.
PB
-
Chr
VIOLA!
As it turns out, the cnf file that I was shown was the cnf file on the OLD
server that we used when we had DB/Webserver combined on one server - that
conf was not updated for the new separate DB server.
Thanks muchly all, that change made the search work as expected!!!
Thanks for the star
Mike,
Mike Morton wrote:
OK - I am at a total loss here :)
We have added an addition fulltext field with the highest rating:
match(search_keywords) against ('vic*' IN BOOLEAN MODE) * 16
And verified that in that field, there is indeed a keyword "vic" - but still
- that result is not returned,
Hi,
Chris W wrote:
I have the following query...
SELECT CreateDate, count( * )
FROM `userprofile`
GROUP BY CreateDate
It isn't exactly what I want. Records are added to this table in 2 main
ways. First people use the web site interface to create records. In
this case, records are only added
OK - I am at a total loss here :)
We have added an addition fulltext field with the highest rating:
match(search_keywords) against ('vic*' IN BOOLEAN MODE) * 16
And verified that in that field, there is indeed a keyword "vic" - but still
- that result is not returned, SO...
That leads me to beli
I have the following query...
SELECT CreateDate, count( * )
FROM `userprofile`
GROUP BY CreateDate
It isn't exactly what I want. Records are added to this table in 2 main
ways. First people use the web site interface to create records. In
this case, records are only added by one or 2 people a
I knew I’ve seen this error before ☺
Thanks a lot.
-andrey
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 30, 2007 1:55 AM
To: Andrey Dmitriev
Cc: mysql@lists.mysql.com
Subject: Re: query question
>Thanks.. It doesn't seem to work
> > Neil Tompkins wrote:
> > > I have a table of records all of which have a timestamp against them
> > like 2007-10-25 10:10:19, and category like red, blue etc and a unique key.
> > >
> > > Using a SELECT statement is it possible to retrieve the count and number
> > of records for each day e.g 20
Hi all,
When i try to backup the database through ibbackup i am getting the following
error :-
Details are here.
-
InnoDB Backup Utility v1.3.0; Copyright 2003-2005 Innobase Oy
This software is published
Hello,
I'm programming with PHP+Mysql a CMS system to easily update my site.
I want to have a list of titles to which I can add new ones either at
the end of the list or in a chosen position so I can choose what order
they show up in.
The first solution that I thought of was to add one to all
PaPa,
It comes from external source together with Relevance value (float),
Then you need to ORDER BY that func.
PB
-
Papalagi Pakeha wrote:
Hi,
It comes from external source together with Relevance value (float),
where the first ID has highest relevance and subsequent IDs are in
decre
Thanks a lot for this explanation,
yeah we are doing many massive update and insert in our databases.
--
Thomas Raso
2007/10/30, Augusto Bott <[EMAIL PROTECTED]>:
>
> One possible explanation (possibly not the only one): if you do a
> massive update on the master, that transaction would need to
Sorry, no. I hope someone else will be able to help.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com
> -Original Message-
> Fr
One possible explanation (possibly not the only one): if you do a
massive update on the master, that transaction would need to create
many blocks of versioned data. If you roll that transaction back,
those blocks will be freed to be reused, but the datafiles won't
shrink.
Since that transaction wa
Jerry:
Sorry - I should have mentioned in my previous email that we have changed
that min. word length to 2 in the config already, as we have MANY 3 letter
searches... ;)
Any other suggestions?
On 10/30/07 9:12 AM, "Jerry Schwartz" <[EMAIL PROTECTED]> wrote:
> By default, MySQL ignores any "wo
By default, MySQL ignores any "word" with less than four characters when
doing full text searches. You can change this in my.conf, the setting should
be obvious.
I had to do this so that customers could find inventory items that were red.
Regards,
Jerry Schwartz
The Infoshop by Global Informatio
On 10/30/07, Johan Höök <[EMAIL PROTECTED]> wrote:
> Hi,
> what you probably want is
> SELECT id, start_date FROM iddt WHERE id IN
> ('109k7','s3x6','sxmns','wt57')
> ORDER BY FIELD(id,'109k7','s3x6','sxmns','wt57')
That's exactly it! Thanks a lot :-)
Just for the record, here's the FIELD() funct
Hi all,
on a replication architecture, with the same server, the same Mysql version
(4.1.21) and the same configuration, the same database.
I have a difference between two ibdata file size
innodb_data_file_path=ibdata1:2000M;ibdata2:2000M;ibdata3:2000M;ibdata4:2000M;ibdata5:2000M;ibdata6:2000M;i
Hi,
as some of you may have noticed we've been running educational sessions
on MySQL internals for quite a while. That program is called "MySQL
University"; see http://forge.mysql.com/wiki/MySQL_University.
Tomorrow Sergey Petrunia will give a MySQL University session on:
How MySQL Handles OR
Hi,
what you probably want is
SELECT id, start_date FROM iddt WHERE id IN
('109k7','s3x6','sxmns','wt57')
ORDER BY FIELD(id,'109k7','s3x6','sxmns','wt57')
/Johan
Papalagi Pakeha skrev:
On 10/30/07, Sebastian Mendel <[EMAIL PROTECTED]> wrote:
Papalagi Pakeha schrieb:
Hello,
I have a query lik
On 10/30/07, Sebastian Mendel <[EMAIL PROTECTED]> wrote:
> Papalagi Pakeha schrieb:
> > Hello,
> >
> > I have a query like:
> > SELECT id, start_date FROM iddt WHERE id IN ('109k7','s3x6','sxmns','wt57');
> > which gives me:
> > +---+-+
> > | id| start_date |
>
Papalagi Pakeha schrieb:
> Hello,
>
> I have a query like:
> SELECT id, start_date FROM iddt WHERE id IN ('109k7','s3x6','sxmns','wt57');
> which gives me:
> +---+-+
> | id| start_date |
> +---+-+
> | 109k7 | 2007-10-07 12:06:58 |
> | sx
Hi,
It comes from external source together with Relevance value (float),
where the first ID has highest relevance and subsequent IDs are in
decreasing order.
For example:
109k7 1.79
s3x6 1.34
sxmns 1.21
wt57 0.93
I could use these numbers in the query as well if it helps.
PaPa
On 10
38 matches
Mail list logo
