RE: Please help me.

2009-03-19 Thread Muthukumar Selvarasu
; mysql@lists.mysql.com Cc: wi...@lists.mysql.com; mysql-h...@lists.mysql.com Subject: RE: Please help me. Velentin, http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-key-constraints.html Note the section for the droping of foreign keys used the contraint name, not the key name. Try

Please help me.

2009-03-18 Thread Valentin Ionescu
like:   alter table documents_ex drop column Journal_ex_ID or alter table documents_ex drop foreign key  Journal_ex_ID or alter table documents_ex drop  key  Journal_ex_ID    I receive the same error 150 and I don't know what to do.   Please help me.  Best regards. -- MySQL General Mailing

RE: Please help me.

2009-03-18 Thread Gary Smith
the column after that. From: Valentin Ionescu [colibry...@yahoo.com] Sent: Wednesday, March 18, 2009 11:27 AM To: mysql@lists.mysql.com Cc: wi...@lists.mysql.com; mysql-h...@lists.mysql.com Subject: Please help me. Hi! My name is Valentin and I am writing

Re: can some please help me -- REPLICATION

2008-08-11 Thread Moon's Father
'./naxbmisq02-relay-bin.000157' not found (Errcode: 2) mysql -Original Message- From: David Giragosian [mailto:[EMAIL PROTECTED] Sent: Sunday, August 10, 2008 12:54 PM To: mysql@lists.mysql.com Subject: Re: can some please help me -- REPLICATION On 8/10/08, Jim Lyons [EMAIL PROTECTED] wrote

can some please help me -- REPLICATION

2008-08-10 Thread Brown, Charles
The background: We are doing replication. The file-system containing the SLAVE's relay-log got filled to capacity. Later on, I noticed replication has not been working for the last month or more. My Action: I deleted the 2 oldest relay-log then attempted to restart SLAVE. Now, the SLAVE will not

Re: can some please help me -- REPLICATION

2008-08-10 Thread Jim Lyons
you should probably just resync your slave. If it hasn't run for over a month then there's not a lot of point in trying to start it up. Even if you did start the slave (which seems doubtful) you'd have over a month's worth of commands to make up. You can tell mysql to not keep relay logs that

Re: can some please help me -- REPLICATION

2008-08-10 Thread David Giragosian
On 8/10/08, Jim Lyons [EMAIL PROTECTED] wrote: you should probably just resync your slave. If it hasn't run for over a month then there's not a lot of point in trying to start it up. Even if you did start the slave (which seems doubtful) you'd have over a month's worth of commands to make

RE: can some please help me -- REPLICATION

2008-08-10 Thread Brown, Charles
Re: You can tell mysql to not keep relay logs that have already been used. What command does this -Original Message- From: David Giragosian [mailto:[EMAIL PROTECTED] Sent: Sunday, August 10, 2008 12:54 PM To: mysql@lists.mysql.com Subject: Re: can some please help me -- REPLICATION

RE: can some please help me -- REPLICATION

2008-08-10 Thread Brown, Charles
, August 10, 2008 12:54 PM To: mysql@lists.mysql.com Subject: Re: can some please help me -- REPLICATION On 8/10/08, Jim Lyons [EMAIL PROTECTED] wrote: you should probably just resync your slave. If it hasn't run for over a month then there's not a lot of point in trying to start it up. Even

please help me.

2006-06-02 Thread yuan edit
my operating system is linux redhat 9.0. i am installing mysql 5.0.x binary distribution. Which edition is the most fit in the following editions? And would you like to tell me the difference among these editions? Thanks very much! [image: [ ]] mysql-standard-5.0.22-linux-i686-glibc23.tar.gz

Re: please help me.

2006-06-02 Thread Daniel da Veiga
On 6/2/06, yuan edit [EMAIL PROTECTED] wrote: my operating system is linux redhat 9.0. i am installing mysql 5.0.x binary distribution. Which edition is the most fit in the following editions? You notices most of those files are .asc and .md5 used to verify the integrity of the archive after

Re: Please help me: Boolean fulltext searches, AND instead of OR

2005-08-23 Thread Michael Stassen
John thegimper wrote: This is what i need: Posted by gogman on Monday May 5 2003, @10:42am on the mysql website: MySQL defaults to an 'OR'. Example: 'dog cat' = 'dog OR cat'. Most fulltext search engines default to an 'AND'. These include: AltaVista, Fast Search,

Re: Please help me: Boolean fulltext searches, AND instead of OR

2005-08-22 Thread John thegimper
Svensson [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: Please help me: Boolean fulltext searches, AND instead of OR Date: Wed, 23 Mar 2005 22:32:49 +0100 Hi! On Mar 23, Jessica Svensson wrote: Is there any way i can get results with AND instead of OR? Trying to search for black

Re: Please help me: Boolean fulltext searches, AND instead of OR

2005-08-22 Thread John thegimper
!! From: Sergei Golubchik [EMAIL PROTECTED] To: Jessica Svensson [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: Please help me: Boolean fulltext searches, AND instead of OR Date: Wed, 23 Mar 2005 22:32:49 +0100 Hi! On Mar 23, Jessica Svensson wrote: Is there any way i can

Please help me: Boolean fulltext searches, AND instead of OR

2005-03-23 Thread Jessica Svensson
comes from user input. So it can be anything like +cat -dog +big nose -horse white black -red so parsing the input is not what i want, i just want to change the default word separator to AND instead of OR. Now i´m running 4.1.10 and also tried with 4.0.24 Please help me, there must be a way to change

Please help me: Boolean fulltext searches, AND instead of OR

2005-03-23 Thread Jessica Svensson
but thats not what i want since the query comes from a searchbox and i dont want to write som code to manipulate the indata so ite shows correctly i just want to change the default word separator from OR to AND. Maybe it´s ft_boolean_syntax that should be changed? If so to what... please help me

Re: Please help me: Boolean fulltext searches, AND instead of OR

2005-03-23 Thread Brent Baisley
comes from user input. So it can be anything like +cat -dog +big nose -horse white black -red so parsing the input is not what i want, i just want to change the default word separator to AND instead of OR. Now i´m running 4.1.10 and also tried with 4.0.24 Please help me, there must be a way

Re: Please help me: Boolean fulltext searches, AND instead of OR

2005-03-23 Thread Sergei Golubchik
Hi! On Mar 23, Jessica Svensson wrote: Is there any way i can get results with AND instead of OR? Trying to search for black cat should only return records that contains both black and cat. I'm using the following code to get my result: SELECT * FROM `searchtbl` WHERE MATCH (text)

Re: Please help me: Boolean fulltext searches, AND instead of OR

2005-03-23 Thread Jessica Svensson
show results with all words present. This is what i did, set global ft_boolean_syntax = ' +-()~*:|' I really appreciate your help!! From: Sergei Golubchik [EMAIL PROTECTED] To: Jessica Svensson [EMAIL PROTECTED] CC: mysql@lists.mysql.com Subject: Re: Please help me: Boolean fulltext searches

Re: Please help me: Boolean fulltext searches, AND instead of OR

2005-03-23 Thread leegold
= ' +-()~*:|' I really appreciate your help!! From: Sergei Golubchik [EMAIL PROTECTED] To: Jessica Svensson [EMAIL PROTECTED] CC: mysql@lists.mysql.com Subject: Re: Please help me: Boolean fulltext searches, AND instead of OR Date: Wed, 23 Mar 2005 22:32:49 +0100 Hi! On Mar 23, Jessica Svensson

please help me!

2004-10-01 Thread Abdul3140
Hi, I am trying to install MySQL without any joy. I would appreciate if you could help me please. Here I have listed the steps I took it to install. 1. I double click on INSTALL-BINARY in mysql.docs 2. Got the message as Windows cannot open this fiel: File: INSTALL-BINARY To open this

Replication is currupted ...Please help me...

2004-06-09 Thread
Hi all. My company has three Mysql DB servers. one is master, the other are slaves. master's version is 3.23.54-log. two slaves's version is 4.0.17 and Os of all servers is linux 7.3 2 days ago, another slave's replication was currupted unexpactedly, but the other slave was ok. I

RE: Replication is currupted ...Please help me...

2004-06-09 Thread Mechain Marc
May be a full off the filesystem where the relay logbin file is ? Marc. -Message d'origine- De?: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Envoye?: mercredi 9 juin 2004 09:46 A?: [EMAIL PROTECTED] Objet?: Replication is currupted ...Please help me... Hi all. My company has three

Please help me optimize a MySQL server.

2004-05-19 Thread Mohammed Sameer
Hi, I'm running a MySQL server on a duel P III 1G, with 2 GB RAM. MySQL 4.0.18 compiled from source. We have 2 webservers running apache, And this is the backend database server. The server is really slow. a select on a table with 138,247 rows takes about 1.6 - 2+ seconds, I have about 50% CPU

Re: Please help me optimize a MySQL server.

2004-05-19 Thread Egor Egorov
Mohammed Sameer [EMAIL PROTECTED] wrote: I'm running a MySQL server on a duel P III 1G, with 2 GB RAM. MySQL 4.0.18 compiled from source. We have 2 webservers running apache, And this is the backend database server. The server is really slow. a select on a table with 138,247 rows takes about

[uniball@gmx.net: Re: Please help me optimize a MySQL server.]

2004-05-19 Thread Mohammed Sameer
sorry Egor Egorov, Mutt sent the mail to your private inbox ;) resending to the mailing list. On Wed, May 19, 2004 at 02:02:29PM +0300, Egor Egorov wrote: Mohammed Sameer [EMAIL PROTECTED] wrote: I'm running a MySQL server on a duel P III 1G, with 2 GB RAM. MySQL 4.0.18 compiled from source.

Re: Please help me optimize a MySQL server.

2004-05-19 Thread Brent Baisley
Something that small shouldn't really need optimizing. What is the size of your data (mb?, gb?) and what does your query look like? If you are doing a wild card search on a large text field without a full text index, then those times may be the best you're going to get. Many times it's about

Re: Please help me optimize a MySQL server.

2004-05-19 Thread Mohammed Sameer
On Wed, May 19, 2004 at 08:47:28AM -0400, Brent Baisley wrote: Something that small shouldn't really need optimizing. What is the size of your data (mb?, gb?) and what does your query look like? If you are doing a wild card search on a large text field without a full text index, then those

Re: Please help me optimize a MySQL server.

2004-05-19 Thread Brent Baisley
I wouldn't upgrade until you know where the bottleneck is (CPU, disk, network, or RAM). Since you are using professional software, I wouldn't try to change the queries. Have you made changes to your my.cnf file? Since you have enough ram to hold all the data, ram is probably not your

Re: Please help me optimize a MySQL server.

2004-05-19 Thread Mohammed Sameer
On Wed, May 19, 2004 at 11:36:38AM -0400, Brent Baisley wrote: I wouldn't upgrade until you know where the bottleneck is (CPU, disk, network, or RAM). Since you are using professional software, I wouldn't try to change the queries. Have you made changes to your my.cnf file? Since you have

Re: Please help me optimize a MySQL server.

2004-05-19 Thread Scott Haneda
on 05/19/2004 08:36 AM, Brent Baisley at [EMAIL PROTECTED] wrote: I wouldn't upgrade until you know where the bottleneck is (CPU, disk, network, or RAM). Since you are using professional software, I wouldn't try to change the queries. Have you made changes to your my.cnf file? Since you have

RE: Asking again... please help me!!!

2003-12-10 Thread Jan Magnusson
, it's easier especially if you are on Windows. Jan -Original Message- From: Lost Idols [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 18:15 To: [EMAIL PROTECTED] Subject: Asking again... please help me!!! I did ask this before, but haven't got any help yet. I'm trying

Asking again... please help me!!!

2003-12-09 Thread Lost Idols
I did ask this before, but haven't got any help yet. I'm trying this again... so please let me know if you know. Setting up MySQL and PHP on my Mac OS X 10.2 Just made it work... well, at least I now have a databse that I created and a table with two things inserted. I can also see them when I do

RE: Asking again... please help me!!!

2003-12-09 Thread Vasoczki Ferenc
file. It's also, if there is no WEBserver on that machine. So it's not MySql or PHP or Mac problem. Vaso -Original Message- From: Lost Idols [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 5:15 PM To: [EMAIL PROTECTED] Subject: Asking again... please help me!!! I did ask

RE: Asking again... please help me!!!

2003-12-09 Thread Matt Griffin
[mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 11:15 AM To: [EMAIL PROTECTED] Subject: Asking again... please help me!!! I did ask this before, but haven't got any help yet. I'm trying this again... so please let me know if you know. Setting up MySQL and PHP on my Mac OS X 10.2 Just

Re: Someone PLEASE Help Me!!! This should be really easy for you folks!

2003-10-19 Thread john mcdonnell
to add, delete and read a single entry or a whole range of entries from the database? Can someone please help me? I'm desperate! Alternatively, if someone knows of a host that offers that much space and MS Access capatibility for around $10 a month that would certainly work too. Thank you

Someone PLEASE Help Me!!! This should be really easy for you folks!

2003-10-17 Thread Mike Bailey
entry or a whole range of entries from the database? Can someone please help me? I'm desperate! Alternatively, if someone knows of a host that offers that much space and MS Access capatibility for around $10 a month that would certainly work too. Thank you everyone for your help and time

Re: Someone PLEASE Help Me!!! This should be really easy for you folks!

2003-10-17 Thread Dan Jones
On Fri, 2003-10-17 at 20:16, Mike Bailey wrote: I desperately need everyone's help. I normally build database driven websites on NT Servers with an MS Access database, using perl 5 to read/write the database. Now I need to build a website that can handle a database with almost a

Please help me!

2003-06-13 Thread Varghonan
Hi! I am new here and wonder if anyone could help me with a problem in my community. The adress is http://trashankarna.net/community/default.php I can't figure this out. I get this message when I choose to read a message in my outbox/utkorg: Warning: 1 is not a valid MySQL-Link resource in

RE: Please help me!

2003-06-13 Thread Mike Hillyer
, Mike Hillyer www.vbmysql.com -Original Message- From: Varghonan [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 10:36 AM To: [EMAIL PROTECTED] Subject: Please help me! Hi! I am new here and wonder if anyone could help me with a problem in my community. The adress is http

please help me

2003-03-28 Thread Ing.Peter Misovic
i have deleted mysql database, can i restore it with start defaults ? Thanks, Thailon, Slovakia -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

re: please help me

2003-03-28 Thread Egor Egorov
On Friday 28 March 2003 13:59, Ing.Peter Misovic wrote: i have deleted mysql database, can i restore it with start defaults ? mysql_install_db is your solution. :) Thailon, Slovakia -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by

Re: please help me - problem with innodb foreign keys

2003-01-14 Thread Heikki Tuuri
a table scan. Regards, Heikki Innobase Oy sql query - Original Message - From: Natale Babbo [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 14, 2003 5:52 PM Subject: please help me - problem with innodb foreign keys # - PLEASE HELP -- # hi, i've a problem

Please, help me to realize a dream....with mysqlclient library...

2002-12-11 Thread Fabio Varriale (ERI)
Hi, I'm a newer in database programming with C APIs, so the problem arose with the gcc compiler shouldn't surprise you. Now, here the problem. I've installed the Mysql server/client appliaction for win2000. After that, I enjoy the header files (mysql.h) to write a little program in C. The

Please Help me

2002-09-16 Thread Amany younis
Dear sir, when i installed mysql to my unix server. when i run make, i find this error sql_lex.cc:168: `get_hash_symbol' undeclared (first use this function) *** Error code 1 make: Fatal error: Command failed for target `sql_lex.o' Current working directory /usr/local/mysql-3.23.52/sql ***

Please help me with this fulltext query!

2002-08-21 Thread Peter Engström
Hi! I have 2 tables Table 'candidate_index' holds information like firstName,lastName,phoneNumber etc. Example id | firstName | lastName | phoneNumber 1 | Peter | Engström | 3236363 2 | John| Smith | 3773737 ... Table 'candidate_skills' holds the skills a candidate have

please help me

2002-06-23 Thread ÕÅÉƽð
I couldn't ./configure and make mysql.The mistake is: the ./bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! You can start the MySQL daemon with: cd . ; ./bin/mysqld_safe You can test the MySQL daemon with the benchmarks in the 'sql-bench'

please help me

2002-06-23 Thread ÕÅÉƽð
I couldn't ./configure and make mysql.The mistake is: the ./bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! You can start the MySQL daemon with: cd . ; ./bin/mysqld_safe You can test the MySQL daemon with the benchmarks in the 'sql-bench'

Re: please help me understand users privileges

2002-05-30 Thread miguel solorzano
At 23:49 29/5/2002 -0400, Charles Brown wrote: Hi, I removed the user= and password= entries from the my.ini file, because I didn't like seeing a password exposed in plain text. This seemed to have no effect on MySQL at all. What are those entries for? Do I need them? What should they be? The

please help me understand users privileges

2002-05-29 Thread Charles Brown
I'm new to MySQL, and just installed the latest production release on Win 2K. I have a few questions on users and privileges, please help me understand. First, when MySQL starts as a service, what user and password does it use to access the database? I created a MySQL account, should I change

Re: URGENT - ISAMCHK utility - Please help me

2002-05-20 Thread Benjamin Pflugmann
Hello. On Mon, May 20, 2002 at 07:17:55PM +0400, [EMAIL PROTECTED] wrote: Hello: I was trying isamchk on my tables. Found one table with deleted blocks. You know, there would be no reason to repair, except to reclaim the disk space of the deleted rows? Used this option to check:

Please Help Me

2002-04-26 Thread piyush
could not add a record means clearly i could not add FIRST RECORD ANYWAY FORM VISUAL BASIC. what is solution Please help ME. Thanks in Advance - Piyush - Before posting, please check: http://www.mysql.com/manual.php

Re: Please Help Me

2002-04-26 Thread Nick Stuart
an error. and if there is not any record means maximum value from old record is zero then i could not add a record means clearly i could not add FIRST RECORD ANYWAY FORM VISUAL BASIC. what is solution Please help ME. Thanks in Advance - Piyush

Please help me

2002-02-28 Thread Asit Satpathy
I have installed mysql -3.23.39-pc-linux-gnu-i686 on linux , and i want to use foreign key constraints . what configurations i have to made. please give step by step procedure so that i am able to install in my machine and able to work. waiting for your reply. Regards

Please help me

2002-02-28 Thread Victoria Reznichenko
Asit, Thursday, February 28, 2002, 2:55:01 PM, you wrote: AS I have installed mysql -3.23.39-pc-linux-gnu-i686 on linux , and i want AS to use foreign key constraints . AS what configurations i have to made. please give step by step procedure AS so that i am able to install in my machine and

please help me

2002-02-28 Thread Asit Satpathy
I have installed mysql -3.23.39-pc-linux-gnu-i686 on linux , and i want to use foreign key constraints . what configurations i have to made. please give step by step procedure so that i am able to install in my machine and able to work. waiting for your reply. Regards

RE: please help me

2001-11-30 Thread Norman Khine
: anandakkumar araskumar [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 12:37 PM To: [EMAIL PROTECTED] Subject: please help me Hi all Iam new to php and iam learning that from scratch.I came across a problem in connecting mysql from php script.I run php in windows2000 under IIS

please help me

2001-11-29 Thread anandakkumar araskumar
message: Couldn't connect to mysql Anyone please help me as this is very urgent. thanks in advance Regards shahjahan __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps

RE: please help me

2001-11-29 Thread Johnny Withers
. - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985 -Original Message- From: anandakkumar araskumar [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 6:37 AM To: [EMAIL PROTECTED] Subject: please help me Hi all Iam new to php and iam learning that from

Re: please help me

2001-11-29 Thread Neil Zanella
On Thu, 29 Nov 2001, anandakkumar araskumar wrote: Hi all Iam new to php and iam learning that from scratch.I came across a problem in connecting mysql from php script.I run php in windows2000 under IIS configured to personal web server.I have installed mysql with server and client and

Please help me restore my table

2001-11-03 Thread ÂÀ´ºÀû
? What can i do ? it is very important for me to restore them! Please help me out! thank you very much! sincerely lvchunli ÂÀ´ºÀû [EMAIL PROTECTED] 2001-11-04 15:23:44 ¡ñ ¡ñ£© ¡ñ ¡ñ £©£Ü¡ñ£¯£Ü¡ñ

please help me .........cannot find -lmysqlcliente

2001-09-24 Thread katty Iniguez
I use Linux RedHat 7.0 I installed and Configured MySQL-3.23.42 I am installing icradius-0.18.1 installing icradius I got the following: make: /usr/bin/ld: cannot find -lmysqlclient collect2: ld returned 1 exit status make: *** [radius] Error 1 Now, i added the line: /proc/6/fd/mysqlclient

please help me .........cannot find -lmysqlcliente

2001-09-24 Thread katty Iniguez
I use Linux RedHat 7.0 I installed and Configured MySQL-3.23.42 I am installing icradius-0.18.1 installing icradius I got the following: make: /usr/bin/ld: cannot find -lmysqlclient collect2: ld returned 1 exit status make: *** [radius] Error 1 Now, i added the line: /proc/6/fd/mysqlclient

Re: please help me .........cannot find -lmysqlcliente

2001-09-24 Thread Trond Eivind Glomsrød
katty Iniguez [EMAIL PROTECTED] writes: I use Linux RedHat 7.0 I installed and Configured MySQL-3.23.42 I am installing icradius-0.18.1 installing icradius I got the following: make: /usr/bin/ld: cannot find -lmysqlclient collect2: ld returned 1 exit status make: *** [radius]

Re: please help me .........cannot find -lmysqlcliente

2001-09-24 Thread Rodney Broom
From: katty Iniguez [EMAIL PROTECTED] make: /usr/bin/ld: cannot find -lmysqlclient collect2: ld returned 1 exit status make: *** [radius] Error 1 Now, i added the line: /proc/6/fd/mysqlclient - - - (that is where I found lmysqlclient) This location probably isn't what you want. You

Re: Please help me , about mysql replicate!

2001-09-03 Thread Jeremy Zawodny
On Fri, Aug 31, 2001 at 05:44:11PM +0800, Wang Aocheng wrote: Dear All, I have a question: How can build multi-master-host? I have 3 mysql hosts,I want to use mysql data replicate. thanks! And you want all 3 to be masters? If so, you need to configure them in a

Please help me , about mysql replicate!

2001-08-31 Thread Wang Aocheng
Dear All, I have a question: How can build multi-master-host? I have 3 mysql hosts,I want to use mysql data replicate. thanks! wac - Before posting, please check: http://www.mysql.com/manual.php (the

alter table mytable order by my_column is too slowly, why? Please help me.

2001-08-23 Thread dxl
I execute this SQL with mysql 3.23.39 (all platform, Windows98, Windows2000 and Redhat Linux 7.1), but it's very very slowly. alter table mytable order by my_column; mytable has 3,000,000 rows, my_column is define as char(15). But when mytable has 1,000,000 rows, it's very fast,

Re: FULLTEXT/localisation error - please, please help me

2001-07-28 Thread Sergei Golubchik
Hi! On Jul 27, Peter Szekszardi wrote: Hi, I have recompiled mysql using the hungarian character set, reindexed all the tables,... I have strange problem now: Ok, could you create a test case for that ? Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_

FULLTEXT/localisation error - please, please help me

2001-07-27 Thread Peter Szekszardi
Hi, I have recompiled mysql using the hungarian character set, reindexed all the tables,... I have strange problem now: If I do: select count(*) from sites where match(site_content) against('tõzsde'); it returns 0. If I do: select count(*) from sites where site_content like % tõzsde %; it

localisation error - please, please help me

2001-07-26 Thread Pjotr Nyikolajevics Szekszardi
Hi, I have configured MySQL with charset latin2 on a Linux box. I made a big table with a mediumtext filed and a search engine using MySQL match-against. On the Linux box everything looked fine. Now we replaced our server to FreeBSD. I compiled the same source with the same configuration

localisation error - please, please help me

2001-07-25 Thread Pjotr Nyikolajevics Szekszardi
Hi, I have configured MySQL with charset latin2 on a Linux box. I made a big table with a mediumtext filed and a search engine using MySQL match-against. On the Linux box everything looked fine. Now we replaced our server to FreeBSD. I compiled the same source with the same configuration

PLEASE help me!! MySQL Linux Problem

2001-07-18 Thread David Ayliffe
I am having A LOT of trouble compiling the code Simple1.cc which comes with the C++ API for Linux I have extracted the API to a directory in /root/ and MySQL is installed and works in /usr/local/mysql PLEASE someone please help me compile just this simple program. What am I missing? When I

Re: PLEASE help me!! MySQL Linux Problem

2001-07-18 Thread Mike Baranski
15:28, David Ayliffe wrote: I am having A LOT of trouble compiling the code Simple1.cc which comes with the C++ API for Linux I have extracted the API to a directory in /root/ and MySQL is installed and works in /usr/local/mysql PLEASE someone please help me compile just this simple program

HELP! Please help me

2001-06-29 Thread Jez Brown
My host has set the max_allowed_packet to only 16384, so I'm unable to do large queries, such as submitting large text files into the database. Is there a way to increase the max_allowed_packet? Keeping in mind I'm on a shared host. Thanks in advance! Jez

RE: Hello please help me out

2001-06-28 Thread sean . odonnell
-Original Message- From: Divakar [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 28, 2001 4:50 AM To: [EMAIL PROTECTED] Subject: Hello please help me out Hi list I am a beginner in the field of mysql I would like to know whether it is possible to run sql scripts(a .sql file) in mysql. if yes

Re: Hello please help me out

2001-06-28 Thread Jack Challen
[EMAIL PROTECTED] wrote: try echo file.sql mysql -u username -p password databasename You mean: ^ cat file.sql | mysql -u username -p password databasename ^ Or, better: mysql -u username -p password databasename file.sql -- Jack Challen

RE: Hello please help me out

2001-06-28 Thread sean . odonnell
whoops, yip, **blush** -Original Message- From: Jack Challen [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 28, 2001 10:23 AM To: [EMAIL PROTECTED] Cc: Sean O'Donnell Subject: Re: Hello please help me out [EMAIL PROTECTED] wrote: try echo file.sql mysql -u username -p

Hello please help me out

2001-06-27 Thread Divakar
Hi list I am a beginner in the field of mysql I would like to know whether it is possible to run sql scripts(a .sql file) in mysql. if yes please some body tell me how do we do that,. regards Div - Before posting, please

Re: Hello please help me out

2001-06-27 Thread Paul DuBois
At 9:19 AM +0530 6/28/01, Divakar wrote: Hi list I am a beginner in the field of mysql I would like to know whether it is possible to run sql scripts(a .sql file) in mysql. if yes please some body tell me how do we do that,. The MySQL Reference Manual is your friend:

Could sombody please HELP me

2001-05-03 Thread Richard Kurth
I have a major problem could somebody take a seeress look at this mysql running on cobalt raq4 I have looked through the archives and looked at the manual can not find anything to explain this nothing in the mysql log file I can not access the databases from the web browser I get empty

Please HELP ME!!!!!!!!!!!!!!!!!!!!!!!!!!!

2001-04-11 Thread David Loszewski
k, I followed the instuctions on the MySQL page, downloaded mysql-3.23.36-pc-linux-gnu-i686.tar.gz for redhat linux and then followed the install directions: shell groupadd mysql shell useradd -g mysql mysql shell cd /usr/local shell gunzip /path/to/mysql-VERSION-OS.tar.gz | tar xvf - shell ln

Re: Please HELP ME!!!!!!!!!!!!!!!!!!!!!!!!!!!

2001-04-11 Thread B. van Ouwerkerk
[root@sp mysql]# chown -R root /usr/local/mysql -- The problem chown: /usr/local/mysql: No such file or directory Where is mysql installed this messages says it's not in /usr/local/mysql Search your system.. and chown the equivalent of the /usr/local/mysql Bye, B.

PLEASE HELP ME TO START

2001-04-04 Thread hanan khader
Hi friends ... I have sent once my problem, but don't know why, I haven't recieved any answer or solution for it ... Actually, I have installed MySql 3.22.21 on my SERVER NT4, and installed the MyODBC, I have installed them on my D drive ( the WINNT is installed on D drive) , and when I type

Re: PLEASE HELP ME TO START

2001-04-04 Thread B. van Ouwerkerk
At 10:41 4-4-01 +0200, hanan khader wrote: Hi friends ... I have sent once my problem, but don't know why, I haven't recieved any answer or solution for it ... Perhaps because you try to run MySQL on Windows.. I think most people on this list are familiar with MySQL on Linux. I found a link

Re: Please help me finding a sql-statement

2001-03-16 Thread Peter Holm
HI, If I understand your question, you need two queries: select count(*) as count, ip, value from log group by ip select count(*) as count, ip, value from log group by ip,value that leads to the right direction! thanks! It shows me a the ips with their values and how many times they are in the

Re: Please help me finding a sql-statement

2001-03-16 Thread Peter Holm
Hi, something, that gets quite near to what I want is: select a.id, a.value, b.value from test as a left join test as b on a.id=b.id group by a.id, a.value having a.valueb.value; It spits out the right data, but not the way I want... ++---+---+ | id | value | value |

Re: Please help me finding a sql-statement

2001-03-16 Thread Peter Holm
Hi, sometimes one has to have the feeling, that somebody wants to help to get it done better! :) I think I got it: select a.id, a.value from test as a left join test as b on a.id=b.id where a.value b.value group by a.id,a.value; Its good to check logtables! Of course I would appreciate

please, please help me

2001-03-13 Thread ¼­ºÀÈñ
I'm using MySQL 3.23.29-1 on a Red Hat Linux 7.0 platform. I've all patched the mysql-related bug fixes from Red Hat. I'm using a pentiumiii 800mhz dual processor system. I'm using mysql++ c++ api. My program links well with the sqlplus library and the mysqlclient library, but when I run the

problem installing MyODBC. Please Help Me.

2001-03-07 Thread Nice Nick
Hi friends, I am a beginner for mysql. finally i was able to set it up. now i have problems to set myodbc upthe error is like "An error occured while copying C:\WINDOWS\SYSTEM\MFC30.DLL the computer asks me to restart the computer and try install again. but it does not work, so i am looking

RE: Please Help me ..Apache_1.3.17+php-3.0.16+mysql-3.23.32

2001-02-16 Thread Fabian Gonzalo
I can't to compile this I'm getting the following error on my gmake (most snipped for brevity). gcc -DSOLARIS2=280 -DUSE_HSREGEX -DUSE_EXPAT -I./lib/expat-lite -DNO_DL_NEEDED -I/usr/local/include -I/usr/local/include/mysql `./apaci` -L/usr/local/lib -R/usr/local/lib \ -o httpd

Re: Would you please help me?

2001-01-15 Thread Atle Veka
On Tue, 16 Jan 2001, ±i®p»Ê wrote: Hi, happy new year!! Yesterday morning, I operated MySQL (3.23.28) insert some data into a table , I found a error and could not find any one can help with: - Welcome to the MySQL

please help me with charset

2001-01-10 Thread Roman Serbski
Good day all! Please help me with charset adding. I have some strange trouble. I use FreeBSD 4.2 STABLE and MySQL 3.23.28-gamma (compiled from FreeBSD ports) and PHP 4.04. As I understood Latin1 is a default charset. So, I wanted to add cp1251 or koi8_ru. Ok, I add --default-character-set=cp1251