Thank you,
raymond
-Original Message-
From: Dan Buettner [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 13, 2006 18:07
To: Jacob, Raymond A Jr
Cc: mysql@lists.mysql.com
Subject: Re: I ran of disk space running optimize on table Now I can
not open "data.MYI"
Hmmm. Doesn't look prett
Asif Lodhi wrote:
> Hi All,
>
> I want to restrict all direct access to tables and allow users access
> only through the stored procedures.
>
> However, I haven't seen any explicit mention in the docs that one can
> return a resultset/recordset from a stored routine - that's what I can
> do using
On Jul 13, 2006, at 3:03 PM, mos wrote:
At 03:45 PM 7/12/2006, Jon Frisby wrote:
This REALLY should be an academic concern. Either you have a system
that can tolerate the failure of a drive, or you do not. The
frequency of failure rates is pretty much irrelevant: You can train
incredibly no
Hmmm. Doesn't look pretty, Raymond! You've got 4.6GB of data and
just 1K of indexes now.
Step ZERO - make a backup copy of the files you have NOW, in case any
repair operations you try make things worse.
On the bright side, your data file (.MYD) should sitll be intact -
it's just the index fil
At 03:45 PM 7/12/2006, Jon Frisby wrote:
This REALLY should be an academic concern. Either you have a system
that can tolerate the failure of a drive, or you do not. The
frequency of failure rates is pretty much irrelevant: You can train
incredibly non-technical (inexpensive) people to respond
Now, I when I do a desc on data table, I get the error
ERROR 1016 (HY000): Can't open file: 'data.MYI' (errorno: 144).
As I recall I ran:
optimize data;
The Optimize command did not complete the error as I recall was /var
filesystem full.
Running the following commands:
ls data.*
data.MYD
> Hi Scott,
>
> One would think that you should be able to accomplish what you are
> looking for by changing rows in table -> "tables_priv" in mysql
> database. And using "flush privileges" when you done.
So does this mean my database privs of select, insert, update, and delete
supercede any tabl
Hi Scott,
One would think that you should be able to accomplish what you are
looking for by changing rows in table -> "tables_priv" in mysql
database. And using "flush privileges" when you done.
mysql> describe tables_priv;
+-+-
Sorry to push this back out to the list, I am stumped, and the docs are not
leading me to an answer.
One users reply was close, and I had tried it, but it generates an error,
which is also posted in this thread. Thanks everyone, original message
follows:
MySQL - 4.0.18-standard-log
How do you r
Martin Jespersen wrote:
Dan has a very good point, be mindfull of the changed password
algorithm, that actually was a bit of a bother to me since i have tons
of users defined in my grant tables.
Dan Buettner wrote:
Dan, I wouldn't bother with the intermediate steps (4.0, 4.1) . Waste
of tim
Dan has a very good point, be mindfull of the changed password
algorithm, that actually was a bit of a bother to me since i have tons
of users defined in my grant tables.
Dan Buettner wrote:
Dan, I wouldn't bother with the intermediate steps (4.0, 4.1) . Waste
of time (fine products, but you
I have some strange entries in my slow logs whose timestamps corrolate to an
event we are investigating:
Query_time in the 2-4 range
Lock_time: 0 for ALL entries
Rows_sent in the single to low double-digits
Rows_examined in the low to mid hundreds
the question is whether these are cause or effec
Dan, I wouldn't bother with the intermediate steps (4.0, 4.1) . Waste
of time (fine products, but you say you want to go to 5.0). I'd go
direct to 5.0, using mysqldump'd data as Martin did. If you're
all-MyISAM then it might also work to simply upgrade your binaries and
keep your data files, th
We're using Opterons, Linux 2.6.x, and a SiL (Silicon Image) SATA
chipset whose particular model number I don't have in front of me.
After MUCH MUCH MUCH trial and error we've discovered that:
1) 2.6.16 substantially alleviates the problem but doesn't eliminate it.
2) There is a 3Ware card that
Hopefully you're not still having this problem. I don't use
phpMyAdmin, but I know that it allows you to run "repair table" to try
to fix a table after a crash. Does that work?
-Sheeri
On 6/25/06, Khaled Jouda <[EMAIL PROTECTED]> wrote:
Hello,
I am having a problem with one of my MySQL databa
create view v_authornames as
select authorid, CONCAT(lastname,',',firstname)
from t_authors;
Or replace the middle term in the CONCAT function to whatever you want
to separate it -- ie, ' ' for a space, or just
CONCAT(lastname,firstname) to get output "KritzerSheeri".
-Sheeri
On 6
I keep getting the error:
ERROR 1147: There is no such grant defined for user 'username' on host
'host.example.com' on table 'orders_npfs'
> Sean,
> As http://dev.mysql.com/doc/refman/5.0/en/revoke.html states,
> REVOKE ALL ON `database`.`table` FROM 'user'@'hostname';
>
>
>> MySQL - 4.0.18-sta
On 6/22/06, Scott Haneda <[EMAIL PROTECTED]> wrote:
I have two chunks of data to import, one is in this format:
"01001 - AGAWAM, MA","01001",0,0,291,249,0,"42.070206","-72.622739"
Where it is comma sep and partially quoted
The other is in this format
"99502 ANCHORAGE,
AK","256","265","1424","196
As a session variable, it resets when you open a new session.
-Sheeri
On 6/21/06, Tony_10ph <[EMAIL PROTECTED]> wrote:
Hello guys... I have stored procedures and I want when a calling program call
my stored procedure it will return a response that the stored procedure
execute successfuly or re
Sounds like the well-known problem with Debian stable's glibc on x86_64:
http://hashmysql.org/index.php?title=Opteron_HOWTO#pthread_rwlock_wrlock_hang_with_nptl
Jim Winstead
MySQL Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.
Hi,
Having a most odd problem with random crashes, that appear to be some
kind of deadlocking or blocked process/thread occuring within mysqld
(a wild guess, not any type of assertion).
mysql v4.0.24, ~350Mb DB, running in production for months, no
problems under fairly heavy daily use from mult
Better late than never
I believe the reason is because (at least on unix) if you connect to a
database on the same machine (using -h localhost or just omitting the
host) it will use the socket -- and therefore saying "host=localhost"
is like saying "if they come from the unix socket", where a
We recently exported data from Filemaker then imported into mySQL
4.0.22. The data shows up in mySQL queries just fine. But when we
use our PHP based Web App it shows little boxes in the data.
The little box is a Vertical Tab that Filemaker uses. The Ascii is
11 or 0xb or sometimes known
(apologies for the late reply).
1) A warning doesn't stop the rest of the script from running.
Temporary tables go away at the end of the session, and aren't visible
to any other session, so the server not being able to handle those
commands is no big deal.
2) I'm using MySQL 5.0.19-standard-lo
Apologies for a late reply.
1) The query that tries to insert the invalid entry into Table2 fails.
Therefore, if you have 3 separate queries as in the first case, the
last one fails, but the first 2 are successful. In the second case,
they're all in one query, and if one fails, they all fail.
F
I recently upgraded from 3.23.58 -> 4.1.20 without any hickups.
I simply dumped my databases with mysqldump on the 3.23.58 installation
and imported them again from inside the mysql client by using the
"source" command.
Dan Trainor wrote:
Hi -
I know we've rolled this around the list a fe
I'd have to agree with Alec here (over Erik's response).
There's no technical reason, surely, to use 'desc' instead of 'description' -
people always seem afraid of using non-abbreviated fieldnames / function names
/ variable names. Whilst it may add a little more to your typing, it adds so
much
At 12:42 PM 7/13/2006, Anthony wrote:
Hello,
i want to know how i can create a table with the feild name "desc" ?
when i do:
CREATE TABLE bank (
name varchar(50) NOT NULL default '',
desc varchar(50) NOT NULL default '',
)
the desc is badely interpreted...
In a word - DON'T. "DESC" is
Cheers Dan. Exactly what I needed :)
Iain
Dan Trainor wrote:
Iain Conochie wrote:
Afternoon,
Apologies if this has been discussed before, I could not find a
reference of it. So here we go :)
Currently, I have a need to get a mysql 4.0 client to talk to a
mysql 4.1 database. The er
How about desc_ ?
Erik
On Jul 13, 2006, at 8:42 AM, Anthony wrote:
Hello,
i want to know how i can create a table with the feild name "desc" ?
when i do:
CREATE TABLE bank (
name varchar(50) NOT NULL default '',
desc varchar(50) NOT NULL default '',
)
the desc is badely interpreted...
DESC is a reserved word in MySQL: it is short for DESCENDING and is used
to reverse the sort order in SELECTs. You an create a field with that name
by enclosing it in backticks: `desc` whenever you need it. However, this
would be regarded by many as very bad practice. It would be better to
chan
Hello,
i want to know how i can create a table with the feild name "desc" ?
when i do:
CREATE TABLE bank (
name varchar(50) NOT NULL default '',
desc varchar(50) NOT NULL default '',
)
the desc is badely interpreted...
--
MySQL General Mailing List
For list archives: http://lists.mysql.
On 13 Jul 2006 at 8:27, wizard007 wrote:
> I used $query_Recordset1 = "SELECT date_format(Date, "%d/%m/%Y") as Date,
> Course, Time, Horse, Odds1, Odds2, `Result` FROM Results";
Hi,
That's a PHP error because you have a double quotes: "%d/%m/%Y" within double
quotes: $query_Recordset1 = "SELEC
Hi,
Just tried the date format script posted but it returns the following error:
Parse error: parse error, unexpected '%' in
/homepages/7/d123417448/htdocs/PayGo/results_14days.php on line 33
I used $query_Recordset1 = "SELECT date_format(Date, "%d/%m/%Y") as Date,
Course, Time, Horse, Odds1, Od
Iain Conochie wrote:
Afternoon,
Apologies if this has been discussed before, I could not find a
reference of it. So here we go :)
Currently, I have a need to get a mysql 4.0 client to talk to a mysql
4.1 database. The error message I get is
ERROR 1251: Client does not support authent
Jean-Claude
>I agree that LEFT JOIN is probably part of the solution. But the command you
>suggest do not work, perhaps because several Chimeric_Cluster_IDs and
>Unigene_ID are void or NULL. I want a list of AC from Chimeric_Cluster_IDs
>that are not found in the gene_length table (Unigene_
Afternoon,
Apologies if this has been discussed before, I could not find a
reference of it. So here we go :)
Currently, I have a need to get a mysql 4.0 client to talk to a
mysql 4.1 database. The error message I get is
ERROR 1251: Client does not support authentication protocol reque
I'm using innodb_file_per_table on a version 4.1.12 server on RH linux.
At one point I got error 1114 "The table 'X' is full".
Aren't these tables autoextending?
I don't think I reached a linux file size limit. A call to ulimit shows
the file size is unlimited. The file was a couple of Gig.
Hi -
I know we've rolled this around the list a few times, but I was
wondering if there's been any real development on the subject lately. I
know half of you are saying "Forget it... go with a newer version and
get over it", and I'd really really like to, but i have a lot of data
store under
I put one select on each question.
"wizard007" <[EMAIL PROTECTED]> escreveu na mensagem
news:[EMAIL PROTECTED]
>
> I have just started with MYSQL and am building a racing site using PHP.
>
> I have Date, Course, Time, Horse, Odds, Result as my fields and the
> database
> is poulated with the dat
On Thursday 13 July 2006 14:19, Peter Brawley wrote:
> Jean-Claude
>
> >But how to list all AC in Chimeric_Cluster_IDs _ABSENT_ from the
> > gene_length table, this one for instance :
> >mysql> select Chr_Name, Unigene_ID from gene_length where
> >Unigene_ID='Mm.371574';
> >Any idea ?
>
> That is c
Thanks for your respond.
Here is the CREATE TABLE:
CREATE TABLE `results_1` (
`id` int(11) NOT NULL auto_increment,
`filename` varchar(255) collate cp1251_bulgarian_ci default NULL,
`fileext` varchar(10) collate cp1251_bulgarian_ci default NULL,
`username` varchar(16) collate cp1251_bulg
At 08:54 AM 7/13/2006, abhishek jain wrote:
Dear Friends,
I was to create a site with quite some heavy mySQL database.
I wanted to know which is better longer rows in a table or two short rows
tables.
When compared in terms of speed etc.
Pl. help me , with this question and any other tip you ma
Not sure what your question is, but remember you can use indexes to speed up access to rows. Thus usually the less fields you need
to seach in the better, avoid OR searches across fields.
- Original Message -
From: "abhishek jain" <[EMAIL PROTECTED]>
To:
Sent: Thursday, July 13, 2006
I have just started with MYSQL and am building a racing site using PHP.
I have Date, Course, Time, Horse, Odds, Result as my fields and the database
is poulated with the data.
I'm having problems with the formatting of data when it is output.
Problem 1.
I want to display the date in the format
Jean-Claude
But how to list all AC in Chimeric_Cluster_IDs _ABSENT_ from the gene_length
table, this one for instance :
mysql> select Chr_Name, Unigene_ID from gene_length where
Unigene_ID='Mm.371574';
Any idea ?
That is called an exclusion join. To get at it, you need to adopt
explicit joi
Dear Friends,
I was to create a site with quite some heavy mySQL database.
I wanted to know which is better longer rows in a table or two short rows
tables.
When compared in terms of speed etc.
Pl. help me , with this question and any other tip you may find can be
useful to me.
Thanks,
Abhishek
Hello all
I just suscribed to this list.
I am a scientist working in Strasbourg (France) on problems related to gene
expressions.
I have a first question : I am comparing 2 tables, "gene-length" and
"150genes".
mysql> describe 150genes;
+--+--+--+-+-
Hi,
in order to size the innodb buffer cache optimally it would really be
beneficial to see what it is composed of and how much memory each of the
components (also internal structures!) consumes.
Is there any chance to get this information?
Regards,
Frank.
--
Dr. Frank Ullrich, DBA N
Assuming that the lastest ID is the same as the current name - maybe something
like :
select * from sometab t1
where id=(
select max(id) from sometab t2 where t1.code=t2.code
)
On Thursday 13 July 2006 10:16, Helen M Hudson wrote:
> If I have a table
> primary key id | code
If I have a table
primary key id | code| name
1 | ABC | company 1 name
2 | ABC | company 1 name
3 | ABC | new company 1 name
4 | ABC | new company 1 na
Sean,
As http://dev.mysql.com/doc/refman/5.0/en/revoke.html states,
REVOKE ALL ON `database`.`table` FROM 'user'@'hostname';
> MySQL - 4.0.18-standard-log
How do you revoke all privileges from a user for one table in a database,
and still maintain the existing privileges for the other tables?
F
MySQL - 4.0.18-standard-log
How do you revoke all privileges from a user for one table in a database,
and still maintain the existing privileges for the other tables?
For example, I have these tables:
Email
Logbook
Sales_tax
Sessions
Transactions
Users
Orders_A
Orders_B
Lets say I have two users
53 matches
Mail list logo
