Thank you very much for all answers
I will trying Triggers and the example with the update after an INSERT.
Ant then, I use the best for me;-)
Thunder
Yes, Triggers... I so rarely use them I forget they exist.
On Tue, May 5, 2009 at 10:22 AM, Thomas Pundt mli...@rp-online.de wrote:
Hi All, I've performed a upgrade from 4.1.22 to 5.0.81, the
mysql_upgrade performed well on all tables repairing, however, after
upgrade the same db from 5.0.81 to 5.1.33, a few tables got the error as
below:
Error: Unknown table engine 'InnoDB'
error: Corrupt
Any ideas?
THnaks.
--
kengheng wrote:
Hi All, I've performed a upgrade from 4.1.22 to 5.0.81, the
mysql_upgrade performed well on all tables repairing, however, after
upgrade the same db from 5.0.81 to 5.1.33, a few tables got the error
as below:
Error: Unknown table engine 'InnoDB'
error: Corrupt
Any
A DB politics between mysql oracle again
Thats quite ironic given recent events :)
--
Linux web infrastructure consulting, cr...@codenation.net
Free live poker tournament listings, http://www.g5poker.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Hi All,
We're setting up a group of servers using MySQL Enterprise 5.1 - Rather
than starting with a blank canvas I wondered if there was a suitable
my.cnf that is tuned to the kind of environment I'm running where I can
tweak it from there.
We're running on RHEL, on Sunfire X4140's - 8
Craig Dunn wrote:
Hi All,
We're setting up a group of servers using MySQL Enterprise 5.1 - Rather
than starting with a blank canvas I wondered if there was a suitable
my.cnf that is tuned to the kind of environment I'm running where I can
tweak it from there.
We're running on RHEL, on
There's no such thing as a generic my.cnf for high performance MySQL
servers, you will need to provide more information..
Some questions: Are you going to run InnoDB or MyISAM or both (if both,
what's the split?)
Is there anything else running on that server? i.e. how much of the
16GB is
Andrew Braithwaite wrote:
There's no such thing as a generic my.cnf for high performance MySQL
servers, you will need to provide more information..
Well, I was more after something a bit more up to date than my-huge.cnf
that I could use as a starting point, I see a few example ones posted to
I'm clearly doing something wrong. All I want is to grant a user rights
to create databases:
grant create on *.* to 'user'@'localhost' identified by 'pass';
doesn't do the trick, nor does
grant super on *.* to 'user'@'localhost' identified by 'pass';
The user in question was originally
Your disk config is good and you'll need all the nessesary my.cnf
entries to point all the logs and data to the correct place. Slaves
should have the relay-logs going to the OS disk too. I assume you've
set up the master slave config in the my.cnf too.
Here's my brain dump on what you need:
Andrew Braithwaite wrote:
Your disk config is good and you'll need all the nessesary my.cnf
entries to point all the logs and data to the correct place. Slaves
should have the relay-logs going to the OS disk too. I assume you've
set up the master slave config in the my.cnf too.
Yeah the
At 07:56 AM 5/6/2009, you wrote:
Hi All,
We're setting up a group of servers using MySQL Enterprise 5.1 - Rather
than starting with a blank canvas I wondered if there was a suitable
my.cnf that is tuned to the kind of environment I'm running where I can
tweak it from there.
We're
Any ideas about this? It's very aggravating and I have no idea how to debug
this any further. Thanks.
Hi.
I am having a problem with a program I am writing. The program reads a
file, checks an object file, and if the record doesn't exist, it inserts to
a node table (one table per node) and
You have 2 queries that are probably blocking everything. They are in
the update state.
| 30 | root | localhost | bsm | Query | 138 | update | insert into
upbcgww03
values(/var/tmp/zypp.067D9R/zypp-trusted-kr9rzhrO,trustdb.gpg,1200,b18a1a
| 30 | root | localhost | bsm | Query | 138 |
I recently upgraded an asterisk/trixbox server to mysql 5.1.34 from
5.64. Access to the db seesm fine from the shell, phpmyadmin or even the
Trixbox/FreePBX tool, but trying to apply Trixbox changes, or running a
pear update produces the errors below. I created a couple of sl but
this did not
Typo, moved from 5.0.67 to 5.1.34
Johnny Stork wrote:
I recently upgraded an asterisk/trixbox server to mysql 5.1.34 from
5.64. Access to the db seesm fine from the shell, phpmyadmin or even
the Trixbox/FreePBX tool, but trying to apply Trixbox changes, or
running a pear update produces the
Johnny,
Welcome to the hell that is php + apache + mysql. If you upgrade your MySql
(especially major versions 5.0 = 5.1) you will also need to recompile php
against the new MySql client libs. We've had very limited success trying to
get it to work otherwise.
This is why you are receiving
I set up mysql and can't start it because I need to hard code the IP address
parameter (bind-address) into my.cnf ... but I have three of them in different
sub directories of /mysql/mysql-test/suite
Should there not be one basic one?
mysql -u root -ppassword
mysql create user 'user'@'localhost' identified by 'password' ;
mysql grant create on *.* to 'user'@'localhost';
mysql flush privileges;
mysql quit
mysql -u user -ppassword
mysql create database testdb1;
mysqlcreate database testdb2;
Regards
Sudhir Menon
John,
Are you loggin in as:
mysql -u 'user' -p
If not, you should (from the local host obviously).
The other thing to check is once you are logged in, run the following command:
mysql show grants;
This will tell you what the grants are for the user that is logged in
(and whether or not you are
20 matches
Mail list logo