RE: Please help me.

; 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 this

RE: Please help me.

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 to

Please help me.

ried to do 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

Re: can some please help me -- REPLICATION

bmisq01.bmi.com', master_user > = 'repl', master_password = 'repl'; > ERROR 29 (HY000): File './naxbmisq02-relay-bin.000157' not found > (Errcode: 2) > mysql> > > > > -Original Message----- > From: David Giragosian [mailto:[EMAIL PRO

RE: can some please help me -- REPLICATION

t; -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: > > you should probably just resync your s

RE: can some please help me -- REPLICATION

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 On

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 if > you > did start the slave (which seems doubtful) you'd have over a month's worth > of commands t

Re: can some please help me -- REPLICATION

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 ha

can some please help me -- REPLICATION

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: please help me.

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

please help me.

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: Boolean fulltext searches, AND instead of OR

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, G

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

efaults to AND instead of OR. > > Almost every search engine i have tried, google etc. works like this. > > "black horse cat dog" only show results with all words present. > > > > This is what i did, set global ft_boolean_syntax = ' +-><()~*:""&|' &

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

7; > > I really appreciate your help!! > > >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,

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

> > 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@list

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

t dog" only 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.mys

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

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 (tex

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

fault = 'AND' But it does not work, everything would be sooo much easier if this was possible. "black cat" is only an example and the real query comes from user input. So it can be anything like +cat -dog +"big nose" -horse white black -red so parsing the input is n

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

ow that i could put a + infront of every word 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 sho

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

t;black cat" is only an example and the real query 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

Re: please help me!

At 11:15 AM 10/1/2004, you wrote: Content-Type: text/plain; charset="UTF-8" Content-Language: en 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

please help me!

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 t

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

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

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

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 don't

Re: Please help me optimize a MySQL server.

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

Re: Please help me optimize a MySQL server.

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 h

Re: Please help me optimize a MySQL server.

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 bottlene

Re: Please help me optimize a MySQL server.

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 tho

Re: Please help me optimize a MySQL server.

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 op

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

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 s

Re: Please help me optimize a MySQL server.

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 take

Please help me optimize a MySQL server.

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 id

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

, 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 ha

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

Lost Idols [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 m

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

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 di

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

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

script 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

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

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 gi

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

d 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 everyone for your h

RE: Please help me!

, 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!

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

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 b

please help me

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 - problem with innodb foreign keys

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

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

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 compi

Please Help me

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 *** Er

Please help me with this fulltext query!

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 Exa

please help me

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' d

please help me

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' d

Re: please help me understand users & privileges

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 b

please help me understand users & privileges

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 c

Re: URGENT - ISAMCHK utility - Please help me

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: > ./is

Re: Please Help Me

can add it BUT > If I TRY TO ADD "SANDEEP" the length is 7 I could not add it. > getting 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 F

Please Help Me

ns 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 - Before postin

please help me

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

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

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

--- From: 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 confi

Re: please help me

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 a

RE: please help me

e { //connection is good } hope it helps. - 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

please help me

e this program iam getting the following 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,

Please help me restore my table

tore the records? 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 ¡ñ ¡ñ£© ¡ñ ¡ñ £©£Ü¡ñ£¯

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

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. Y

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

"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: ***

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

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

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 , about mysql replicate!

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 repl

Please help me , about mysql replicate!

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 manual

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

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, abou

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

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

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 retur

localisation error - please, please help me

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 settings

localisation error - please, please help me

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 settings

Re: PLEASE help me!! MySQL Linux Problem

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 compil

PLEASE help me!! MySQL Linux Problem

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

HELP! Please help me

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

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 >

Re: Hello please help me out

[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 Chall

Re: Hello please help me out

[EMAIL PROTECTED] wrote: > > try > > echo file.sql > mysql -u username -p password databasename > > or on dos > > type file.sql > mysql -u username -p password databasename > > That should execute the scripts on the db in question, > > or you can download a a tool like mysqlgui/mysqlfront an

RE: Hello please help me out

Sean -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.

Re: Hello please help me out

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: http://www.mysql.c

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 please some body tell me how do we do that,. regards Div - Before posting, please che

Could sombody please HELP me

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 data

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

> 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

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

>[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!!!!!!!!!!!!!!!!!!!!!!!!!!!

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

Re: PLEASE HELP ME TO START

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

PLEASE HELP ME TO START

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 fr

Re: Please help me finding a sql-statement

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; It´s good to check logtables! Of course I would appreciate sugg

Re: Please help me finding a sql-statement

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.value<>b.value; It spits out the right data, but not the way I want... ++---+---+ | id | value | value | ++--

Re: Please help me finding a sql-statement

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

Re: Please help me finding a sql-statement

Sent: Friday, March 16, 2001 3:44 PM Subject: Please help me finding a sql-statement Hi, it is quite easy, I thought, but I can´t find it... there is a table, which is used as a simple "logging table", so there is only ip | value | time ip is not unique, neither is value. ip and value in

Please help me finding a sql-statement

Hi, it is quite easy, I thought, but I can´t find it... there is a table, which is used as a simple "logging table", so there is only ip | value | time ip is not unique, neither is value. ip and value in different rows can have the same values but sometimes they differ, that´s the point! I want

please, please help me

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 linke

problem installing MyODBC. Please Help Me.

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 f

please help me

please tell me how to build mysql+dbd+windows2000 to surport transactions. thank you very much i beg your help and best luck with you topsky -- »¶Ó­Ê¹Óà 21CN µç×ÓÓʼþϵͳ http://www.21cn.com Thank you for using 21cn.com

FW: Problem in myODBC(please help me)

> Hi, > My name is sanjeev gupta. I have installed the mysql on nt owrkstation and > also insatlle the myodbc drivers and i am trying to connect with mysql > using the odbc and it gave me error while i am trying too create file dsn. > the Error is followed > > <<...>> > and if i try to create a

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

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 buildmark.

Re[2]: Would you please help me?

Hello Atle, Monday, January 15, 2001, 22:12:28 PM, you wrote: AV> 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: >>

Re: Would you please help me?

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 mo

  1   2   >