Strange thing

On FreeBSD 5.3. MySQL 4.1.15 unix pipeline like mysqldump ... | mysql ... causes an auth error in the second command, even different databases are used. What does it mean? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

RE: mysql.sock gone

No errrs on the error log.. This is very weird... |-Original Message- |From: ? ??? [mailto:[EMAIL PROTECTED] |Sent: Wednesday, March 15, 2006 6:12 AM |To: Anton Krall; mysql@lists.mysql.com |Subject: Re: mysql.sock gone | |Look at mysql's error log ($MYSQL_DATA_DIR

mysql.sock gone

Guys. I just started having a problem, Im running mysql-standard-4.1.12-pc-linux-gnu-i686 binaries under Fedora Core 3 and Ive been having problem where during some parts of the day, /tmp/mysql.oskc goes away, I can still see mysql running when I do a ps ax but when I try to connect to it, it

RE: mysql.sock gone

No crons that would delete the tmp directory.. In fact, all the other files stay there... Just mysql.sock goes away... |-Original Message- |From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] |Sent: Tuesday, March 14, 2006 3:15 PM |To: Anton Krall; mysql@lists.mysql.com

Url http://highperformancemysql.com/

Hello, the URL http://highperformancemysql.com/ is mentioned in the online available chapter 7 of the book High Performance Mysql There should be tools on this website, but i see only a message from Infektion Group. What happened ? -- Anton Kornexl -- MySQL General Mailing List For list

EXISTS/NOT EXISTS

Hi, I'm trying to figure out how to apply these from the manual, but to no avail. Is it possible that my version (4.0.18) does not implement these? I have two tables: products and products_by_product_area. Both have a field product. I try SELECT product from products WHERE NOT EXISTS (SELECT

RE: EXISTS/NOT EXISTS

] Sent: Friday, June 18, 2004 2:38 PM To: Anton Ivanov Cc: [EMAIL PROTECTED] Subject: Re: EXISTS/NOT EXISTS Subqeries require mysql 4.1. The manual offers some suggestions on rewriting subqueries as JOINs http://dev.mysql.com/doc/mysql/en/Rewriting_subqueries.html. In your case, you want

Recover registers afected by UPDATE

I am crazy with a problem. I would like to know the best method to SELECT affected rows after an UPDATE. Thanks to all by your help. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Recover registers afected by UPDATE

Egor Egorov wrote: Francisco Ivan Anton Prieto [EMAIL PROTECTED] wrote: I am crazy with a problem. I would like to know the best method to SELECT affected rows after an UPDATE. If you set column values to the new (different from current value), you can just use the same WHERE clause

estonia charset and upper/lower case

Hello! When I run mysql with default-charset = estonia, it makes difference between upper and lower case. With latin1 charset no such distinction are made. Could someone clarify for me, is it bug? -- Lauri Anton ( [EMAIL PROTECTED] ) ( +3727302126 ) - estonia - Server version

RE: Selecting max value from sets

Slish, nu ti I nazvalsia, Egor Egorov, eshe bi Vasey Pupkinim nazvalsia-bi hahahahahaha ;-) Best Regards, Anton -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED]] Sent: Friday, January 10, 2003 9:38 AM To: [EMAIL PROTECTED] Subject: re: Selecting max value from sets

RE: Upgrading from MySQL 3.23.52 to 3.23.54

I don't' know if it was right to do, but I just downloaded version 3.23.54a and compiled/installed it Best Regards, Anton -Original Message- From: Peter Teo [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 05, 2003 8:08 PM To: [EMAIL PROTECTED] Subject: Upgrading from MySQL 3.23.52

RE: MySQL Help Needed Please

I have this file: srwxrwxrwx 1 mysql wheel0 Jan 2 16:45 mysql.sock I have two of .err files and non of the log files I also can't find my *.cnf file(s) Did: ps -ef | grep mysql Got nothing What should I do? Best Regards, Anton -Original Message- From: Thomas Spahni [mailto

RE: Russian in MySQL ?

I don't know about UTF-8, but most Russian web sites run Cyrillic Windows encoding or KOI8-R If you need some help with translation or writing on Russian using English characters let me know... Best Regards, Anton -Original Message- From: Paul Reilly [mailto:[EMAIL PROTECTED]] Sent

RE: Russian in MySQL ?

Yeah, that's what I meant to say ;-))) Best Regards, Anton -Original Message- From: Konstantin Sorokin [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 04, 2003 11:49 AM To: [EMAIL PROTECTED] Subject: Re: Russian in MySQL ? On Sat, Jan 04, 2003 at 11:17:41AM -0800, Anton Zavrin

RE: MySQL Help Needed Please

Did: ps -ef | grep mysqld got nothing Though I can do: # mysql -u root -p Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) # Anything else I should try :( ? Best Regards, Anton -Original Message- From: Stefan Hinz, iConnect (Berlin

RE: MySQL Help Needed Please

/usr/local/bin/safe_mysqld --user=mysql How do I re-point mysql to look for my old database, I guess that's the problem right? Thank you Stefan Best Regards, Anton -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: Saturday

MySQL Help Needed Please

of this upgrade, please re-build this port with the environment variable OVERWRITE_DB defined. *** Error code 1 Stop in /usr/ports/databases/mysql323-server. Please help, what should I do? Best Regards, Anton

fulltext search in boolean mode problems

'BOOLEAN MODE)' at line 1 Type of table is MyISAM. How to fix this problem ? Thanks. _ Anton Zabannikh - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

How to get data from MySQL with perl

How do I query a database with Perl - retrieve a item and then have that as a var to use in another insert statement Currently I have : Use DBI I define: my vars : host,db,username,password etc I create my db object etc I used the script to do a insert to my db and it worked fine - but I

MySQL not connecting over 110

info to assist me let me know what to supply. Anton - 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

RE: storing files in mySQL

Why not rather have pointers to the files on a directory and store this in a db field ? Saves you a lot of DB space ? Ant -Original Message- From: Dang Nguyen [mailto:[EMAIL PROTECTED]] Sent: 04 March 2002 09:05 To: Mysql List (E-mail) Subject: storing files in mySQL Hi everyone, I'd

Order of input into db

of records ? Anton - 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

FW: Urgent Business Assistance.

Dear Sir Unfortunatly too many people have already contacted me about this same mater, maybe you could rather say that you are a insurance broker that have to get rid of some policy money after this weeks miltary base explosion in your country, and that you urgently need to get out of the

ATT: Roger $ all : Re Data Sorting

don't support it ? Thanks for the help anyway - I'll post any success stories and solutions Anton - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Counting up numerical values in a table

Regards and thanks in advance Anton - 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

THNKS FOR HELP: Counting up numerical values in a table

Thanks for all the help with counting up numer. values. Thanks also to Richard, and Eskom for providing us the power to drive not only our PC's but also powering solutions to our DB problems ! ;-) Regards Anton (JHB, RSA) Richard Ellerbrock writes: select sum(colnam) as x from table

mysql_select_db() returns CR_COMMANDS_OUT_OF_SYNC

, 'OPTIMIZE TABLE MyTable'); . . . But the second call to mysql_select_db returns an error (commands out of sync). Why? After successfull optimization, are there any reasons for not changing the selected database? TIA, Anton Tichawa

RE: Weird Error Inserting

hi, MATCH is a reserved word. Try to rename your table. HTH. Anton Tichawa. -Original Message- From: Chris Aitken [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 1:09 PM To: [EMAIL PROTECTED] Subject: Weird Error Inserting

info

Hi , I am a student in TU-Munich , I need more information how is posible to instal MySQL , bekause I begin to learn PHP before 2 month :) Operation Sistem in TUM is Solaris end Linux(KDE). Tank You!!! - Before posting,

RE: Query Error

hi, try your first SELECT statement, but with ORDER BY table1.table1_row maybe this helps (I didnt try it). Anton Tichawa -Original Message- From: Bruno Faé [mailto:[EMAIL PROTECTED]] Sent: Monday, October 22, 2001 5:44 PM To: [EMAIL PROTECTED] Subject: Query Error Hi

RE: Import Data

Hi Riccardi, I want to import data from text file that contains decimal number (occasionaly with 9 decimal) but mysql import only 2 decimal. My columns is set to DECIMAL(6,9) Hi, Moreno try DECIMAL(15,9) because I think the first argument specifies the total number of digits. Anton

RE: Date interval problem

hello list, Michael Thygs is right, but the expression can be simplified. We have to assume that all dates are in correct order, i. e. for each date pair the following relation is true: from date = to date When a date range from tab1 does NOT overlap a date range from tab2, then the tab1

full-text search problem

this kind of text search on the server? thanks in advance Anton Tichawa - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

missing libcrypt_i.so.1 file

Hello All, When I check to running the mysql_install_db I have the error: root@gem:/usr/local/mysqlscripts/mysql_install_db ld.so.1: ./bin/my_print_defaults: fatal: libcrypt_i.so.1: open failed: No such file or directory Environment: System: SunOS gem 5.6 Generic_105181-23 sun4u