Prasanna Raj <[EMAIL PROTECTED]> wrote:
Can you through us more lights on error ? where does this occur ?
**ERROR:
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and
Hi
Can you through us more lights on error ? where does this occur ?
-bash-2.05b$ perror 10 30
OS error code 10: No child processes
OS error code 30: Read-only file system
-bash-2.05b$
-Praj
On Wed, 5 Apr 2006 08:48:08 +0700
"Truong Tan Son" <[EMAIL PROTECTED]> wrote:
> [S] Dhandapani wrot
Ed,e:
Thanks for the quick reply Peter. Unfortunately, this is all legacy stuff that I have to make work together and the problemreport table does not reference the employeeid in the employees table. It was all create about ten years ago and the data has just always been migrated to the db d
Hi, experts
How can I make mysql database users password with expire date?
Does mysql can do it?
--
NiCK
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[S] Dhandapani wrote:
mysql> show global variables like '%innodb%';
+-++
| Variable_name | Value |
+-++
| have_innodb | YES
O
On 04.04.2006 23:17 (+0100), Eric Braswell wrote:
> my.cnf:
>
> bind-address =
>
> Will probably do the trick.
Thank you, that's what I was looking for.
--
Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]>
"Does the movement of the trees make the wind blow?"
http://newsboard.unclassified.de - Un
Thanks for the quick reply Peter. Unfortunately, this is all legacy stuff that
I have to make work together and the problemreport table does not reference the
employeeid in the employees table. It was all create about ten years ago and
the data has just always been migrated to the db du jour. I'
> The only way to link tables in MySQL (to use the term from Access) is to
> use the Federated database engine. A Federated table physically exists on
> one server but virtually exists on another. This is exactly like creating
> a linked table.
>
> However, AFAIK, the Federated database engine only
Ed,
>Can someone help me simplify this query please? It's meant
>to return a single string result that looks something like this,
>"You have 12 open Problem Reports: Priorities(High=5, Med=6, Low=1)"
The big slowdown in your query is likely the join on
ProblemReports.Responsible = CONCAT
Sorry, here's the results. BTW the query works it just seems overly complex and
I'd like to streamline it.
CREATE TABLE `employees` (
`EmployeeID` int(11) NOT NULL auto_increment,
`FirstName` varchar(50) default NULL,
`LastName` varchar(50) default NULL,
`DateTerminated` datetime default
my.cnf:
bind-address =
Will probably do the trick.
--
Eric Braswell
Web Manager MySQL AB
Cupertino, USA
Yves Goergen wrote:
Hi,
I have a machine with multiple IP addresses on my network interface and
I have setup multiple MySQL servers on the machine, version 4.0 and 5.0.
Currently, t
Hi,
I have a machine with multiple IP addresses on my network interface and
I have setup multiple MySQL servers on the machine, version 4.0 and 5.0.
Currently, they're all listening on all IP addresses on different ports
(3306 and 3307) but I'd like to make use of the second IP to make it
easier t
How did you try to do it on the remote system?
I copied and pasted your query to a server running MySQL
4.1.12-standard-log, and another running MySQL 5.0.19-standard-log,
and they both created the table just fine.
Have you tried copying and pasting the table creation itself to see if
that works?
"Ed Reed" <[EMAIL PROTECTED]> wrote on 04/04/2006 04:34:29 PM:
> Can someone help me simplify this query please? It's meant to return
> a single string result that looks something like this,
>
> "You have 12 open Problem Reports: Priorities(High=5, Med=6, Low=1)"
>
> The relavent columns from th
Can someone help me simplify this query please? It's meant to return a single
string result that looks something like this,
"You have 12 open Problem Reports: Priorities(High=5, Med=6, Low=1)"
The relavent columns from the two tables are
Table: ProblemReports
Fields: PRNo, Status, Priority,
Try going to:
"http://www.mysql.com/innodb rollback"
You can search the manual by typing "http://www.mysql.com/search term"
into the address bar of your browser. The first hit looked like a
winner to me.
-Sheeri
On 4/4/06, Truong Tan Son <[EMAIL PROTECTED]> wrote:
> Dear Sir,
>
> I install MyS
"Mike Blezien" <[EMAIL PROTECTED]> wrote on 04/04/2006 02:47:50 PM:
> Hello,
>
> is there a MySQL function to determine the total days of any given
> month, IE if
> current month is April, is there a function or query to find the
> total days of
> the month?
>
> TIA,
> Mike(mickalo)Blezien
>
Mike,
Maybe :
LAST_DAY(date)
Takes a date or datetime value and returns the corresponding value for
the last day of the month. Returns NULL if the argument is invalid.
mysql> SELECT LAST_DAY('2003-02-05');
-> '2003-02-28'
mysql> SELECT LAST_DAY('2004-02-05');
-> '2004-02-29'
m
Hello,
is there a MySQL function to determine the total days of any given month, IE if
current month is April, is there a function or query to find the total days of
the month?
TIA,
Mike(mickalo)Blezien
===
Thunder Rain Internet Publishing
Providing Internet Soluti
"Bing Du" <[EMAIL PROTECTED]> wrote on 04/04/2006 12:20:23 PM:
> Hello everyone,
>
> Please correct me if my understanding is wrong. Does the implementation
> of linked table mentioned on "18.1.11.3. How to Import or Link MySQL
> Database Tables to Access?"
> (http://dev.mysql.com/doc/refman/4.1
Thanks
Yes the hoster fixed it by cleaning the temp files
Jacques Brignon
> -Message d'origine-
> De : Sander Smeenk [mailto:[EMAIL PROTECTED]
> Envoyé : lundi 3 avril 2006 10:32
> À : mysql@lists.mysql.com
> Objet : Re: error 28 from table handler
>
> Quoting Jacques Brignon ([EMAIL PR
I have just noticed this from section 13.4.5. LOCK TABLES
and UNLOCK TABLES Syntax of the 5.0.18 ref manual, and
wondered if it will help improve the speed of your query:
Normally, you do not need to lock tables, because all single
UPDATE statements are atomic; no other thread can interfere
Hello all,
I am looking for a way to view the max values that have been used by all
threads or a signal thread for read_buffer, read_rnd_buffer,
sort_buffer, and net_buffer. I want to know these values so that I can
turn them appropriately.
Regards,
--Dave
David W. Juntgen
Medical Informati
Hello everyone,
Please correct me if my understanding is wrong. Does the implementation
of linked table mentioned on "18.1.11.3. How to Import or Link MySQL
Database Tables to Access?"
(http://dev.mysql.com/doc/refman/4.1/en/import-of-data.html) means that
data is actually stored in MySQL and tab
You need to issue "FLUSH PRIVILEGES" or you must "RELOAD" Mysql for the
changes to come into effect after you have changed your settings
Kishore Jalleda
http://kjalleda.googlepages.com/
On 4/4/06, NanFei Wang <[EMAIL PROTECTED]> wrote:
>
> Hi,
> I want to change the password of the User( w
Only if you run this SQL statement:
*FLUSH PRIVILEGES*
That will make the new password effective.
--
Gabriel PREDA
Senior Web Developer
In the last episode (Apr 04), NanFei Wang said:
> I want to change the password of the User( which is root) in the
> table 'user' from the database 'mysql'.
>
> I use the String sql = "update user set
> Password=password('somePassWord') where User='root'"; I see from
> MySql Query Browser the pass
[snip]
My question is I hope the new password will be effective for connection
immediately
without ' Stop and Start ' the mysql Service.
[/snip]
Instead of stopping and starting the service you should do the following
query;
FLUSH PRIVILEGES;
That will cause new passwords to take effect.
--
My
Hi,
I want to change the password of the User( which is root) in the table 'user'
from the database 'mysql'.
I use the String sql = "update user set Password=password('somePassWord') where
User='root'";
I see from MySql Query Browser the password really changed !
Before I stop the mysql from Se
I don't see anything abnormal in your show processlist, yes you can change
the max_connections global setting from the mysql CLI, but for it to survive
restarts/reboots it has to be defined in the my.cnf file ( I guess its
my.ini for windows) .
Kishore Jalleda
http://kjalleda.googlepages.com/
Thanks for the answers!
When i do a SHOW PROCESSLIST; i get this:
#
mysql> show processlist;
++--++--+-+--+---+--
+
| Id | User | Host | db | Command | Time | State | Info
|
++--++--+-+-
Yasir Assam <[EMAIL PROTECTED]> wrote on 04/03/2006 11:09:01 PM:
> Hello,
>
> I need to be able to sum over distinct values but I can't seem to do it
> unless I use sub-selects (which I want to avoid doing).
>
> To see what I mean, I've constructed a toy DB:
>
> DROP TABLE IF EXISTS spell;
> C
Ariel Sánchez Mora <[EMAIL PROTECTED]> wrote on 04/03/2006 09:07:34 PM:
> This table holds latest data from an app:
>
> mysql> select * from ultimas_respuestas_snmp limit 10;
> +++---
> +-+---++--+
> | id
"H L" <[EMAIL PROTECTED]> wrote on 04/03/2006 01:53:37 PM:
>
> >The solution is to redesign your tables. You need to split into
separate
> >columns the values you want to maintain. You do not want to keep the
"flat
> >file" design you are currently trying to use.
> >
> >CREATE TABLE calendar (
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: root
To: mysql@lists.mysql.com
Subject: [Error while runnign ./scripts/mysql_install_db --user=mysql]
>Description:
Try creating INDEX on id column
I think that will do the trick ;)
--Praj
On Mon, 3 Apr 2006 19:07:34 -0600
Ariel Sánchez Mora <[EMAIL PROTECTED]> wrote:
> This table holds latest data from an app:
>
> mysql> select * from ultimas_respuestas_snmp limit 10;
> +++
Thanks Martijn for you prompt answer!
> Do you have indices on INVOICE_ID?
Yes (KEY `IDX_step1` (`INVOICE_ID`))
> If so, try dropping it and recreating it?
OK, I will do it (I will have to wait until this week-end to do it (=> the
table is a bit big (47 mio records) and I cannot stop the servi
Patrick,
> I'm using MySQL 5.0.18-standard Server on a Linux SuSE 10 Server and I've
> got following problem:
>
> I have a table with the followign structure
>
>
+-+--+--+-+---+-
> ---+
> | Field | Type | Nul
Try:
INSERT *IGNORE* INTO table (a,b) VALUES (1,2)
--
Gabriel PREDA
Senior Web Developer
If you do an INSERT and you generate an new number in an AUTO_INCREMENT
field the new value generated can be retrieved using:
*SELECT LAST_INSERT_ID();*
You are not required to retrieve into the application and then use it back
in another SQL statement... you can use user variables:
*SELECT @lastG
Hello!
I'm using MySQL 5.0.18-standard Server on a Linux SuSE 10 Server and I've
got following problem:
I have a table with the followign structure
+-+--+--+-+---+-
---+
| Field | Type | Null | Key | Defa
I want an On Duplicate Key do nothing feature which obviously doesn't
exist. However, will this be any faster than actually updating the row.
INSERT INTO table (a,b) VALUES (1,2)
ON DUPLICATE KEY UPDATE b=b;
BTW each row is made up of only 2 columns and those to columns make up
the key so i
Hi,
How can I get the current value of AUTO_INCREMENT field, as the
AUTO_INCREMENT field is a foreign key in some other table.please do mail
it to my mailed, its very urgent!
Thanks,
bhanu
"The pessimist may be right in the long run, but the optimist has a
better time during the trip."
Because you have no indexes on that table... MySQL will open and search
within the entire table.
If you would have had an index MySQL would know how to go directly to the
row you want to update.
You are always looking for rows with:
WHERE id ="?"
So there you have... you mus
Dear Sir,
I install MySQL 5.0.18 on RH EL4, but do not know how to use InnoDB for
"ROLLBACK".
./configure --prefix=/usr/local/mysql \
--exec-prefix=/usr/local/mysql \
--with-innodb
make && make install
**/etc/my.cnf:
# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir
45 matches
Mail list logo
