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:http://lists.mysql.com/
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_DAT
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
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 says
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 Lis
]
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, yo
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
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
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]
new table "change". Later, your Java application can look periodical in
this table for changes (after looking, you delete the read record).
Anton
-Ursprungliche Nachricht-
Von: Sashi Ramaswamy [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 6. Januar 2004 17:20
An: [EMAIL PROTECTED]
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
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
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
Done /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:
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, i
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 Z
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]]
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 [m
- re-load your data
If you understand the consequences 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
SQL syntax near '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.
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
can
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
Hi, if I need to do multiple INSERTS (I mean into different tables) which is
the best way to manage this? Do I have to run a different Query for each
INSERT ? Or is there a faster & better way to do it.
Thanks.
-
Before posting
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
t 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 unsu
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
country
k('xx');
>Fix:
on the slave: set sql_slave_skip_counter=1 ; slave start
>Submitter-Id:
>Originator:Anton kornexl
>Organization:
Universitaet Passau
>MySQL support: email support
>Synopsis: Bug in Replication
>Severity: serious
>Priority: m
hat my version) just
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.
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 fr
e value.
Does this make sense
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,
_query(sql, '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?
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, pl
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
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]
> Subje
l number of digits.
Anton Tichawa.
-
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]>
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 ran
Is
there, or will there be, a way to do 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/
Hello All,
When I check to running the mysql_install_db I have the error:
root@gem:/usr/local/mysql>scripts/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 sp
potential customers with an existing table called "keys" that we cannot rename,
but want to migrate from Sybase to mysql.
BTW, I've only tried using the Windows version 3.23.36
Regards,
Anton.
-
Before posting, p
---
---+
Why there is so many threads with "Locked" or "Copying to tmp table" state ?
How to solve this problem ?
__
Anton Zabannikh | http:
40 matches
Mail list logo
