Re: Clean way of execution of query....
Hey there!..Don! The Problemo returns! :( Let me be explicit this time with my query : #1 mysql desc table A; +-+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +-+-+--+-+-+---+ | mId | int(11) | | PRI | 0 | | | tId | int(11) | | PRI | 0 | | +-+-+--+-+-+---+ 2 rows in set (0.44 sec) mysql desc table B; +-+--+--+-++---+ | Field | Type | Null | Key | Default| Extra | +-+--+--+-++---+ | tId | int(11) | | PRI | 0 | | | tName| varchar(100) | | || | +-+--+--+-++---+ 2 rows in set (0.08 sec) mysql select * from table A; +-++ | mId | tId | +-++ | 1 | 1 | | 2 | 1 | | 2 | 6 | +-++ 3 rows in set (0.00 sec) #2 what I need to do is : mysql select * from tableA where mId=1; [ this gives me the result set of all rows that have mId=1] +-++ | mId | tId | +-++ | 1 | 1 | +-++ 1 row in set (0.00 sec) Now with this result set [ tId=1] I want to eliminate the resulting Ids frm table A and display the rest of the rows in table B. The join stmt (left and right) eliminate the rows frm each table and display it... For that I wud have to run another query to get the other rows which are there in table A , which have a valid tId and which are related to other mIds as well.. current solution -- In brief #1 I am getting the result set of all tIds, mIds frm table A which have mIds=1; capturing the resultant Ids as (1,2...etc) , storing that as a string (tString = 1,2 and running the following: #2 query : select * from Table B where tId not in (tString); All I want is the same result , but using joins, Iff it is possible! I certainly hope u get my problem this time!!:(.. Thanks for your time Rgds, Ash - Original Message - From: Don Read [EMAIL PROTECTED] To: Asha Ramaiah [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, July 04, 2001 12:59 PM Subject: RE: Clean way of execution of query java-digest elide On 04-Jul-01 Asha Ramaiah wrote: Hey! guys! I wanted a little help on the following : .. Scenario: I have 2 tables : one task and the other tasksequence desc task : (primary key taskId, varchar taskdesc) desc tasksequence (primary key (taskId,milestoneId)) Now the query I want to form should give me a list of all taskIds in table task excluding the taskIds frm tasksequence..( a result set of 15 rows(taskIds)) Can somebody help me with this ??...I have developed a quick fix for this : -- capture the resultset of all the taskIds in tasksequence , as a string --and then : select taskId from task where taskId not in (taskIdsString) Its working , but is the same not possible with left/right or natural Start reading the manual, pay attention at: If there is no matching record for the right table in the ON or USING part in a LEFT JOIN, a row with all columns set to NULL is used for the right table. You can use this fact to find records in a table that have no counterpart in another table: mysql select table1.* from table1 LEFT JOIN table2 ON table1.id=table2.id where table2.id is NULL; stop reading. -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Little problem with gcc
Hi I have some problem with my OS system (DEC 0.4) when I ran commad # CC=gcc CXX=gcc CXXFLAGS=-O3 ./configure --prefix=/usr/local/etc/mysql-3.23.39 error is CC=gcc: Command not found. Ummm I think it maybe not error of mysql but please help me to fix this error. Thank - Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/
Little problem with gcc
Hi I have some problem with my OS system (DEC 0.4) when I ran commad # CC=gcc CXX=gcc CXXFLAGS=-O3 ./configure --prefix=/usr/local/etc/mysql-3.23.39 error is CC=gcc: Command not found. Ummm I think it maybe not error of mysql but please help me to fix this error. Thank - Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/
Re: Little problem with gcc
This is not a mysql error, Your paths are setup incorrectly or you don't have GCC installed, set the environment variable `CC' to the location of your gcc compiler, CC=something; export CC KFC wrote: Hi I have some problem with my OS system (DEC 0.4) when I ran commad # CC=gcc CXX=gcc CXXFLAGS=-O3 ./configure --prefix=/usr/local/etc/mysql-3.23.39 error is CC=gcc: Command not found. Ummm I think it maybe not error of mysql but please help me to fix this error. Thank - Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
defining allowed host for mysql
I tried to connect to my mysql server but there was always an error message saying this host is not allowed. Anybody so kind to tell me, how can I define the hostname/computer name in my mysql server to be allowed connect to my database server and use my kmysqladmin and kmysql software. Thanks in advance. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: defining allowed host for mysql
On Mon, Jul 09, 2001 at 01:11:44AM -0700, Prabu Subroto wrote: I tried to connect to my mysql server but there was always an error message saying this host is not allowed. Anybody so kind to tell me, how can I define the hostname/computer name in my mysql server to be allowed connect to my database server and use my kmysqladmin and kmysql software. Look up the GRANT command in the MySQL manual: http://www.mysql.com/doc/ Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 22 days, processed 172,097,510 queries (86/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Migrationfrom Access 2000 to MySQL
We have made up our mind to turn our Access 2000 database into a MySGL one. Could you please explain us the path to follow and give us information about it ? Dominique Vellin Business developement Azentis Technology Your Outsourcing Provider Tel : 33 1 42 77 21 02 Mobile: 33 6 82 13 32 90 E-mail : [EMAIL PROTECTED]
mysql without tcp connections
Hi, is possible to create a mysql without tcp connection ??? i don't need connect via tcp only via unix socket (only from localhost) Michal Dvoracek[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: defining allowed host for mysql
Have you filled out the tables user, db in mysql. And after filling this tables you must start mysqladmin reload. Regards Gerlinde At 01:11 09.07.01 -0700, Prabu Subroto wrote: I tried to connect to my mysql server but there was always an error message saying this host is not allowed. Anybody so kind to tell me, how can I define the hostname/computer name in my mysql server to be allowed connect to my database server and use my kmysqladmin and kmysql software. Thanks in advance. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php BLITZ Internet Service GmbH Kronacher Strasse 41 D-96052 Bamberg, Germany Tel. +49/951/9685160, Fax +49/951/9685164 http://www.blitz.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: tables locked
I use Delphi 5 and MyODBC to access a MySQL database. In my program, I've sometimes a tables locked and I don't understand why ! I am the only user on this database and I change records correctly (as I do it for other programs on other databases). Does somebody have this problem ? Can you explain me how to unlock tables and records with MySQL ? Is it a bug in Borland Delphi ou BDE ? Is it a bug in MyODBC ? Is it a bug in MySQL ? Is it a bug in my program (I don't see where I could have make an error... but it's a possibility) ? You did not included enough information to solve your problem. But I can thing we can solve it easily if you give us output of mysqladmin processlist while the problem exists. I think we can read out the problem from there. Hi Only mine process appears in the list. I think the bug in inside the Borland Database Engine and its parameters. I'll try something and let you know. cu9 -- Patrick Premartin contacts perso: [EMAIL PROTECTED], http://www.pprem.net/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Installinging MySQL on a virtual server
Hi, I wonder I someone can give me some advice about the following situation. I have to install MySQL to be used with a website on a virtual server. This gives the following restraints: * MySQL must be installed in my user directory /usr/local/WWW/www.mydomain.com/mysql * I am only allowed to use the TCP/IP ports on the virutal host www.mydomain.com, not on the actual host. * I have no root access and cannot edit the startup scripts. * My provider uses BSDI BSD 4.0.1 as operating system on the host. Who has any clues for me? Ton Geurts - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
error on make 3.23.39 sorce on DEC 4.0E
Hi I have error after use make command like this:# makeNo suffix list.cd include; make link_sourcesNo suffix list./sbin/cp ../config.h my_config.hecho timestamp linked_include_sourcescd libmysql; make link_sources. (more output - you can see more details in attach file) echo timestamp linked_libmysql_r_sourcesmake all-recursiveNo suffix list.Making all in includeNo suffix list.Make: % rule can only use a single ':'. Stop.*** Exit 1Stop.*** Exit 1Stop. Thank youDo You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year!http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: defining allowed host for mysql
After you've filled the user and db tables in the mysql database, just give the command mysql flush privileges; The privileges will be reread. It's easier if you're tuning the whole story. GRTNX, Ton Geurts -Oorspronkelijk bericht- Van: Gerlinde Fischer [mailto:[EMAIL PROTECTED]] Verzonden: maandag 9 juli 2001 11:11 Aan: Prabu Subroto; [EMAIL PROTECTED] Onderwerp: Re: defining allowed host for mysql Have you filled out the tables user, db in mysql. And after filling this tables you must start mysqladmin reload. Regards Gerlinde At 01:11 09.07.01 -0700, Prabu Subroto wrote: I tried to connect to my mysql server but there was always an error message saying this host is not allowed. Anybody so kind to tell me, how can I define the hostname/computer name in my mysql server to be allowed connect to my database server and use my kmysqladmin and kmysql software. Thanks in advance. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php BLITZ Internet Service GmbH Kronacher Strasse 41 D-96052 Bamberg, Germany Tel. +49/951/9685160, Fax +49/951/9685164 http://www.blitz.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql without tcp connections
On Mon, Jul 09, 2001 at 10:44:24AM +0100, Dvoøáèek Michal wrote: Hi, is possible to create a mysql without tcp connection ??? i don't need connect via tcp only via unix socket (only from localhost) I believe the --skip-networking option does just that. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 23 days, processed 172,330,002 queries (86/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Storing multi-page texts
You could store the data as XML and use XSL to transform it when you pull it out of the database -Original Message- From: Chris Lott [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 08, 2001 7:39 PM To: MySQL List (E-mail) Subject: Storing multi-page texts What kind of methods have any of you used for storing text that needs to be displayed as both multi-page (for reading) and single-page (for printing)? My plan is to store the articles with basic HTML formatting that will render based on the site stylesheet(s). I'm using MySQL. My main question is how to deal with the multiple pages. Higher-ups would prefer that article authors not have to split the file into various fields when composing. My idea is to have the authors insert a code/comment that indicates a page break in the text (something like, cryptically, PAGEBREAK) and then when pulling the article from the DB, create a menu for selecting pages (there has to be a small menu at the bottom of each article with a link to each article page and an indication where the user is), display the proper page, etc. I've still not got my head completely around how I am going to do this, so I am looking for suggestions on how other sites manage this need. c - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error on make mysql 3.23.39
Hi I have error after make command like # make No suffix list. cd include; make link_sources No suffix list. /sbin/cp ../config.h my_config.h echo timestamp linked_include_sources cd libmysql; make link_sources (more output) + /sbin/ln -s ../libmysql/violite.c ./violite.c echo timestamp linked_libmysql_r_sources make all-recursive No suffix list. Making all in include No suffix list. Make: % rule can only use a single ':'. Stop. *** Exit 1 Stop. *** Exit 1 Stop. I set CC , CXX . etc. in comment of http://www.mysql.com/doc/A/l/Alpha-DEC-OSF1.html . But it still not work . Thank you - Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/
Re: Clean way of execution of query....
On 09-Jul-01 Asha Ramaiah wrote: Hey there!..Don! The Problemo returns! :( Let me be explicit this time with my query : mysql select * from table A; +-++ | mId | tId | +-++ | 1 | 1 | | 2 | 1 | | 2 | 6 | +-++ 3 rows in set (0.00 sec) mysql select * from a; +---+---+ | m | t | +---+---+ | 1 | 1 | | 2 | 1 | | 2 | 6 | +---+---+ 3 rows in set (0.00 sec) mysql select * from b; +---+---+ | t | name | +---+---+ | 1 | one | | 2 | two | | 3 | foo | | 4 | bar | | 5 | baz | | 6 | phsst | | 7 | bogon | +---+---+ 7 rows in set (0.00 sec) You want every thing in table b that is not tId=1, right ? So find the combination product of table a that's invalid: mysql select a.*,x.* - from a left join a as x using(t) where a.m=1; +---+---+--+--+ | m | t | m| t| +---+---+--+--+ | 1 | 1 |1 |1 | | 1 | 1 |2 |1 | +---+---+--+--+ 2 rows in set (0.00 sec) Query table b for rows not in the product: mysql select distinct b.* - from a left join a as x using(t), b - where a.m=1 and b.t not in (a.t, x.t); +---+---+ | t | name | +---+---+ | 2 | two | | 3 | foo | | 4 | bar | | 5 | baz | | 6 | phsst | | 7 | bogon | +---+---+ 6 rows in set (0.00 sec) Okey-dokey, that'll work for your example case; the problem is as you get additional 't' values ... mysql insert into a values (1,4); mysql select * from a; +---+---+ | m | t | +---+---+ | 1 | 1 | | 1 | 4 | | 2 | 1 | | 2 | 6 | +---+---+ 4 rows in set (0.00 sec) b.tId 1 4 are invalid; you'll need another self left join for each t value; plus another term in the ' b.t not in (a.t, x.t, y.t ...)' So for the robust case, make a temp table of 'bad' values: create table bad(t int not null unique); mysql replace into bad - select t from a where m=1; And fetch the b rows that aren't in bad ... mysql select b.* - from b left join bad using(t) - where bad.t is null; +---+---+ | t | name | +---+---+ | 2 | two | | 3 | foo | | 5 | baz | | 6 | phsst | | 7 | bogon | +---+---+ 5 rows in set (0.01 sec) drop table bad; Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: saving in mysql
I also think that is something with php , because i was checking the code on my computer on windows with apache, php and mysql installed and it didn't propmt such errors. I also have another database put on another server, but the code thats providing data is on the same server where the first databse is and it prompts the 'unable to save result set' error too. so if its not the code, not the database... so what's wrong with the php? [the code is some standart stuff on every file, i.e. : ? $url = 'host'; $login = 'user'; $pass = 'pass'; mysql_connect($url,$login,$pass); mysql_select_db('database'); . . . $query="INSERT INTO table_1 SET data1='$data1', data2='$data2' .. "; ? you said something about logging with php... what do you mean? Stink My guess is that you have logging on for php but it has problems saving to it's current location but I'm not psychic so I don't know. (ie. provide the list with some code) - Original Message - From: "Stink" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 09, 2001 7:05 Subject: saving in mysql I've been dealing with this problem for a few days now and I got no idea what's going on: the base is working properly but for one thing - when changing anything in base, i.e. saving new record or creating new tables or dropping tables - anything that involves change in the base - MySQL says: "unable to save result set in example.php on line 30" [for example] but strangest thing is that the record GETS saved/altered/dropped anyway... do you have any idea whats going on ? Thanx in advance Stink - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB is on summer vacation July 9th to July 16th
Heikki Tuuri writes: Hi! Sun is shining and the weather is excellent in Helsinki :). I will be on vacation July 9th to July 16th. I will read email a couple of times. Regards, Heikki Tuuri Innobase Oy Have a nice vacation !! -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Need your helps!!!
Have a look http://www.mysql.com/doc/R/e/Replication_Implementation.htmlat It is all about what you would like to do. Simon -Original Message- From: chen jun [mailto:[EMAIL PROTECTED]] Sent: 09 July 2001 10:52 To: [EMAIL PROTECTED] Subject: Need your helps!!! Hi There: I want to establish several mysql servers which can synchronize data each other(if data of one server is updated,the others can be updated too). I don't know if it's done and how to do this. Need your helps. Regards, Jack - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: bug report on WinMySQLadmin 1.1
Werner Stuerenburg writes: _ Win98 4.10.98, AMD Duron, 128 MB RAM MySQL 3.23.39 running on localhost _ Query is DELETE FROM staticStrings WHERE ruri LIKE 'staticAnzeigen%' _ Error is Lost connection to MySQL server during query _ -- Herzlich Werner Stuerenburg Hi! The above behavour can be caused by corrupted table. If however, the above DELETE always crashes our latest 3.23.39 binary, you should prepare a repeatable test case and send it to [EMAIL PROTECTED] A complete bug report is done in the following manner: 1) First check the reference manual and the mail archive ! We try very hard to keep the manual up to date so most questions can usually be solved by looking it up. Write in the mail that you have checked the reference manual and mail archive so others know that you have tried to solve the problem yourself. 2) ALWAYS use mysqlbug when posting questions about a MySQL version you are using! mysqlbug is for bug reports AND questions. 3) Send the bug report to the right mailing list. (See http://www.mysql.com/documentation/lists.html). If you are unsure you should use [EMAIL PROTECTED] 4) Include a full example for the problem, including a full test case with all responses/error messages. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problems with MyODBC
Hi. I have problems with MyODBC. I would like to use MyODBC with MonitorPRO software. During reading data from MySQL I got error: "SQLBindParameter not used for all parameters...". I CAN'T change MonitorPRO software code - I need help with configuring MyODBC or another dirver (for Win NT). Please, help me. Best Regards Mateusz Rudyk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Need your helps!!!
No. That link is about one way Replication. A main server with backup servers and if the main server dies, a backup can take over. What was asked was if any one server is updated, all others are updated. I'm also interested but I very much doubt it can be done because there is nothing in the manuals about this. - Original Message - From: Simon Green [EMAIL PROTECTED] To: 'chen jun' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, July 09, 2001 17:58 Subject: RE: Need your helps!!! Have a look http://www.mysql.com/doc/R/e/Replication_Implementation.htmlat It is all about what you would like to do. Simon -Original Message- From: chen jun [mailto:[EMAIL PROTECTED]] Sent: 09 July 2001 10:52 To: [EMAIL PROTECTED] Subject: Need your helps!!! Hi There: I want to establish several mysql servers which can synchronize data each other(if data of one server is updated,the others can be updated too). I don't know if it's done and how to do this. Need your helps. Regards, Jack - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re[2]: bug report on WinMySQLadmin 1.1
The above behavour can be caused by corrupted table. If however, the above DELETE always crashes our latest 3.23.39 binary, you should prepare a repeatable test case and send it to [EMAIL PROTECTED] Sorry, the bug was not about MySQL, but WinMySQLadmin 1.1 Write in the mail that you have checked the reference manual and mail archive so others know that you have tried to solve the problem yourself. Ok, I'll write that I checked the manual. 2) ALWAYS use mysqlbug when posting questions about a MySQL version you are using! mysqlbug is for bug reports AND questions. Sorry, I looked for it, but I didn't find mysqlbug. 3) Send the bug report to the right mailing list. (See http://www.mysql.com/documentation/lists.html). If you are unsure you should use [EMAIL PROTECTED] The manual says to send it to this list only when using the right format, which I didn't do. Also, which is the list for WinMySQLadmin-bugs? 4) Include a full example for the problem, including a full test case with all responses/error messages. Which is what I did, although I missed that I could have uploaded the table to your site instead of offering it to download from my site - but anyway, you should be able to reproduce the problem. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re[2]: bug report on WinMySQLadmin 1.1
Werner Stuerenburg writes: prepare a repeatable test case and send it to [EMAIL PROTECTED] Sorry, the bug was not about MySQL, but WinMySQLadmin 1.1 -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de The error : Server has gone away ... is not WinMySQLAdmin error, but error on the server side. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Need your helps!!!
It can be done but there are a lot of problems with keeping the data in both or more data bases in line with each other. But this should be part of the V4 release. Simon -Original Message- From: Rolf Hopkins [mailto:[EMAIL PROTECTED]] Sent: 09 July 2001 11:34 To: Simon Green; 'chen jun'; [EMAIL PROTECTED] Subject: Re: Need your helps!!! No. That link is about one way Replication. A main server with backup servers and if the main server dies, a backup can take over. What was asked was if any one server is updated, all others are updated. I'm also interested but I very much doubt it can be done because there is nothing in the manuals about this. - Original Message - From: Simon Green [EMAIL PROTECTED] To: 'chen jun' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, July 09, 2001 17:58 Subject: RE: Need your helps!!! Have a look http://www.mysql.com/doc/R/e/Replication_Implementation.htmlat It is all about what you would like to do. Simon -Original Message- From: chen jun [mailto:[EMAIL PROTECTED]] Sent: 09 July 2001 10:52 To: [EMAIL PROTECTED] Subject: Need your helps!!! Hi There: I want to establish several mysql servers which can synchronize data each other(if data of one server is updated,the others can be updated too). I don't know if it's done and how to do this. Need your helps. Regards, Jack - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re[4]: bug report on WinMySQLadmin 1.1
The error : Server has gone away ... is not WinMySQLAdmin error, but error on the server side. True, but WinMySQLAdmin should not crash with a GPF, right? Or is that an expected behaviour, even a feature? -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Need your helps!!!
No. That link is about one way Replication. A main server with backup servers and if the main server dies, a backup can take over. What was asked was if any one server is updated, all others are updated. I'm also interested but I very much doubt it can be done because there is nothing in the manuals about this. I didn't see anything on MySQL about this problem and developped a little (windows NT/2000) soft that do it, but it has constraints and some bugs I haven't yet fixed. The problems are: - I need to restart it as soon as a connecting problem appear (ODBC don't restart connecting to servers) - some locked tables appear with no reason Constraints: - adding a new field in each replicated table - having a primary index on each replicated table. -- Patrick Premartin contacts perso: [EMAIL PROTECTED], http://www.pprem.net/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re[4]: saving in mysql
What do you send to MySQL? $query is just a string. Sie schrieben am Montag, 9. Juli 2001, 12:45:48: MySQL pops out a error message - "unable to save result set in example.php on line xxx" but the data gets put inside the database anyway... Why should php try to save something into a file? You must tell it to do so. And if you do, you have bad luck. php runs as nobody, and nobody should not be able to write to files. The problem is not with MySQL, as is obvious. You should look for line xxx. Here you will try to write to the file, which cannot work unless you define the rights accordingly. You may chmod the rights on the file you want to write to or put that file into a directory open for nobody. Will this be a good idea? I'm not sure. There are good reasons to run php as nobody. If you want to save data from input, you will rather use MySQL, which is a controlled procedure. As you do already, I wonder why and what you want to write to a file. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re[4]: bug report on WinMySQLadmin 1.1
Werner Stuerenburg writes: The error : Server has gone away ... is not WinMySQLAdmin error, but error on the server side. True, but WinMySQLAdmin should not crash with a GPF, right? Or is that an expected behaviour, even a feature? -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de No, it should not. So, you should make two bug reports !! -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re[4]: saving in mysql
What do you send to MySQL? $query is just a string. well i send to you only a part of code, here is complete example of it: [the login stuff] $zapytanie = "INSERT INTO aktualnosci SET tytul='$tytul', przemd='$przemd', przeml='$przeml', przemm='$przemm', polska='$polska', swiat='$swiat', data='$data', lead='$lead', tresc1='$tresc1', tresc2='$tresc2', tresc3='$tresc3', tresc4='$tresc4', tresc5='$tresc5', autor='$autor', dzial='$dzial', standart='$jest'"; $wynik = mysql_query($zapytanie); if($wynik) echo "centerbArtyku| dodany prawid|owo!/bbr /center"; else { echo "centerB|_d przy dodawaniu artyku|u - sprbuj jeszcze raz.br/center"; } the data is coming from a form... MySQL pops out a error message - "unable to save result set in example.php on line xxx" but the data gets put inside the database anyway... Why should php try to save something into a file? You must tell it to do so. And if you do, you have bad luck. php runs as nobody, and nobody should not be able to write to files. but i do NOT write anything into a file... the comes from the form and is saved in the database as in the code above. i do not use any files here... i must mention that it must be something with system i think. the server was run on linux red hat 7, but a week ago it was moved because the firm moved. and then it was reinstalled also, admin installed debian instead of red hat [i don't know what for anyway, but admin is always admin ;)]. and before [when red hat was on] there was no such problem, and all scripts ran well without this error messages. now - i dont know , maybe php is configured badly ? have no idea... The problem is not with MySQL, as is obvious. i think so You should look for line xxx. Here you will try to write to the file, which cannot work unless you define the rights accordingly. You may chmod the rights on the file you want to write to or put that file into a directory open for nobody. as i said, i do not use any file... -- Herzlich Werner Stuerenburg stink - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Many Unauthenticatd Users
Hello, we are running a mysql-3.23-39 server under Suse 7.1 which has to do a very high number of insert-queries (somewhere around 600 queries/minute). But since yesterday the server kepps on spawing processes which are reported to belong to Unauthenticated user and in state Login. This continues until max_connections is reached and then the server quits without further error messages. (Neither in the error log nor in the query-log). We have already tried reinserting all data from a dump, using a different server and different mysql-version. It shouldn't be a load problem, because before the problem occured the server (a Compaq Proliant with a 933 Mhz Xeon cpu) was running on a load average below 0.10. Any help will be appreciated, Thanks in Advance, -- Mario Witte [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re[4]: saving in mysql
This is more like what we want to see and pointing us to which line causes the error would help even more. But from this, you're mixing up your INSERT and UPDATE statements for starters. What you have would be correct if you replaced INSERT INTO with UPDATE. For INSERT, it is a comma delimited list of values enclosed by brackets. Please RTFM. - Original Message - From: "Stink" [EMAIL PROTECTED] To: "Werner Stuerenburg" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, July 09, 2001 19:31 Subject: Re: Re[4]: saving in mysql What do you send to MySQL? $query is just a string. well i send to you only a part of code, here is complete example of it: [the login stuff] $zapytanie = "INSERT INTO aktualnosci SET tytul='$tytul', przemd='$przemd', przeml='$przeml', przemm='$przemm', polska='$polska', swiat='$swiat', data='$data', lead='$lead', tresc1='$tresc1', tresc2='$tresc2', tresc3='$tresc3', tresc4='$tresc4', tresc5='$tresc5', autor='$autor', dzial='$dzial', standart='$jest'"; $wynik = mysql_query($zapytanie); if($wynik) echo "centerbArtyku| dodany prawid|owo!/bbr /center"; else { echo "centerB|_d przy dodawaniu artyku|u - sprbuj jeszcze raz.br/center"; } the data is coming from a form... MySQL pops out a error message - "unable to save result set in example.php on line xxx" but the data gets put inside the database anyway... Why should php try to save something into a file? You must tell it to do so. And if you do, you have bad luck. php runs as nobody, and nobody should not be able to write to files. but i do NOT write anything into a file... the comes from the form and is saved in the database as in the code above. i do not use any files here... i must mention that it must be something with system i think. the server was run on linux red hat 7, but a week ago it was moved because the firm moved . and then it was reinstalled also, admin installed debian instead of red hat [i don't know what for anyway, but admin is always admin ;)]. and before [when red hat was on] there was no such problem, and all scripts ran well without this error messages. now - i dont know , maybe php is configured badly ? have no idea... The problem is not with MySQL, as is obvious. i think so You should look for line xxx. Here you will try to write to the file, which cannot work unless you define the rights accordingly. You may chmod the rights on the file you want to write to or put that file into a directory open for nobody. as i said, i do not use any file... -- Herzlich Werner Stuerenburg stink - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re[6]: saving in mysql
The php code looks ok. What do you have in line xxx in example.php? Usually, this is the key to the error. I never saw such an error message, so I would like to see what php is supposed to do in that line. For spam filter usage: table -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Need your helps!!!
Yes, looks like you're right, which means that the Introduction and Overview chapters of Replication need to be reviewed as it gives the impression that it can't be done. - Original Message - From: Simon Green [EMAIL PROTECTED] To: 'Rolf Hopkins' [EMAIL PROTECTED]; Simon Green [EMAIL PROTECTED]; 'chen jun' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, July 09, 2001 18:36 Subject: RE: Need your helps!!! It can be done but there are a lot of problems with keeping the data in both or more data bases in line with each other. But this should be part of the V4 release. Simon -Original Message- From: Rolf Hopkins [mailto:[EMAIL PROTECTED]] Sent: 09 July 2001 11:34 To: Simon Green; 'chen jun'; [EMAIL PROTECTED] Subject: Re: Need your helps!!! No. That link is about one way Replication. A main server with backup servers and if the main server dies, a backup can take over. What was asked was if any one server is updated, all others are updated. I'm also interested but I very much doubt it can be done because there is nothing in the manuals about this. - Original Message - From: Simon Green [EMAIL PROTECTED] To: 'chen jun' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, July 09, 2001 17:58 Subject: RE: Need your helps!!! Have a look http://www.mysql.com/doc/R/e/Replication_Implementation.htmlat It is all about what you would like to do. Simon -Original Message- From: chen jun [mailto:[EMAIL PROTECTED]] Sent: 09 July 2001 10:52 To: [EMAIL PROTECTED] Subject: Need your helps!!! Hi There: I want to establish several mysql servers which can synchronize data each other(if data of one server is updated,the others can be updated too). I don't know if it's done and how to do this. Need your helps. Regards, Jack - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Many Unauthenticatd Users
On 09-Jul-01 Mario Witte wrote: Hello, we are running a mysql-3.23-39 server under Suse 7.1 which has to do a very high number of insert-queries (somewhere around 600 queries/minute). But since yesterday the server kepps on spawing processes which are reported to belong to Unauthenticated user and in state Login. This continues until max_connections is reached and then the server quits without further error messages. (Neither in the error log nor in the query-log). We have already tried reinserting all data from a dump, using a different server and different mysql-version. It shouldn't be a load problem, because before the problem occured the server (a Compaq Proliant with a 933 Mhz Xeon cpu) was running on a load average below 0.10. Stop Apache (or whatever the source of your logins), shut down restart mysqld, then check/repair the tables in the mysql database; might want check any other high activity tables also. restart Apache. Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
word count
How do I build an SQL query which returns rows based on whether or not strings in a column contain more than one word eg. SELECT name FROM contacts WHERE WORD COUNT(name)1 I am aware that such a query is bogus but it seems as if there must be a straightforward way of doing this. thanks Tommy Beavitt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: First time MySQL
Anoop K Gupta wrote: Hi, I am first time user of MySQL. My ISP has just been installed mysql... I have connected to server through telnet and access MySQL by following command.. and connected successfully. mysql -h myhostname -u root -p password :- mysq If you are telnetted in, you should not be using -h. But when I tried to access any database or trying to create database it is giving error :- Access Denied for [EMAIL PROTECTED] Can any one from you please help me in this regards... Thanks in advance.. Buy Feng Shui Package for Rs. 151/- only, at http://shopping.rediff.com/shopping/fengshui_mailer.htm - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FFIRST TIME...MYSQL
Hi everybody I am still having problem.. please help. My ISP just had installed MySQL on remote Linux server. I am able to connect to my remote mysql server but fail to create, user any database ... I let you know step by step.. what I have done 1. First I have connected to my remote server through Telnet. After becoming root... I had supplied following command... 2. mysql -h mydomainname -u root -p it prompts for password : it is blank so I just pressed enter. and Mysql prompt appeared.. mysql Then I typed 3. mysql use mysql; Result : - ERROR 1045 Access deneid for user [EMAIL PROTECTED] using password : no Can you please help me in this regards? Thanks Buy Feng Shui Package for Rs. 151/- only, at http://shopping.rediff.com/shopping/fengshui_mailer.htm - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Where to find options / my.cnf documentation?
Where do I find a complete documentation of all options and entries in my.cnf and the mysqld start options? I searched the mysql.com site, but to no avail. Neither does the online documentation doesn't seem to have a chapter on it. s.m. Qualimedic AG Sascha Mantscheff Telefon 0171-6200380 Telefax 02291-3841 e-Mail [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Where to find options / my.cnf documentation?
It's not real easy to find but it is in the manual at www.mysql.com. It would be nice to have a chapter in the manual dedicated to the cnf file both server and user. detailing each property that can be set there and what it means. Cal * * Cal Evans * Senior Internet Dreamer * http://www.calevans.com * - Original Message - From: Sascha Mantscheff [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 09, 2001 09:10 Subject: Where to find options / my.cnf documentation? Where do I find a complete documentation of all options and entries in my.cnf and the mysqld start options? I searched the mysql.com site, but to no avail. Neither does the online documentation doesn't seem to have a chapter on it. s.m. Qualimedic AG Sascha Mantscheff Telefon 0171-6200380 Telefax 02291-3841 e-Mail [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Init Mysql throuht the sockets
The path to the socket must be radable and searchable by the world. The socket itself must be world writable. Roberto Carlos Sánchez Barroso wrote: I´ve already installed mysql, but i can only connect via TCP/IP, and i can´t do it by socket. I´ve got all the permissions rigth and the mysql.socket file in the rigth directory. Can anybody help me? Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: word count
How about: select position(' ' IN name) as fs from contacts having fs0; On Mon, 9 Jul 2001, Tommy Beavitt wrote: How do I build an SQL query which returns rows based on whether or not strings in a column contain more than one word eg. SELECT name FROM contacts WHERE WORD COUNT(name)1 I am aware that such a query is bogus but it seems as if there must be a straightforward way of doing this. thanks Tommy Beavitt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Migration from Access 2000 to my SQL
Cordialement, We have made up our mind to turn our Access 2000 database into a MySGL one. Could you please explain us the path to follow and give us information about it ? Dominique Vellin Business developement Azentis Technology Your Outsourcing Provider Tel : 33 1 42 77 21 02 Mobile: 33 6 82 13 32 90 E-mail : [EMAIL PROTECTED]
Re: Migration from Access 2000 to my SQL
You are going to have to write something to translate. I recently did a DBF to MySQL migration. I wrote programs in Visual FoxPro to create .SQL files. These files created the needed structure in MySQL and then did a butt-load of insert's to populate the tables. YMMV but it worked for me. Cal * * Cal Evans * Senior Internet Dreamer * http://www.calevans.com * - Original Message - From: Matthieu Neukirch [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 09, 2001 09:30 Subject: Migration from Access 2000 to my SQL Cordialement, We have made up our mind to turn our Access 2000 database into a MySGL one. Could you please explain us the path to follow and give us information about it ? Dominique Vellin Business developement Azentis Technology Your Outsourcing Provider Tel : 33 1 42 77 21 02 Mobile: 33 6 82 13 32 90 E-mail : [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: use of RENAME???
Hi, Renaming of the database is on the TODO list. Some comments follow. 1) Renaming of the directory will work for table types of MyISAM and BDB (with exceptions). This won't work for InnoDB types. 2) When renaming a directory make sure to shutdown the server and that you have no pending transactions on BDB table types. Then shutdown the server, rename the directory and restart the server. 3) Another method which works well if you only have a couple of tables in the DB. 1: create the new DB. 2: use RENAME TABLE oldbd.table1 TO newdb.table1, olddb.table2 TO newdb.table2 3: done! Hopefully we will have rename DB soon or a wildcard on the rename tables! Ken - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, July 08, 2001 9:38 AM Subject: use of RENAME??? [mysql] is this how to change the the name of an existing populated db? RENAME DATABASE old_name TO new_name; TR - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ERROR 2013: Lost connection to MySQL server during query
Hello, I'm getting the error message above whenever I try to connect from a remote host to a MySQL server. I issue the following command: mysql --host=host_name -u user_name -ppass_word and get the ERROR 2013 back as a response. We have two servers, both running MySQL. I get the same message going both ways. I have all the privileges set up properly. When I don't, I just get the host_name not set up for access message. I've duplicated the setup on our local LAN, and I connect with no problem. It is only our Web servers that are having this problem. We are only having this problem after our ISP moved our servers to a new, better network and gave us new IPs. The servers have been talking to each other with no problems for almost 1.5 years, but have not been able to since the move. I've updated the privilege information, but it appears that the client is not getting a complete response from the server. Any ideas on what to do to fix this? Troubleshooting clues? The request from the remote server is not showing up in the log; anyway I could capture this? I can telnet between the systems so I'm pretty sure the TCP/IP is working. MySQL versions are 3.22.27 on Linux RH 6.0 and 3.22.21 on Linux RH 5.2. The mysqld variables are set to their default except for max_allowed_packet, which has been increased to 10048512 on the 3.22.21 system in a vain attempt to solve the error. Thanks! Kurt Hansen [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: FFIRST TIME...MYSQL
on 7/9/01 8:07 AM, Anoop K Gupta at [EMAIL PROTECTED] wrote: 2. mysql -h mydomainname -u root -p it prompts for password : it is blank so I just pressed enter. and Mysql prompt appeared.. if there is no password, you don't need the -p switch -- mike cullerton - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Installinging MySQL on a virtual server
Ton Geurts wrote: Hi, I wonder I someone can give me some advice about the following situation. I have to install MySQL to be used with a website on a virtual server. This gives the following restraints: * MySQL must be installed in my user directory /usr/local/WWW/www.mydomain.com/mysql * I am only allowed to use the TCP/IP ports on the virutal host www.mydomain.com, not on the actual host. * I have no root access and cannot edit the startup scripts. * My provider uses BSDI BSD 4.0.1 as operating system on the host. Who has any clues for me? No problem. You can change all related paths in your .my.cnf file. Even better if you can compile MySQL and give command configure with flag prefix=/usr/local/WWW/www.mydomain.com/mysql to it, then MySQL will use all directories relative to this point. Because there is a more MySQL-s mabye running on same server, you can start server using --skip-networking flag. Then you still can use MySQL over socket ni your home directory. Only thing you cannot do without root access is having MySQL started when machine get rebooted. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Browser GUI
Try looking for phpMyAdmin: phpMyAdmin is intended to handle the adminstration of MySQL over the web. Currently it can: create and drop databases create, copy, drop and alter tables delete, edit and add fields execute any SQL-statement, even batch-queries manage keys on fields load text files into tables create and read dumps of tables export data to CSV values administer multiple servers and single databases http://www.phpwizard.net/projects/phpMyAdmin/ Pieter De Temmerman - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Migration from Access 2000 to my SQL
Bonjour Matthieu, I would also suggest installing MyODBC (from the downloads page). The you can just use SQL to create and populate new tables by setting up an database through ODBC. En autre si tu as l'intérêt il y a une liste de MySQL francophone à : S'abonner: [EMAIL PROTECTED] Amicalement, Ken - Original Message - From: Matthieu Neukirch [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 09, 2001 10:30 AM Subject: Migration from Access 2000 to my SQL Cordialement, We have made up our mind to turn our Access 2000 database into a MySGL one. Could you please explain us the path to follow and give us information about it ? Dominique Vellin Business developement Azentis Technology Your Outsourcing Provider Tel : 33 1 42 77 21 02 Mobile: 33 6 82 13 32 90 E-mail : [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re[2]: Migration from Access 2000 to my SQL
You find a list of converters on page http://www.mysql.com/downloads/contrib.html#SEC596 for example dbf2mysql-1.14.tar.gz Convert between `.dbf' files and MySQL tables exportsql.txt A script that is similar to access_to_mysql.txt, except that this one is fully configurable, has better type conversion (including detection of TIMESTAMP fields), provides warnings and suggestions while converting, quotes all special characters in text and binary data, and so on. It will also convert to mSQL v1 and v2, and is free of charge for anyone. See http://www.cynergi.net/exportsql/ for the latest version. By Pedro Freire, [EMAIL PROTECTED] NOTE: Doesn't work with Access2! Also under clients: Dbtools A tool to manage MySQL databases. Currently only for Windows. Some features: Manage servers, databases, tables, columns, indexes, and users Import wizard to import structure and data from MS Access, MS Excel, Dbase, FoxPro, Paradox, and ODBC Databases. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
PROPOUSE
Hello , I meet in share ver. of MySQL different lang. driver but no where UKRAINIAN. AND now I ask - I wont translete errmsg.txt and errmsg.sys for UKRAINIAN lang? Waiting for ansver! -- Best regards, suh mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Log files
Hello, I have a Question, 1. In which directory i can find the config file to config the log file 2. Where can i find the log file for mysql? regards, \\|// (@ @) ---oOO---(_)---OOo )( ( Krishna Manchikalapudi ) )( ( Mobile: 732-213-3103 ) ) Office: 732-817-1900 X:247 ( -- |__|__| || || ooO Ooo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
group by concat
Hi! My problem is when I use group by concat(col1,col2) when col1 and col2 is primary keys and col1 is varchar(255): SELECT col1,col2 FROM Table1 GROUP BY concat(col1,col2); - return only one row - it is bad SELECT col1,col2 FROM Table1 GROUP BY concat(col1,col1,col2); - return 48 rows - it is ok, but concat(col1,col1,col2) is stupid I change col1 to varchar(155): SELECT col1,col2 FROM Table1 GROUP BY concat(col1,col2); - return 48 rows - it is ok My platform: Linux x86, MySQL 3.23.39, table is myisam format. Is it bug or feature? Thanks Marek - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Initial setup in Linux RH7.0 (sorry)
Don't use the RPM in the 7.0 CD. Roberto Carlos Sánchez Barroso wrote: If somebody could help to, this is the message that is shown in the /va//lib/mysql/[domain server name].err 010704 11:07:58 mysqld started 010704 11:07:58 /usr/libexec/mysqld: Table 'mysql.host' doesn't exist 010704 11:07:58 /usr/libexec/mysqld: Normal shutdown 010704 11:07:58 mysqld ended Where could I create or find the mysql.host file? Thanks. Salu2. -Mensaje original- De: Roberto Carlos Sánchez Barroso [SMTP:[EMAIL PROTECTED]] Enviado el: miércoles 4 de julio de 2001 11:11 Para:'oyun' CC: '[EMAIL PROTECTED]' Asunto: RE: Initial setup in Linux RH7.1 Thanks, but my directory /var/lib/mysql owner´s already mysql. drwx-- mysql... -Mensaje original- De: oyun [SMTP:[EMAIL PROTECTED]] Enviado el: miércoles 4 de julio de 2001 11:06 Para: Roberto Carlos Sánchez Barroso Asunto: Re: Initial setup in Linux RH7.1 please reset you directory /var/lib/mysql/ privileges appropriately(owner must be mysql)...so that mysql can write the file mysql.sock into this directory when mysqld is running... - Original Message - From: Roberto Carlos Sánchez Barroso [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, July 04, 2001 3:52 PM Subject: RE: Initial setup in Linux RH7.1 I´ve got the same problem, installing mysql through RH7.0, Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' and i´m trying all the solves you post, but anything help me, could anybody post any other? Thanks. -Mensaje original- De: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Enviado el: martes 3 de julio de 2001 13:41 Para: [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Asunto: Re: Initial setup in Linux RH7.1 Yi-chen Lan [EMAIL PROTECTED] writes: When I try to run mysql, the system give an erroe message Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'. I checked the above directory and found out there is no such file 'mysql.sock'. Please help me to solve this problem. How did you try to start it? The correct way is service mysql start. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Field name LEFT and RIGHT
Hi, I need to create a table that have field names 'LEFT' and 'RIGHT'. I have tried the following but it doesn't work: CREATE TABLE WI_POSITION ( PICTUREFILE VARCHAR(200) NOT NULL, PICFILEXT VARCHAR(5), POSITIONNOVARCHAR(10) NOT NULL, SEQUENCENOVARCHAR(3), LEFT NUMERIC(4,0) NOT NULL, TOP NUMERIC(4,0) NOT NULL, RIGHT NUMERIC(4,0) NOT NULL, BOTTOMNUMERIC(4,0) NOT NULL, UNIQUE POSITION_XPK (PICTUREFILE,POSITIONNO,SEQUENCENO) ); and CREATE TABLE WI_POSITION ( PICTUREFILE VARCHAR(200) NOT NULL, PICFILEXT VARCHAR(5), POSITIONNOVARCHAR(10) NOT NULL, SEQUENCENOVARCHAR(3), LEFT NUMERIC(4,0) NOT NULL, TOP NUMERIC(4,0) NOT NULL, RIGHT NUMERIC(4,0) NOT NULL, BOTTOMNUMERIC(4,0) NOT NULL, UNIQUE POSITION_XPK (PICTUREFILE,POSITIONNO,SEQUENCENO) ); But nothing works. How should I do? Best regards Joacim Järkeborn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: LINUX Errors...
Thats a REALLY old version. Jon Brookes wrote: Hi, I have been using mysql fine on a win32 box.. but have now also installed it on Linux box. The version details are below: Red Hat Linux release 6.0 (Hedwig) Kernel 2.2.5-15smp I am using this version of mySQL: mysqladmin Ver 5.3 Distrib 3.20.32a, for pc-linux-gnu on i686 TCX Datakonsult AB, by Monty Server version 3.20.32a Protocol version9 Connection Localhost via UNIX socket TCP port3306 UNIX socket /var/lib/mysql/mysql.sock Uptime: 17 hours 9 min 15 sec I can log in as root no problem but some of the functions dont seem to be working. Check the following example: mysql use mysql; ERROR: parse error near 'use mysql' at line 1 Although if I login selecting the mySQL database and enter a SELECT statement it seems to work without any problems.. mysql select * from user; 2 rows in set (0.02 sec) +---+--+--+-+-+-+--- --+-+---+-+---+--+-- -+ | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete _priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | F ile_priv | +---+--+--+-+-+-+--- --+-+---+-+---+--+-- -+ | localhost | root | | Y | Y | Y | Y | Y | Y | Y | Y | Y| Y | | localhost | | | N | N | N | N | N | N | N | N | N| N | +---+--+--+-+-+-+--- --+-+---+-+---+--+-- -+ Or if I try to create a new DB from the monitor I get this error: mysql create database testdb; ERROR: parse error near 'database testdb' at line 1 But when I carry out the same task using mysqladmin it works fine: [root@monty mysql]# mysqladmin create testdb Database testdb created. I am assuming that the server is configured incorrectly in some way.. Any ideas would be greatly appreciated. Thanks, Jon. -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: linux-redhat 6.2
Bradley Jenkins wrote: i get this error when starting MySQL ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) /var/lib/mysql/mysql.sock exists with srwxrwxrwx and user mysql. I /var/lib/mysql at least mode 755? Brad. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Log files
For Unix /etc/my.cnf you then in the my.cnf say were you would like the logs! Simon -Original Message- From: Krishna M [mailto:[EMAIL PROTECTED]] Sent: 09 July 2001 16:27 To: [EMAIL PROTECTED] Subject: Log files Hello, I have a Question, 1. In which directory i can find the config file to config the log file 2. Where can i find the log file for mysql? regards, \\|// (@ @) ---oOO---(_)---OOo )( ( Krishna Manchikalapudi ) )( ( Mobile: 732-213-3103 ) ) Office: 732-817-1900 X:247 ( -- |__|__| || || ooO Ooo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Log files
1. In which directory i can find the config file to config the log file 2. Where can i find the log file for mysql? The log file will be in the data directory. In my case: /usr/local/mysql/var It has ending .err You can place my.cnf in this dir also and some other places. Check the manual or use the search box on http://mysql.com -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Need your helps!!!
i read somewhere that in version 4. or whatever one of the next versions will be, that they are talking about doing the ability for bi-directional replication. i have been trying to do the same thing - Original Message - From: Rolf Hopkins [EMAIL PROTECTED] To: Simon Green [EMAIL PROTECTED]; 'chen jun' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, July 09, 2001 6:33 AM Subject: Re: Need your helps!!! No. That link is about one way Replication. A main server with backup servers and if the main server dies, a backup can take over. What was asked was if any one server is updated, all others are updated. I'm also interested but I very much doubt it can be done because there is nothing in the manuals about this. - Original Message - From: Simon Green [EMAIL PROTECTED] To: 'chen jun' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, July 09, 2001 17:58 Subject: RE: Need your helps!!! Have a look http://www.mysql.com/doc/R/e/Replication_Implementation.htmlat It is all about what you would like to do. Simon -Original Message- From: chen jun [mailto:[EMAIL PROTECTED]] Sent: 09 July 2001 10:52 To: [EMAIL PROTECTED] Subject: Need your helps!!! Hi There: I want to establish several mysql servers which can synchronize data each other(if data of one server is updated,the others can be updated too). I don't know if it's done and how to do this. Need your helps. Regards, Jack - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: ERROR 2013: Lost connection to MySQL server during query
I had a similar problem recently. Try checking the /etc/hosts file to see if the hosts/IPs are matching the current config. Regards, Milos Rackov -Original Message- From: Kurt Hansen [mailto:[EMAIL PROTECTED]] Sent: Monday, July 09, 2001 4:58 PM To: [EMAIL PROTECTED] Subject: ERROR 2013: Lost connection to MySQL server during query Hello, I'm getting the error message above whenever I try to connect from a remote host to a MySQL server. I issue the following command: mysql --host=host_name -u user_name -ppass_word and get the ERROR 2013 back as a response. We have two servers, both running MySQL. I get the same message going both ways. I have all the privileges set up properly. When I don't, I just get the host_name not set up for access message. I've duplicated the setup on our local LAN, and I connect with no problem. It is only our Web servers that are having this problem. We are only having this problem after our ISP moved our servers to a new, better network and gave us new IPs. The servers have been talking to each other with no problems for almost 1.5 years, but have not been able to since the move. I've updated the privilege information, but it appears that the client is not getting a complete response from the server. Any ideas on what to do to fix this? Troubleshooting clues? The request from the remote server is not showing up in the log; anyway I could capture this? I can telnet between the systems so I'm pretty sure the TCP/IP is working. MySQL versions are 3.22.27 on Linux RH 6.0 and 3.22.21 on Linux RH 5.2. The mysqld variables are set to their default except for max_allowed_packet, which has been increased to 10048512 on the 3.22.21 system in a vain attempt to solve the error. Thanks! Kurt Hansen [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
LOCK while REPAIR?
I experience heavy trouble with a few tables and look for the cause for some time without finding out anything. I'm not ready to construct a bug report, though. Now I migrated these 3 tables from ISAM to MYISAM, so that I can CHECK TABLE from within the program and do a REPAIR TABLE when necessary. Am I correct in the assumption that I don't need a LOCK TABLE during CHECK TABLE, but otherwise during REPAIR TABLE? And if so, should I use a LOCK TABLE tbl_name WRITE? -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Field name LEFT and RIGHT
I need to create a table that have field names 'LEFT' and 'RIGHT'. I have tried the following but it doesn't work: See http://www.mysql.com/doc/R/e/Reserved_words.html Hint: use another laguage. In German, it is links and rechts for left and richt. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERROR 2013: Lost connection to MySQL server during query
Hi Milos, Thanks for responding! I had updated the /etc/hosts files already, but went and checked it after getting your message. Still no luck. Any other troubleshooting clues? Thanks! Kurt Hansen [EMAIL PROTECTED] - Original Message - From: Milos Rackov [EMAIL PROTECTED] To: Kurt Hansen [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, July 09, 2001 8:59 AM Subject: RE: ERROR 2013: Lost connection to MySQL server during query I had a similar problem recently. Try checking the /etc/hosts file to see if the hosts/IPs are matching the current config. Regards, Milos Rackov -Original Message- From: Kurt Hansen [mailto:[EMAIL PROTECTED]] Sent: Monday, July 09, 2001 4:58 PM To: [EMAIL PROTECTED] Subject: ERROR 2013: Lost connection to MySQL server during query Hello, I'm getting the error message above whenever I try to connect from a remote host to a MySQL server. I issue the following command: mysql --host=host_name -u user_name -ppass_word and get the ERROR 2013 back as a response. We have two servers, both running MySQL. I get the same message going both ways. I have all the privileges set up properly. When I don't, I just get the host_name not set up for access message. I've duplicated the setup on our local LAN, and I connect with no problem. It is only our Web servers that are having this problem. We are only having this problem after our ISP moved our servers to a new, better network and gave us new IPs. The servers have been talking to each other with no problems for almost 1.5 years, but have not been able to since the move. I've updated the privilege information, but it appears that the client is not getting a complete response from the server. Any ideas on what to do to fix this? Troubleshooting clues? The request from the remote server is not showing up in the log; anyway I could capture this? I can telnet between the systems so I'm pretty sure the TCP/IP is working. MySQL versions are 3.22.27 on Linux RH 6.0 and 3.22.21 on Linux RH 5.2. The mysqld variables are set to their default except for max_allowed_packet, which has been increased to 10048512 on the 3.22.21 system in a vain attempt to solve the error. Thanks! Kurt Hansen [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Field name LEFT and RIGHT
JJ I need to create a table that have field names 'LEFT' and JJ 'RIGHT'. I have tried the following but it doesn't work: JJ [..skip..] JJ But nothing works. How should I do? Rename 'left' and 'right' to something else. They are reserved words. -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- | Ilya Martynov (http://martynov.org/)| | GnuPG 1024D/323BDEE6 D7F7 561E 4C1D 8A15 8E80 E4AE BE1A 53EB 323B DEE6 | | AGAVA Software Company (http://www.agava.com/) | -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Testing MySQL 4.0
Hello On Tue, 19 Jun 2001, Sasha Pachev wrote: If you have a spare development system, plug in 4.0 binary and try to run your applications on it to see if it will crash. I just tried it on Debian GNU/Linux for i386 with up-to-date testing distro and up-to-date bk clone. The compile process fails on client/insert_test: , [ excerpt from make's output ] | /bin/sh ../libtool --mode=link gcc -O3 -DDBUG_OFF -rdynamic -o insert_test |insert_test.o ../libmysql/libmysqlclient.la -lz -lcrypt -lnsl -lm | gcc -O3 -DDBUG_OFF -rdynamic -o .libs/insert_test insert_test.o |../libmysql/.libs/libmysqlclient.so -lz -lcrypt -lnsl -lm -lz -lcrypt -lnsl -lm |-Wl,--rpath -Wl,/usr/local/mysql4/lib/mysql | insert_test.o: In function `main': | insert_test.o(.text+0x40): undefined reference to `mysql_connect' | collect2: ld returned 1 exit status ` Indeed, mysql_connect does not seem to exist in libmysqlclient: , [ nm ../libmysql/.libs/libmysqlclient.so | grep connect ] | 5e40 t connect2 | U connect@@GLIBC_2.0 | 7758 T mysql_real_connect | 8404 t mysql_reconnect ` Anyhow, if I go on with make in spite of this, the resulting mysqld, mysql and friends seem to be running just fine. :-) cheers -- TS - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
serious replication problem.
Hi everyone, Replication has been working OK for me for the last month or with mysql 3.23.38, however following a crash I am having a lot of problems. This is happening constantly: replication will work for a while and then stop with the following: mysql show slave status; | Master_Host | Master_User | Master_Port | Connect_retry | Log_File | | Pos | Slave_Running | Replicate_do_db | Replicate_ignore_db | Last_errno | |Last_error | | | Skip_counter | | unisondb1.internal.nw | repl| 3306| 60| |unisondb1-bin.001 | 20887103 | No| | || 1016 | error 'Can't open file: 'stories.MYD'. (errno: 145)' on query 'INSERT |into stories(issue_id,category_id,rank,story_content_id,dated,timed,valid_until) values('39','38','3','443498','2001-07-05','17:15:25','2001-07-15')' | 0| error 145 indicates that the table has a problem and needs to be repaired. However, I have no problem in running the sql manually! So, off I go and do a bunch of myisamchks on the table with every incantation I can think of, all showing no problems at all. I have tried going through the binlog on the master manually adding each bit of sql that fails (always on this one table) - which has worked before - and eventually the slave thread fires up again. Any ideas at all would be much appreciated. Many thanks, John. -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Importing a complete database
Hi Is it possible to import a complete database from a server to another one? Thanks Eugénio - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re[4]: Where to find options / my.cnf documentation?
Easy as can be: for example mysqld -O max_allowed_packet=2M Alas, it does not. It shows a couple of variable settings, but not the syntax for tha various logging options and the like. So the question for a complete options syntax of my.cnf remains open. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Easiest way to create a duplicate of a db?
For example if I want a copy of products named products1? Sincerely Victor query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problems with MyODBC
Hi Please visit the following link for the work around solution, else you can wait till the next release version of the MyODBC. http://lists.mysql.com/cgi-ez/ezmlm-cgi?9:mss:10849:200106:lglmnlcggpoehpijkfol Hope this helps you. Best Regards Venu Anuganti Mateusz Rudyk wrote: Hi. I have problems with MyODBC. I would like to use MyODBC with MonitorPRO software. During reading data from MySQL I got error: SQLBindParameter not used for all parameters I CAN'T change MonitorPRO software code - I need help with configuring MyODBC or another dirver (for Win NT). Please, help me. Best Regards Mateusz Rudyk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Venu Anuganti [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Redwood city, California USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql problem
I changed IP numbers on the Cobalt RAQ i have mysql on. I no longer have access to the databases. I think i have lost access as root. Is there a way to restore the root user password and/or change it to something else manually? I have many websites with many 'access denied' errors. Any help would be appreciated. Thanks, Kevin Robertson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Easiest way to create a duplicate of a db?
For example if I want a copy of products named products1? Sincerely Victor query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Importing a complete database
mysqldump databasename | gzip databasename.sql.gz transfer that file to the other server mysqladmin create databasename zcat databasename.sql.gz | mysql databasename Hi Is it possible to import a complete database from a server to another one? Thanks Eugénio - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Migrationfrom Access 2000 to MySQL
At 10:33 AM 7/9/01 +0200, Dominique Vellin wrote: We have made up our mind to turn our Access 2000 database into a MySGL one. Could you please explain us the path to follow and give us information about it ? Dominique Vellin Business developement I don't know how much this will help, but I've been using DBTools and it works for me. John Meyer [EMAIL PROTECTED] Programmer If we didn't have Microsoft, we'd have to blame ourselves for all of our programs crashing - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Importing a complete database
If both are using mySql, just use mysqldump to dump to a file and then import it from the file. It might be fun, just for grins and giggles to: mysqldump databasename mysql newDatabaseName and see if that works. Obligatory warning: if you do this and it trashes your server and wrecks your car, I was just kidding. Cal * * Cal Evans * Senior Internet Dreamer * http://www.calevans.com * - Original Message - From: Eugénio Veiga [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Monday, July 09, 2001 12:12 Subject: Importing a complete database Hi Is it possible to import a complete database from a server to another one? Thanks Eugénio - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Easiest way to create a duplicate of a db?
mysqldump products products.sql grep s/products/products1/ products.sql products1.sql mysql products1.sql Assuming that nothing else in the database is named products. (i.e. you don't have any fields or tables named products) If you did have fields or tables, you would most likely have to make the edits by hand to products.sql. or in keeping with my 'dangerous ideas' theme: mysqldump products | grep s/products/products1/ mysql (I am rusty on my regex so I'd check that s// expression before I used it) Cal * * Cal Evans * Senior Internet Dreamer * http://www.calevans.com * - Original Message - From: Victor Spång Arthursson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 09, 2001 12:35 Subject: Easiest way to create a duplicate of a db? For example if I want a copy of products named products1? Sincerely Victor query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Insert queries add TWO records to database
We saw a problem simlar to this caused by a browser add-on. I believe flyswat was behind it, but it was that quickclick browser add on that one of the tv networks is pushing. Mike On Wed, 4 Jul 2001 11:27:24 -0500 Rob Donat [EMAIL PROTECTED] wrote: Thanks for the note, I will determine if this applies to our situation. However I believe I found the solution to my problems to be apache related. I found that after upgrading to apache 1.3.20, MANY of our web server requests were duplicated some times tripled when using IE 5.5 (and presumably others, but not telnetting straight to port 80). This meant that the page would be loaded twice per actual request. This was a problem evident in the apache access_log (2 page executions per refresh) whether or not I hit the database (so possibly related to php but not to database (sybase) connectivity/functionality). I did not test this with non-php pages. This problem immediately went away when going back to apache 1.3.9 which is where we were at before upgrading to php4. Apache support states it is not a bug with apache, but with IE hasn't done anything about it. As for the mention below, I don't see the original code you're referencing, but I don't see why that would run twice. The first statement places the return value of the mysql_query command into the variable $res_insert_campaign -- NOT the entire executable command of mysql_query($sql,$conn). If later one evaluates that variable (if !$res_insert_campaign), there is no possibility it would re-run that command, since $res_insert_campaign, is a SCALAR VARIABLE, not something which knows anything about your mysql_query call. I think the double-row insertion problems people are experiencing are due to the double-running of each php command due to this odd apache issue. Thanks, Rob. -Original Message- From: Sebastiaan J.A. Kamp [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 04, 2001 6:21 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Insert queries add TWO records to database It's more of a PHP than a MySQL 'problem' certainly not a MySQL bug, but... Upon processing $res_insert_campaign=mysql_query($sql,$conn); the script will insert a line into your database. Then, upon evaluating if (!$res_insert_campaign) { it will do if (!mysql_query($sql,$conn)) and insert another line... Try being less 'indirect' about what you want: $sql = INSERT INTO Campaign (CampaignName,CampaignDesc,StartDate,EndDate,CompanyId,CampaignStatus,Admini stratorId) VALUES ('$name','$desc','$start_date','$end_date',$company_id,0,1); if (!mysql_query($sql,$conn);) { return false; } Regards, Sebastiaan J.A. Kamp Operating system: WinNT4 PHP version: 4.0.6 PHP Bug Type: MySQL related Bug description: Insert queries add TWO records to database All my insert queries seem to add two records to the database instead of one. I was using MS Access 2000 and did not have the problem. I am now using MySQL and all insert queries add 2 recs?! [...CUT...] A guy in the US seems to be having the same problem with Sybase. His details are: Rob Donat Sedonatech, Inc. 1735 W. Diversey Suite 521 Chicago, IL 60614 [EMAIL PROTECTED] 312-501-1200 cell 773-388-0271(2) office(fax) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Updating Random Records
Is there a way to update random records? I have a database of 5.6 million records and I want to pull out 5000 records and mark a field in the database that I've pulled these so that I don't pull the same 5000 again. I know I can select the records by doing: SELECT * FROM 5600k WHERE picked IS NULL ORDER BY rand() LIMIT 5000; But what I really want to do is: UPDATE 5600k SET picked=1 WHERE picked IS NULL ORDER BY rand() LIMIT 5000; Then doing: SELECT * FROM 5600k WHERE picked=1; Then resetting the table so I can pick a random selection again later: UPDATE 5600k SET picked=0 WHERE picked=1; So can the update statement be done to update random records? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Easiest way to create a duplicate of a db?
copy a table: mysqldump database table_name table.sql or to copy the whole db: mysqldump database db.sql - Original Message - From: Victor Spång Arthursson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 09, 2001 12:51 PM Subject: Easiest way to create a duplicate of a db? For example if I want a copy of products named products1? Sincerely Victor query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Unable to install mysql version 3.23.39a (min) on a Win2000P workstation.
I recently downloaded the latest MYSQL version 2.23.39a (from page http://www.mysql.com/downloads/mysql-3.23.39a.zip), and installed it as directed by the instructions: * install directory: c:/mysql, * datadir: c:/mysql/data, * and created the config file: c:/my.cnf (see below). When I typed to start mysql: mysqld --standalone, I got error (see below), and the DOS session hangs. My workstation is a Thinkpad 760ED, running Win2000 Professional, SP2. Please help. Error: Microsoft Windows 2000 [Version 5.00.2195] (C) Copyright 1985-2000 Microsoft Corp. U:\c: C:\cd mysql C:\mysqlcd bin C:\mysql\binmysqld --standalone Can't initialize InnoDB as 'innodb_data_file_path' is not set File: c:/my.cnf # Example mysql config file. # Copy this file to c:\my.cnf to set global options # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] #password=my_password password=my_password port=3306 #socket=MySQL socket=MySQL # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] port=3306 #socket=MySQL socket=MySQL skip-locking default-character-set=latin1 set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K set-variable = flush_time=1800 # Uncomment the following row if you move the MySQL distribution to another # location #basedir = d:/mysql/ basedir=c:/mysql/ datadir=c:/mysql/data/ [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key=16M [client_fltk] help_file= c:\mysql\sql_client\MySQL.help client_file= c:\mysql\MySQL.options history_length=20 database = test queries_root= c:\mysql\queries last_database_file= c:\mysql\lastdb Bin Dir: Directory of C:\mysql\bin 07/09/2001 11:59a DIR . 07/09/2001 11:59a DIR .. 06/13/2001 07:40p 1,101,824 mysqld-opt.exe 06/13/2001 08:10p 1,880,064 mysqld-max.exe 06/13/2001 07:15p 1,880,064 mysqld-max-nt.exe 06/13/2001 06:40p 1,101,824 mysqld-nt.exe 06/13/2001 01:55p 2,756,653 mysqld.exe 06/13/2001 08:54p 262,144 isamchk.exe 06/13/2001 08:51p 323,584 myisamchk.exe 06/13/2001 08:55p 253,952 myisamlog.exe 06/13/2001 08:43p 249,856 myisampack.exe 06/13/2001 06:25p 266,289 mysql.exe 06/13/2001 06:25p 229,376 mysqladmin.exe 06/13/2001 08:50p 208,896 mysqlbinlog.exe 10/30/1998 02:06a 334,712 mysqlc.exe 05/12/2001 01:13a 221,184 mysqlcheck.exe 06/13/2001 06:25p 229,376 mysqldump.exe 06/13/2001 06:25p 217,088 mysqlimport.exe 06/13/2001 06:26p 512,000 MySqlManager.exe 06/13/2001 06:26p 221,184 mysqlshow.exe 06/13/2001 08:48p 28,672 mysqlshutdown.exe 06/13/2001 08:49p 32,768 mysqlwatch.exe 06/13/2001 08:56p 217,088 pack_isam.exe 06/13/2001 08:58p 139,264 perror.exe 06/13/2001 06:28p 159,744 replace.exe 06/19/2000 03:51a 818 winmysqladmin.cnt 04/18/2001 08:18p 1,168,896 winmysqladmin.exe 06/19/2000 03:52a 1,856,816 WINMYSQLADMIN.HLP 26 File(s) 15,854,136 bytes 2 Dir(s) 108,232,704 bytes free C:\mysql\bin Regards, Dave Khuon Electronic Data Systems E.Solution 1900 Springer Road Lombard, Illinois, 60148 * +1 (312) 419-7984 (8*539) Fax +1 (312) 345-5057 (8*539) * [EMAIL PROTECTED] ...OLE_Obj... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Importing a complete database
Cal Evans wrote: If both are using mySql, just use mysqldump to dump to a file and then import it from the file. It might be fun, just for grins and giggles to: mysqldump databasename mysql newDatabaseName That should be: mysqladmin create newDatabaseName mysqldump --opt databasename | mysql newDatabaseName and see if that works. Obligatory warning: if you do this and it trashes your server and wrecks your car, I was just kidding. Cal * * Cal Evans * Senior Internet Dreamer * http://www.calevans.com * - Original Message - From: Eugénio Veiga [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Monday, July 09, 2001 12:12 Subject: Importing a complete database Hi Is it possible to import a complete database from a server to another one? Thanks Eugénio - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Dinstinct query
On 09-Jul-01 Daren Cotter wrote: I have two fields, sex, and age, which are both ENUM types. I'm building some statistical reports, using stuff like: DISTINCT(sex) ... GROUP BY sex ... and DISTINCT(age) ... GROUP BY age ... Now I want a report that shows me a breakdown by both categories, sex and age...so I can see not just how many m/f and 16-18 yr-olds, 19-24 yr-olds, etc, but how many of each sex in each age group. I've tried: DISTINCT(sex, age) ... GROUP BY sex, age But that doesn't work. Can someone help me out? Can I do this in one Query? distinct(term) ... group by (term) will always return one of each term, prolly not what you want. Select sex,age,count(*) as cnt from da_table GROUP BY sex, age; Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re[2]: Where to find options / my.cnf documentation?
At 6:41 PM +0200 7/9/01, Sascha Mantscheff wrote: Alas, it does not. It shows a couple of variable settings, but not the syntax Something that may be of help are the sample .cnf files that are included in: /usr/local/share/mysql/ (on my system at least) Look for my-small.cnf, my-big.cnf, my-huge.cnf, my-medium.cnf, my-large.cnf -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
file usage
Title: Blank I have found a large number of files which have names like this www-bin.040 www-bin.041 www-bin.042 www-bin.043 www-bin.044 which are using up huge amounts of disk space on my server. It looks to me like they are logs all of the queries that are run with a certain connection. Since my server averages just over 9 queries a second these logs are astronomical is size and they are also not necessary to me. Is there a way to get rid of this that any one knows of? Thanks Michael BloodMatraex Technologies[EMAIL PROTECTED]
Re[2]: Where to find options / my.cnf documentation?
At 5:10 PM +0200 7/9/01, Werner Stuerenburg wrote: It's so easy, you won't think of it: start mysqld with parameter -h (=help): mysqld -h shows all parameters and current settings Isn't that: mysqladmin variables -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Updating Random Records
I don't think this will work as you expect. You will have to mark those that you picked from those you haven't picked (and marked) before. SELECT * FROM 5600k WHERE picked IS NULL ORDER BY rand() LIMIT 5000; But what I really want to do is: UPDATE 5600k SET picked=1 WHERE picked IS NULL ORDER BY rand() LIMIT 5000; Then doing: SELECT * FROM 5600k WHERE picked=1; Then resetting the table so I can pick a random selection again later: UPDATE 5600k SET picked=0 WHERE picked=1; So can the update statement be done to update random records? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Regarding Use of Union in SQL statement
Hi, I wanted to take a union of two SQL queries for one of the front end screen. I searched help documents for UNION and did not find much. Do MySQL support UNION SQL statement? Thanks, Nutan Pandit Attronica Computers, Inc. 301-212-1355 (Ext 254) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Turning off logging for certain download queries
We do a few large daily and monthly downloads from an Oracle database server. Is there a way to exclude these specific queries from the update/binary log?? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Testing MySQL 4.0
On Monday 09 July 2001 10:51, Tibor Simko wrote: Hello On Tue, 19 Jun 2001, Sasha Pachev wrote: If you have a spare development system, plug in 4.0 binary and try to run your applications on it to see if it will crash. I just tried it on Debian GNU/Linux for i386 with up-to-date testing distro and up-to-date bk clone. The compile process fails on client/insert_test: , [ excerpt from make's output ] | /bin/sh ../libtool --mode=link gcc -O3 -DDBUG_OFF -rdynamic -o insert_test insert_test.o ../libmysql/libmysqlclient.la -lz -lcrypt -lnsl -lm | gcc -O3 -DDBUG_OFF -rdynamic -o .libs/insert_test insert_test.o ../libmysql/.libs/libmysqlclient.so -lz -lcrypt -lnsl -lm -lz -lcrypt -lnsl -lm -Wl,--rpath -Wl,/usr/local/mysql4/lib/mysql | insert_test.o: In function `main': | insert_test.o(.text+0x40): undefined reference to `mysql_connect' | collect2: ld returned 1 exit status ` Indeed, mysql_connect does not seem to exist in libmysqlclient: , [ nm ../libmysql/.libs/libmysqlclient.so | grep connect ] | 5e40 t connect2 | U connect@@GLIBC_2.0 | 7758 T mysql_real_connect | 8404 t mysql_reconnect ` Anyhow, if I go on with make in spite of this, the resulting mysqld, mysql and friends seem to be running just fine. :-) We will have this fixed shortly... It should be using mysql_real_connect() instead. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Announce: mytop 0.8 released...
On 08-Jul-01 Jeremy Zawodny wrote: mytop - a `top' clone for MySQL http://public.yahoo.com/~jzawodn/mytop/ Thanks Jeremy, been using 0.5 (FreeBSD ports). I've got a couple of spare hours coming up, mind if i take a whack at getting [mytop] into the my.cnf(s) files ? Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Announce: mytop 0.8 released...
On Mon, Jul 09, 2001 at 04:03:00PM -0500, Don Read wrote: On 08-Jul-01 Jeremy Zawodny wrote: mytop - a `top' clone for MySQL http://public.yahoo.com/~jzawodn/mytop/ Thanks Jeremy, been using 0.5 (FreeBSD ports). Oh, yeah. I forgot that someone made a port for it. Cool. :-) I've got a couple of spare hours coming up, mind if i take a whack at getting [mytop] into the my.cnf(s) files ? I've had something like that on the todo list for a while. A [mytop] section in the my.cnf files would seem like a great way to go. And the parsing should be easy. So, no, I don't mind at all. I'd love to have that. Thanks! Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 23 days, processed 177,477,637 queries (87/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how to improve query performance
Hi, I am pretty new to mySql. (In fact just built a databse and started working on it). I want to do keyword search on a column (clob). It may contain millions of records. How do I write query so that it is efficient. Thanks in advance for your time, Puru. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: file usage
Done, an email is now sent after an order is submitted. This is what it I have found a large number of files which have names like this www-bin.040 www-bin.041 www-bin.042 www-bin.043 www-bin.044 which are using up huge amounts of disk space on my server. It looks to me like they are logs all of the queries that are run with a certain connection. They are logs of all queries that are run which change data (UPDATEs, INSERTs, but not SELECTs) Since my server averages just over 9 queries a second these logs are astronomical is size and they are also not necessary to me. Heh, you should see how big they get on a server which averages 60 queries per second... Is there a way to get rid of this that any one knows of? Use the PURGE MASTER LOGS command (http://www.mysql.com/doc/R/e/Replication_SQL.html) to clean up old files, or disable binary logging (remove the line with log-bin in /etc/my.cnf), restart mysqld, then delete www-bin.* - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Turning off logging for certain download queries
We do a few large daily and monthly downloads from an Oracle database server. Is there a way to exclude these specific queries from the update/binary log?? If the queries only affect one table or database, use the replication ignore options listed here: http://www.mysql.com/doc/R/e/Replication_Options.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: binding to ips
sorry im a mysql newbie...how do you bind mysql to two particular ip addresses? i have it bound to my loopback but would like to bind it a private ip but it doesn't seem to like the bind-address directive more than once. Run two separate mysql daemons with a different --bind-address parameter for each one. Just make sure you don't use --skip-locking. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Regarding Use of Union in SQL statement
http://www.mysql.com/udmsearch/search.php?q=UNION finds 31 documents Sie schrieben am Montag, 9. Juli 2001, 22:17:49: Hi, I wanted to take a union of two SQL queries for one of the front end screen. I searched help documents for UNION and did not find much. Do MySQL support UNION SQL statement? Thanks, Nutan Pandit Attronica Computers, Inc. 301-212-1355 (Ext 254) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Turning off logging for certain download queries
On Mon, Jul 09, 2001 at 03:18:14PM -0600, Chris Bolt wrote: We do a few large daily and monthly downloads from an Oracle database server. Is there a way to exclude these specific queries from the update/binary log?? If the queries only affect one table or database, use the replication ignore options listed here: http://www.mysql.com/doc/R/e/Replication_Options.html Better yet, check this page: http://www.mysql.com/doc/R/e/Replication_SQL.html And look at SET SQL_LOG_BIN=0 Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 23 days, processed 177,648,797 queries (87/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php