Re: need help with foreign keys, new to mysql

Sorry to reply to my own message, but I meant to add that you can read about defining foreign key constrints in the manual . Michael Michael Stassen wrote: There are a few possibilities here: 1. Both tables must be InnoDb

Re: need help with foreign keys, new to mysql

John Gonzales wrote: i am creating my own little blog and i am trying to create a comments table that uses the primary key of my blog table as a foreign key. i've tried the only two ways that i know how and both ways yielded the same error: #1005 - Can't create table '.\mydatabase\comments.frm'

Re: BLOB in mysql ----- performance issue.

2005/8/20, Kane Wilson <[EMAIL PROTECTED]>: > hi Friends, > > I have a WAP portal which is running based on mysql database. That's meant > that contents has been stored in the data base. > wallpapers , themes, ringtones, games ...etc data type as BLOB. upto now > now problems with the conten

Re: Flushing logs on replication setup

Terry Riley wrote: - Original Message - Terry Riley wrote: I'm running 4.1.13 on Linux as master, with 4.1.12 on XP as slave (in house test setup). This vaguely duplicates what is set up on the live servers, except that the slave is 4.1.3 on NT4. On the test setup, if the logs a

Re: Problem with autoincrement management

Thurgood Alex wrote: Hi everyone, I'm having a conceptual problem with managing autoincrements and I was hoping that the list could point me in the right direction ;-) I've migrated a FMPro database which turned out to be a nightmare for various reasons, including the use of multivalue fields i

Trigger Lock table

System Linux SUSE 9.1 with mysql-max-5.0.11-beta-linux-i686.tar.gz Trigger: create trigger CustomerHistoryUPD BEFORE Update on Customer For each ROW BEGIN insert into CustomerHist select * from Customer where FD_ID = OLD.FD_ID; Update CustomerHist set HistDate = NOW() where FD_ID = OLD.FD_I

Re: Is there an easy way to copy a table between two mysql servers?

Try: mysqldump -h yourhost.com -u username -ppasswd mydatabase mytable | mysql -h yournewhost.som -u newuser -ppasswd newdatabase Santino Cusimano At 17:19 +0200 20-08-2005, John thegimper wrote: Thanks, but that copies the whole database right? Can i specify only one table? Quoting Pooly <[

RE: need help with foreign keys, new to mysql

Hey Alex, Although I am not too sure what *.idb files are, I looked in the directory that I designated to store the InnoDB files and found the directory empty. Could this be it? I don't recall though ever deleting files from that directory. How did you go about fixing this problem? -jg. -Ori

Re: Is there an easy way to copy a table between two mysql servers?

Thanks, but that copies the whole database right? Can i specify only one table? Quoting Pooly <[EMAIL PROTECTED]>: > If you have a mysqlclient an an access to the command line, you can > directly pipe it ! > > mysqldump -h yourhost.com -u username -ppasswd mydatabase | mysql -h > yournewhost.som

Re: Is there an easy way to copy a table between two mysql servers?

If you have a mysqlclient an an access to the command line, you can directly pipe it ! mysqldump -h yourhost.com -u username -ppasswd mydatabase | mysql -h yournewhost.som -u newuser -ppasswd newdatabase that's it ! otherwise, yes dump/export. 2005/8/20, John thegimper <[EMAIL PROTECTED]>: > Is

Is there an easy way to copy a table between two mysql servers?

Is there an easy way to copy a table between two mysql servers? Or do i need to export and then import? I´m using php btw. Thanks, Johhn - FREE E-MAIL IN 1 MINUTE! - [EMAIL PROTECTED] - http://www.pc.nu -- MySQL General Mailing List For list arc

Re: ADDING MYSQL DATABASE

--- Jasper Bryant-Greene <[EMAIL PROTECTED]> wrote: > tai huijia wrote: > > You need to log in (to MySQL) as root if you want to > see the mysql > database. It contains sensitive information which > will only appear to root. > check your my.cnf or ini file and check for this parameter: s

Re: Flushing logs on replication setup

- Original Message - > Terry Riley wrote: > > I'm running 4.1.13 on Linux as master, with 4.1.12 on XP as slave (in > > house test setup). > > > > This vaguely duplicates what is set up on the live servers, except > > that the slave is 4.1.3 on NT4. > > > > On the test setup, if the l

Re: need help with foreign keys, new to mysql

Le vendredi 19 août 2005 à 21:09 -0500, John Gonzales a écrit : Hi John, > #1005 - Can't create table '.\mydatabase\comments.frm' (errno: 150) > I've seen this error before. > now before i go and do something stupid, i thought i might ask for some help > on this issue :D both my blog and comm

Problem with autoincrement management

Hi everyone, I'm having a conceptual problem with managing autoincrements and I was hoping that the list could point me in the right direction ;-) I've migrated a FMPro database which turned out to be a nightmare for various reasons, including the use of multivalue fields in FMPro that didn't exp

RE: need help with foreign keys, new to mysql

honestly... i don't even know. =( i'm new to mysql... how would i check? -jg -Original Message- From: Jasper Bryant-Greene [mailto:[EMAIL PROTECTED] Sent: August 20, 2005 2:18 AM To: mysql@lists.mysql.com Subject: Re: need help with foreign keys, new to mysql Yes but is the MySQL daemon

Re: need help with foreign keys, new to mysql

Yes but is the MySQL daemon running as root? I hope it isn't... Jasper John Gonzales wrote: i am logged in as root -JG. -Original Message- From: Kishore Jalleda [mailto:[EMAIL PROTECTED] Sent: August 19, 2005 10:35 PM To: John Gonzales Cc: mysql@lists.mysql.com Subject: Re: need hel

RE: need help with foreign keys, new to mysql

i am logged in as root -JG. -Original Message- From: Kishore Jalleda [mailto:[EMAIL PROTECTED] Sent: August 19, 2005 10:35 PM To: John Gonzales Cc: mysql@lists.mysql.com Subject: Re: need help with foreign keys, new to mysql check the permissions on the mysql data dir, may be the user m