Query on Full-text search

Hi, Can anybody give me the optimized query for full-text searching? User will be entering one or more words in a text box and I wanted to display the records which has atleast one word of the user input. Assume that my table has two fields USER and DESCRIPTION. I wanted to search the

Re: Query on Full-text search

Rakki wrote: Hi, Can anybody give me the optimized query for full-text searching? User will be entering one or more words in a text box and I wanted to display the records which has atleast one word of the user input. Assume that my table has two fields USER and DESCRIPTION. I wanted

ADDING MYSQL DATABASE

Greetings, I'm a new user for MYSQL and I face problem adding mysql database. After typing: SHOW DATABASES; I got this: +--+ | Database | +--+ | test | +--+ 1 row in set (0.02 sec) which does not contain mysql and tmp as shown: +--+ | Database | +--+

Re: ADDING MYSQL DATABASE

tai huijia wrote: SHOW DATABASES; I got this: +--+ | Database | +--+ | test | +--+ 1 row in set (0.02 sec) which does not contain mysql and tmp as shown: You need to log in (to MySQL) as root if you want to see the mysql database. It contains sensitive information

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

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

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

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

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

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 logs are

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:

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

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

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 -u

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.

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

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 =

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

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

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 content

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: 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 http://dev.mysql.com/doc/mysql/en/innodb-foreign-key-constraints.html. Michael Michael Stassen wrote: There are a few possibilities here: 1. Both tables must be InnoDb.