Re: table corruption with certain (valid) insert statements

ad it, the resulting table is > OK. Thank you for bug report. It was entered to the bug database: http://bugs.mysql.com/bug.php?id=1977 -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___

Re: Soundex in text searches

ts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net

Re: datetime ORDER BY is erred

technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.n

Re: Error 2002 egroka

tarting & stopping services, but you > should have a script: /etc/init.d/mysql ( or something like that ). > Try: > > /etc/init.d/mysql start > > That's what starts it on mine anyway. > -- For technical support contracts, goto https://order.mysql.co

Re: Linux access question

using version 3.22 It's too old version. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMA

Re: can't find FULLTEXT index

ur table structure and query, please. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / /

Re: MySQL 4.1.1 Download

ita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mys

Re: Error 2002

jeepcreep <[EMAIL PROTECTED]> wrote: > > I did and it is not running. Look into error log file. You can find causes why MySQL server doesn't start. > > Victoria Reznichenko <[EMAIL PROTECTED]> wrote:jeepcreep wrote: >> >> That is what I did. > &

Re: INSERT INTO FROM same table failing

> > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /_

Re: Bug in 4.1.1 Internationalization on Windows2000 ?

MUST BE > cp1251 !!! >character_set_clientcp1251 >character_set_connectioncp1251 >character_set_resultscp1251 > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponso

Re: MySQL -- Sequences -- Do they exist

sored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archi

Re: MySQL 4.1.1 create table : why negatives values need quotation marks?

s entered to the bug database: http://bugs.mysql.com/bug.php?id=2075 -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznich

Re: Locks dont lock

t; LOCK TABLE .. READ allows other threads read from the table. As for LOCK TABLE .. WRITE .. do you use QUERY CACHE? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ __

Re: foreign keys.

, >> FOREIGN KEY (FOO_ID) REFERENCES foo(ID) >> ) TYPE=INNODB; > > Thanks, but I just did, and I got the same error message. > Paul's example works fine for me. What version of MySQL do you use? -- For technical support contracts, goto https://order.mysql.com/?ref=

Re: NOT EXISTS

//order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com

Re: foreign keys.

; >>KEY(Fname,Lname), #here this one--if it does not work,its not me >> >> >FOREIGN KEY (FOO_ID) REFERENCES foo(ID), >> >FOREIGN KEY (Fname, Lname) REFERENCES Blah (Fname, Lname) >> > ) TYPE=INNODB; >> -- For t

Re: 'Sum' syntax

SQL syntax near '(id), pet from visits > group by pet' at line 1 Remove space between 'sum' and bracket. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __

Re: Fw: Bug in 4.1.1 Internationalization on Windows2000 ?

atin1 >> */ | >> > +--+ >> --+ >> >> Seems, there is dependence on current database charset and, IMHO, it's a >> bug. >> It's not a bug. character_set_databa

Re: foreign keys.

TYPE=INNODB; > ERROR 1005: Can't create table './moftest/foo.frm' (errno: 150) > What is version of MySQL server? What default-character-set do you use? > > On Tue, 16 Dec 2003 07:54 pm, Victoria Reznichenko wrote: >> Mofeed Shahin <[EMAIL PROTECTED]&g

Re: Fw: Bug in 4.1.1 Internationalization on Windows2000 ?

p866, gui in cp1251) >2.2. it's my local troubles (english win 2 with ciryllic charset) >2.3 it's mysql troubles (system charset utf8, mysql charset cp1251). NB. > in .frm I see all my enums in selected charset. I think, there is > '

Re: How to Uninstall Mysql

y Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to execute a file in mysql prompt

sql http://www.mysql.com/doc/en/mysql.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__

Re: How to Uninstall Mysql

02: Can't connect to local MySQL server through socket > '/var/lib/mysql/mysql.sock' (2) > > It's confusing for me. > Please guide me step by step to use mysql in this case. I tried to go through > documentation but bit difficult to understand for newbe

Re: GRANT CREATE/DROP

---+ > 2 rows in set (0.00 sec) > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /

Re: Weird bug in MySQL?

_NONBLOCK) = 0 > setsockopt(320, SOL_IP, IP_TOS, [8], 4) = 0 > setsockopt(320, SOL_TCP, TCP_NODELAY, [1], 4) = 0 > > The 10.0.0.x connects are from our web servers. Wish I could've seen > what killed off all of the threads. > > Nothing in the logs. > > So, anyone have

Re: Delete items which aren't present in another table?

oto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <

Re: mysql 5.0.0 error when creating a stored procedure

ade tables: http://www.mysql.com/doc/en/Upgrading-grant-tables.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \

Re: PROBLEMS WITH DELETE

what is going on? What version of MySQL do you use? ORDER BY in DELETE statement is supported from v4.0.0. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __

Re: revoke and set password syntax

have? Show your REVOKE and SET PASSWORD statements. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [

Re: myISAM to innodb

-- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MyS

Re: MYSQL Aborting

14:35:53 mysqld: Shutdown Complete > > Can anyone help or tell me what might be going wrong? Check directory of the database 'mysql'. Do you have privilege table files there? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored

Re: Problem with LPAD() function

set (0.00 sec) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net

Re: Problem creating sp

ht syntax to use near > deli > meter | > create function hello (s char(20)) returns char(50) > return concat('H' at line 1 > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___

Re: Foreign key contraints, on delete cascade not working?

-+---+ > 1 row in set (0.00 sec) > > But I still must ask: Why is that? How do I turn it on? > Do you use 3.23.xx version? You should install MySQL-Max binary if you want to use InnoDB: http://www.mysql.com/doc/en/InnoDB_in_MySQL_3.23.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: COMP_ERR is missing in windows binary distribution zip file of 4.1.1a

This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing

Re: Foreign key contraints, on delete cascade not working?

Andrew DeFaria <[EMAIL PROTECTED]> wrote: > Victoria Reznichenko wrote: > >> Andrew DeFaria <[EMAIL PROTECTED]> wrote: >>> As you can see I when I delete from user (the parent table) the >>> useropts (child table) entry remains. Shouldn't it be de

Re: Problem with LPAD() function

anks for report! It's a known bug: http://bugs.mysql.com/bug.php?id=2182 > > Thanks > Emery > - Original Message - > From: "Victoria Reznichenko" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, January 12, 2004 12:36 > Sub

Re: mysqlimport question

ontracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysq

Re: enum version info

ical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\

Re: table info

ical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/

Re: table info

t specific table, you can just do: SHOW TABLE STATUS LIKE 'table_name'; > > > >>From: Victoria Reznichenko <[EMAIL PROTECTED]> >>To: [EMAIL PROTECTED] >>Subject: Re: table info >>Date: Mon, 19 Jan 2004 14:10:37 +0200 >> >>"

Re: 4.1.1 not an update or upgrade of 4.1.0

omes empty (on 4.1.1) while > it comes with rows with 4.1.0 and no error is returned!!! Works fine for me. Could you send me a test case? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___

Re: [mysql 5.0, connection loss, procedure-related, easy to reproduce, detailed report] what you ever wanted to know about trees

g query > mysql> > -- > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/

Re: default character set

t http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Strange problem with index

;t know what to do. > Please, upload gzipped dump and insert query to the ftp://support.mysql.com/pub/mysql/Incoming and let me know a filename. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___

Re: default character set

Kittiphum Worachat <[EMAIL PROTECTED]> wrote: > Victoria Reznichenko wrote: >>Kittiphum Worachat <[EMAIL PROTECTED]> wrote: >>>Try to set character set to other not latin1 with MySQL 5 (windows >>>binary) it not work can some one tell me how to do this. &

Re: default character set

Kittiphum Worachat <[EMAIL PROTECTED]> wrote: > Victoria Reznichenko wrote: >>Starts fine for me from command line: >> >>C:\mysql\bin>mysqld-nt.exe --default-character-set=tis620 --standalone --console >>040122 14:36:50 InnoDB: Started; log sequence numbe

Re: (Left) Join and Union

.. FROM (SELECT .. FROM tableA UNION SELECT .. FROM tableB) AS result_table LEFT JOIN tableC ON .. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/

Re: MYSQL Security

http://www.mysql.com/doc/en/Privilege_system.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\

Re: InnoDB on delete, on update

goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/

Re: tables_priv not read after restarting server

BLES, LOCK TABLES ON *.* TO > 'some_user'@'localhost' IDENTIFIED BY PASSWORD > '*43933BDF3E95B05EC8BE52E6AEE83DB1B1E309CA' | > | GRANT SELECT ON `some_db`.* TO 'some_user'@'localhost' > | > +

Re: 4.1.1-alpha: ... DEFAULT -1 ... does not work

s://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Create Table

- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mys

Re: ORDER BY may remove result rows

t; This bug is entered to the bug database: http://bugs.mysql.com/bug.php?id=2419 Not fixed yet. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __

Re: Please help with "check" syntax

othing in MySQL: http://www.mysql.com/doc/en/CREATE_TABLE.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Query time out during login over network

mit with mysql_options(). Users of 4.0.15 on Windows should upgrade to avoid this problem. http://www.mysql.com/doc/en/News-4.0.16.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___

Re: Create users : with password

> > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > mysql> > > > Any ideas what I'm doing wrong? You added user [EMAIL PROTECTED] without password, but connected using test1 user name. Seems you have entry for anonymous us

Re: max key length 500 in myisam index

a This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL 5 Stored Procedures are server wide?

- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___

Re: MySQL 5 Stored Procedures are server wide?

d be db specific :-) Yes, you can. In a future they will be database specific. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenk

Re: MySQL 5 Stored Procedures are server wide?

answer. Can I expect procedures/functions >> > to be database specific in the future? Or will they stay server-wide? >> > IMO, they should be db specific :-) >> >> Yes, you can. In a future they will be database specific. > > Good. Thanks. >

Re: Specific Max File Size Allow

sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For l

Re: Copy Data to Remote Box

https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ w

Re: mysql 4.1.1 negative default column values doesn't work

contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net

Re: Insert with multiple value lists

goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net &l

Re: primary key - user entered/auto increment

sec) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\

Re: Version 4.1.2. when?

sita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL Genera

Re: WHERE NOT EXISTS

ical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com

Re: Stored procedures

ou can't do it with ALTER PROCEDURE. Only DROP procedure and then CREATE a new one. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Victoria Rez

Re: FLUSH error

support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com

Re: Myisampack missing from 4.1.1 Win32 binaries

ssed? You are right, myisampack is missing from 4.1.1 installer binary package. It will be fixed in the next release. Thank you! -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ /

Re: question about replication

'yes', > > What could be possibly wrong or what shall I do to make the database updating? What replication options do you use? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/

Re: ERROR 1005 at line 12: Can't create table

Y_CHECKS = 0; SOURCE dump_file; SET FOREIGN_KEY_CHECKS = 1; -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Victoria R

Re: question about replication

formation > on this. Do you use any replicate-* options? What is the output of SHOW PROCESSLIST command on the slave? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __

Re: Collation and LONGBLOB fields

LT CHARSET=latin1 COLLATE=latin1_german2_ci 1 row in set (0.00 sec) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznich

Re: ERROR 1005 at line 12: Can't create table

"naveen" <[EMAIL PROTECTED]> wrote: > thanks Victoria Reznichenko > > for your help > where will i put this parameter > SET FOREIGN_KEY_CHECKS = 0; > in the dump file or under mysql pormpt.I added through mysql but still the > same error comes. You should put

Re: Replication and Binary Logging

ur my.cnf file is located? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ /

Re: question for replication

replicated: USE some_other_db; INSERT INTO db_name.table_name VALUES(..); Do you specify database name explicitly in the queries? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___

Re: Collation and LONGBLOB fields

ow in set (0.00 sec) > Thank you for bug report! -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ /

Re: Safe Database Problem

ABASES. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___

Re: FOEIGN KEY

) -> ) TYPE=InnoDB; Query OK, 0 rows affected (0.00 sec) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__

Re: Strange behavior with IF?

For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.n

Re: ib* files in /var/lib/mysql

ete these files and run MySQL server with --skip-innodb option. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenk

Re: FOEIGN KEY

column in the multiple-column primary key. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [E

Re: mySQL SQL Conversion

ort contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net

Re: Bug in subqueries?

ntered to the bug database as bug #2838: http://bugs.mysql.com/bug.php?id=2838 Thanks for bug report! -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/

Re: Where is my typo?

T ALL ON *.* TO [EMAIL PROTECTED]; -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL

Re: mysqlcc syntax file?

ile in the General Configuration Dialog window. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__

Re: If Exists update else insert

s, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <_

Re: Subselect in aggregate function in MySQL 4.1.1a-alpha

//order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysq

Re: Foreign Key Problems

oscott' > 2 'twobenjamin' > > > > Problem is when I delete from one where id =3D '1' it does not delete = > the foreign key one in table two. > Check type of the tables with SHOW CREATE TABLE or SHOW TABLE STATUS statements. I guess they have MyISAM

Re: delete/replace character on column

ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --

Re: how setting default for SQL_SELECT_LIMIT ?

om/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com

Re: Problems with subquery and 'not in'

e this behavior. Please, upload them to ftp.mysql.com:/pub/mysql/Incoming and let me know file names. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Help - Problem in using UNION???

ug??? Your version of MySQL doesn't support UNION. UNION is implemented in MySQL 4.0.0. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /

Re: Problem trying to start mysqld_safe

causes of failed start. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL

Re: [4.1.1] 1062 errors on non-unique index during data load

d > [snip] > Could you create repeatable test case (table structure (output of SHOW CREATE TABLE) and text file with data that will be enough to reproduce the above behavior)? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.n

Re: Concat. operator ||

ation=SERIALIZABLE .. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net

Re: install problem

ql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql

Re: install problem

re detailed instruction you can find at: http://www.mysql.com/doc/en/Resetting_permissions.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ _

  1   2   3   4   5   6   7   8   9   10   >