ALTER TABLE TimeTracker.TT_ProjectMembers ADD
CONSTRAINT FK_Roles_Projects FOREIGN KEY
(
ProjectID
) REFERENCES TimeTracker.TT_Projects (
ProjectID
) ON DELETE CASCADE ,
CONSTRAINT FK_WorksOn_Users FOREIGN KEY
ALTER TABLE TimeTracker.TT_ProjectMembers ADD
CONSTRAINT FK_Roles_Projects FOREIGN KEY
(
ProjectID
) REFERENCES TimeTracker.TT_Projects (
ProjectID
) ON DELETE CASCADE ,
CONSTRAINT FK_WorksOn_Users FOREIGN KEY
(
Hello,
Not sure if this is known or not but I just wanted to let you guys
know that MySQL 5.1.21 fails the make. I've never had this problem on
other versions of mysql. It looks like GNU make worked all the way
through but why won't regular make work anymore?
- Jake
--
MySQL General Mailing Lis
Hi Folks,
I am new to MySQL. We have a development environment where we have
three systems
1) Developement Database on Machine A
2) Test Databasae on Machine B
3) Live Database on Machine C
So we make changes to the Developement Database, then move them to test
then to live. My question is
Amarnath Shivashankar a écrit :
We have found that the MYSQL on all Email DB servers starts throwing "Out of
memory; check if mysqld or some other process uses all available memory;"
error. The error goes once we restart MySQL. But after a week again the same
problem occurs. We have 4 GB of physi
If you have not already recorded the data, you could play with
auto-increment-increment and auto-increment-offset...
If you already have the data, you could do a select.. insert, creating
new primary keys, and have a new column in the result table to hold
the old pk. One update on the table that
OK, scratch that, I was being stupid. I had two ODBC configuration dialogs
open and they must have been conflicting.
Another question though, during the ODBC config, I noticed I could pick
either the caddb for which the account had access or "information_schema"
for which I had not explicitly
I have a set up where data will be collected on several local machines, and
then needs to be merged into a single database on a data storage server. I
have two tables that have auto_incrementing ids that I don't want to clash
when merging, and another table that uses one of these autoincrementin
I want to add a user who can login from anywhere but has restricted
privileges on a single DB.
I tried:
GRANT SELECT, INSERT, UPDATE ONcaddb.* TO 'autocad'@'%' IDENTIFIED BY
'password';
The query ran and the user was entered with the proper privileges, however,
when I tried to setup an ODBC
Thanks everyone for the replies. The problem revolved around '%' vs
'localhost'. To me, it seems logical that '%' would include localhost..not
really true. So, I have it figured out.
thanks,
Keith
- Original Message -
From: "B. Keith Murphy" <[EMAIL PROTECTED]>
To: "mysql"
Sent:
Keith,
Is it possible you have a second entry for [EMAIL PROTECTED] which
doesn't require a password?
- michael dykman
On 9/26/07, B. Keith Murphy <[EMAIL PROTECTED]> wrote:
> Everyone,
>
> So I have never seen this before. I set up a database yesterday. I added a
> user today in the normal m
We have found that the MYSQL on all Email DB servers starts throwing "Out of
memory; check if mysqld or some other process uses all available memory;"
error. The error goes once we restart MySQL. But after a week again the same
problem occurs. We have 4 GB of physical memory on the server but Mysql
> On Wed, 2007-09-26 at 10:55 -0400, Jerry Schwartz wrote:
>
> > I don't know Linux that well, but I know that HP-UX lets you do most
> > anything to an open file, including deleting it. The file will continue
to
> > exist as long as it is open by at least one process. If I remember
> > correctl
Hi all,
I've a server where between 1-2 there comes a high load from less than
1k queries there's a jump to 60+k queries. It all started after adding
more RAM to the server.
Anyone seen this before ?
Regards,
Toke Herkild
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/m
14 matches
Mail list logo
