Re: Upgrade from 3.22 to 4.0

2003-09-08 Thread Egor Egorov
the database 'mysql'? Do you have databases directories and files of tables in these dirs? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ _

Re: reserved words and column titles

2003-09-05 Thread Egor Egorov
For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net

Re: Fulltext Index and Unicode (MySQL 4.1)

2003-09-05 Thread Egor Egorov
ef=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL Gen

Re: loading in grant tables

2003-09-04 Thread Egor Egorov
You should run script from the shell: http://www.mysql.com/doc/en/mysql_install_db.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ _

Re: how to change default data directory

2003-09-04 Thread Egor Egorov
d] datadir=/var1/lib/mysql -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /__

Re: Using multiple character sets (Russian & English)

2003-09-01 Thread Egor Egorov
an_word", "english_word"); You can do it as you wrote above :) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor E

Re: uniques, keys, etc?

2003-09-01 Thread Egor Egorov
.com/doc/en/ALTER_TABLE.html or CREATE INDEX command: http://www.mysql.com/doc/en/CREATE_INDEX.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ /

Re: How to upgrade to MySQL4.1-alpha

2003-08-29 Thread Egor Egorov
et http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: Full text searching

2003-08-28 Thread Egor Egorov
actualizadas| |0 | | 3 | dot contrato servicios Contrato sms | 0.50317577871617 | ++-+--+ -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ _

Re: utf8 support

2003-08-27 Thread Egor Egorov
a This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing

Re: Var/log/mysql/mysql.log

2003-08-27 Thread Egor Egorov
technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.ne

Re: own privileges

2003-08-27 Thread Egor Egorov
HOW GRANTS? > Every user can see his own grants. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/

Re: Difficulty with thai columns

2003-08-26 Thread Egor Egorov
on't execute SET CHARACTER SET utf8 then client character set is default (latin1). -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ _

Re: how to show all locks on a table?

2003-08-26 Thread Egor Egorov
Bennett Haselton <[EMAIL PROTECTED]> wrote: > At 03:49 PM 8/25/2003 +0300, Egor Egorov wrote: >>Bennett Haselton <[EMAIL PROTECTED]> wrote: >> > >> > I found a way to do this before, but I didn't write down how I did it, >> so I >> > don

Re: Difficulty with thai columns

2003-08-25 Thread Egor Egorov
-+---+ > 3 rows in set (0.00 sec) > > shows unrenderable characters for the Thai. > > So what do I do about this? > What is your client character set? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita Th

Re: Version 3.x tables with a new 4.0.x engine

2003-08-25 Thread Egor Egorov
. > > I am using MyISAM tables in both systems. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/

Re: utf8 support

2003-08-25 Thread Egor Egorov
character set. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___

Re: how to show all locks on a table?

2003-08-25 Thread Egor Egorov
t locks on a database table? > There is no command to show locks on the table. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov

Re: Setting up MySQL on Mac OS X

2003-08-22 Thread Egor Egorov
verride permissions, be root, or any of that stuff. Any hints? > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \

Re: How many records can a single MySql Table Hold.

2003-08-22 Thread Egor Egorov
y Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.my

Re: Problem installing MYSql 4.0.12 on MAC OSX 10.1.3

2003-08-21 Thread Egor Egorov
ended". > Does anyone know what the problem is ...?? Check error log. (You can find it in the MySQL data dir). -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ _

Re: mysqlbinlog wrong output

2003-08-20 Thread Egor Egorov
order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --

Re: punctuation limitation in fulltext search

2003-08-20 Thread Egor Egorov
_WORD" as entry word, not as a part of some word. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__

Re: bad data in mysql tables in replication server

2003-08-19 Thread Egor Egorov
is my replicant toast? > If you run myisamchk -r on the master, copy data from the master to the slave to make sure that master and slave have exactly the same data. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net ht

Re: mysqlbinlog wrong output

2003-08-19 Thread Egor Egorov
3 server binary logs. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\__

Re: punctuation in fulltext searching

2003-08-19 Thread Egor Egorov
EAN MODE. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ M

Re: Q: Delete subselect

2003-08-15 Thread Egor Egorov
sita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsub

Re: log-bin not created

2003-08-15 Thread Egor Egorov
p://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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 with inner join (Help!)

2003-08-15 Thread Egor Egorov
help me on this? SELECT Customers.Name, Customers.City, Orders.Product, Order.Price FROM Customers INNER JOIN Orders ON Customers.cust_id = Orders.cust_id WHERE cust_id = 2; -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by

Re: Redundant records in DataBase

2003-08-14 Thread Egor Egorov
key on those columns that should contain non-repeatable values and use mysqlimport with --ignore option. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ _

Re: innodb on delete cascade

2003-08-14 Thread Egor Egorov
-+--++-+ > 1 row in set (0.00 sec) > > mysql> select * from gene; > Empty set (0.00 sec) > > The entry from name should be deleted as well? Check if table types are InnoDB with SHOW CREATE TABLE or SHOW TABLE STA

Re: Transferring database from one PC to other

2003-08-14 Thread Egor Egorov
et http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/my

Re: relay-bin on master?

2003-08-14 Thread Egor Egorov
w to turn them off? Do you have file master.info in the data dir? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ /

Re: unable to run mysql_install_db please help

2003-08-14 Thread Egor Egorov
tch file. > > How can i run this line? You should not run mysql_install_db on Windows. Privileges table are created during installation. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___

Re: Problem renaming table

2003-08-14 Thread Egor Egorov
.mysql.com/documentation/index.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECT

Re: error when using avg( DISTINCT column)

2003-08-14 Thread Egor Egorov
technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net

Re: Dynamic enabling of log files

2003-08-14 Thread Egor Egorov
http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Running Total of a column on a SELECT

2003-08-14 Thread Egor Egorov
upport contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/

Re: fulltext key search

2003-08-14 Thread Egor Egorov
r.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --

Re: MySQL 3.23.54 + update

2003-08-14 Thread Egor Egorov
om/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL Genera

Re: Accessing Mysql after fresh installation

2003-08-14 Thread Egor Egorov
f=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http:/

Re: Random Errors in Replication Binlog

2003-08-14 Thread Egor Egorov
ew relay log?) No, MySQL doesn't truncate event when it creates a new relay log. Could you deascribe it more detailed? Which version of MySQL do you use? > > It would be nice if MySQL could be smart enough to reset it's master read > position to that poi

Re: upgrade

2003-08-14 Thread Egor Egorov
. How did you upgrade MySQL server? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/

Re: database per user

2003-08-14 Thread Egor Egorov
ita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing L

Re: InnoDB - mysqldump

2003-08-14 Thread Egor Egorov
=0 :) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/

Re: the logic of full text search

2003-08-11 Thread Egor Egorov
e no value to a search are ignored. >> >> I believe this is what's causing your problem. Do you have many records >> in the table you're doing a fulltext search on? IME it tends to work >> better with plenty of rows to work with. > &

Re: Can't set thread stack with ver 4.0.14

2003-08-06 Thread Egor Egorov
tack = 512K > > how to set with ver 4.0.14 [mysqld] thread_stack = 512K works like a charm. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/

Re: column privilege problem

2003-08-06 Thread Egor Egorov
blems granting table > privileges--just column. GRANT UPDATE(pass) ON practicedb.Acct TO 'JohnDoe'@'localhost'; -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___

Re: Creating Grant Tables on WinXP

2003-08-04 Thread Egor Egorov
vilege tables are created during installation on Windows. Use telnet to check if the server is up. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /

Re: mysql_history file?

2003-08-01 Thread Egor Egorov
l.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL Gene

Re: problems with mysql thru command line

2003-08-01 Thread Egor Egorov
me. Run it from MySQL /bin directory. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [E

Re: Problems Getting XP mysql server going

2003-08-01 Thread Egor Egorov
n ? Do you have any language=C:/mysqin/share/english/ entry in the my.ini? -- 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...

2003-08-01 Thread Egor Egorov
_37_2.frm' > (errno: 140) > > Why the above query is not working? Is there anything > wrong with the SQL? You can't create FULLTEXT index on the INT column. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This ema

Re: Selecting unique values:K@N@!:

2003-07-31 Thread Egor Egorov
to the all columns in the select list. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_

Re: mysqlMax vs mysql

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

Re: mysql on SMP CPU under RedHat

2003-07-29 Thread Egor Egorov
ttps://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.

Re: affected columns

2003-07-29 Thread Egor Egorov
nsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list ar

Re: mysqld stoped abnormally

2003-07-29 Thread Egor Egorov
.err file in datadir for the reasons of abnormal stop. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor E

Re: Access Denied

2003-07-25 Thread Egor Egorov
to https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com

Re: R: Replication stopped without reason

2003-07-25 Thread Egor Egorov
//order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --

Re: Relay_Log_File

2003-07-24 Thread Egor Egorov
his... You can find this info in the manual: http://www.mysql.com/doc/en/SHOW_SLAVE_STATUS.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/

Re: Retreiving image files

2003-07-24 Thread Egor Egorov
This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For

Re: Re-attaching DB to mysql

2003-07-24 Thread Egor Egorov
nsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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: ip address why shows diff. ?

2003-07-23 Thread Egor Egorov
3. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL

Re: how can I use a subnet mask to limit

2003-07-22 Thread Egor Egorov
rder.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL Gen

Re: Alpha 4.1-Temporary Tables-Alter/Update

2003-07-22 Thread Egor Egorov
they > alter/update it? Am I missing something? CREATE TEMPORARY TABLES privilege allows only create temporary tables. -- 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 definition

2003-07-22 Thread Egor Egorov
Michael Satterwhite <[EMAIL PROTECTED]> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On Monday 21 July 2003 04:14, Egor Egorov wrote: >> Michael Satterwhite <[EMAIL PROTECTED]> wrote: >> > I'm trying to add a foreign key to a ta

Re: Optimizer Penalty for using LIKE + ORDER BY + LIMIT ?

2003-07-22 Thread Egor Egorov
to verify if this has been > corrected in 4.1.0 because of the SSL library compatibility -- I presume you > are aware of the libcrypto.so.0.9.6 and libssl.so.0.9.6 issue. Show structures of your table, output of EXPLAIN for each SELECT. -- For technical support contracts, goto https://order.mys

Re: myslq.sock

2003-07-21 Thread Egor Egorov
by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.

Re: myisamchk -R

2003-07-21 Thread Egor Egorov
m/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mail

Re: replication problem

2003-07-21 Thread Egor Egorov
//order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --

Re: Foreign Key definition

2003-07-21 Thread Egor Egorov
TABLE statement. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\

Re: Deleting a database....

2003-07-18 Thread Egor Egorov
that the database in question has tables in it > while the other 2 that I created had nothing in them.. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /

Re: Jpg file insertion

2003-07-18 Thread Egor Egorov
-- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita

Re: link broken

2003-07-18 Thread Egor Egorov
ort contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net

Re: WG: wait_timeout in my.cnf

2003-07-18 Thread Egor Egorov
nteractive mode. In this case value for 'wait_timeout' is taken from 'interactive_timeout' variable. > > Moritz > > > -Urspr?ngliche Nachricht- > Von: Egor Egorov [mailto:[EMAIL PROTECTED] > Gesendet: Freitag, 18. Juli 2003 10:16 > An: [EMA

Re: WG: wait_timeout in my.cnf

2003-07-18 Thread Egor Egorov
On Wednesday 16 July 2003 16:10, Moritz Steiner wrote: > Like this: > > # The number of seconds the server waits for activity on a connection > # before closing it > wait_timeout= 300 Set interactive_timeout=300, too. > > -Urspr?ngliche Nachricht---

Re: Another mysql config help...

2003-07-17 Thread Egor Egorov
I am trying touse the > command line to first set myname up and after I finish that, I will be > using PHPMYADMIN to do more admin stuff. The easy way to add new user or to give some premissions to the user is usage of GRANT statement. -- For technical support contracts,

Re: Question again : mysql.sock

2003-07-17 Thread Egor Egorov
he place for the socket file from >> > "socket=/var/lib/mysql/mysql.sock" to "socket=/tmp/mysql.sock". >> > That doesn?t work. > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita

Re: MySQL Config

2003-07-17 Thread Egor Egorov
nical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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: Question again : mysql.sock

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

Re: query

2003-07-16 Thread Egor Egorov
o I need a result as follow > id age > 2 6 > 4 8 > 6 4 SELECT t1.* FROM t1 LEFT JOIN t2 ON t1.age=t2.age WHERE t2.age IS NULL; -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita

Re: Problems compiling Mysql in Alpha with Tru64Unix V5.1

2003-07-16 Thread Egor Egorov
not GNU one. >Can help me > Julio Rocha -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / //

Re: Connection problem!!! Windows to Linux

2003-07-16 Thread Egor Egorov
put of SHOW GRANTS for this user. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL P

Re: Simple newbie question - CURTIME()

2003-07-16 Thread Egor Egorov
der.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com

Re: WG: wait_timeout in my.cnf

2003-07-16 Thread Egor Egorov
orks. How did you set the wait_timeout variable? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PR

Re: Weird Temp File Issue

2003-07-15 Thread Egor Egorov
e some help! These files are temporary table files. Also MySQL server creates temporary tables for some SQL statement. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___

Re: Fw: check

2003-07-15 Thread Egor Egorov
"Alex82" <[EMAIL PROTECTED]> wrote: > so what can i do to make a column accetp only certain values...there are any > other solutions? Check values in your application. > - Original Message - > From: "Egor Egorov" <[EMAIL PROTECTED]> > To: &l

Re: simple group by taking way too long..

2003-07-14 Thread Egor Egorov
--+-+ Do you have indexes in the table 'tbe1'? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /

Re: check

2003-07-14 Thread Egor Egorov
0.12 version CHECK clause does nothing. It's just parsed. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /

Re: delete across multiple tables problem

2003-07-14 Thread Egor Egorov
E.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\

Re: Complex select statement

2003-07-11 Thread Egor Egorov
m/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing

Re: Encrypt().

2003-07-11 Thread Egor Egorov
r system. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQ

Re: post installation problem

2003-07-11 Thread Egor Egorov
./bin/mysqld_safe from dir /var/lib Look into error log file in the MySQL data dir. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /

Re: PHP multiple SQL statements

2003-07-11 Thread Egor Egorov
; > SELECT * from tmp; > DROP TABLE tmp;"; > > $res = mysql_query($sql); > > _ > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___

Re: getting in trouble with multiple insert...

2003-07-10 Thread Egor Egorov
to https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.c

Re: Slow batch load after 500MB

2003-07-10 Thread Egor Egorov
l.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL

Re: MySQL performance question..

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

Re: Error compile mysql-3.23.51

2003-07-10 Thread Egor Egorov
compile by yourself, take prebuilt binaries - compiling correctly under Linux is tricky. > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /

Re: InnoDB: Operating system error number 13 in a file operation

2003-07-09 Thread Egor Egorov
permissions on the directory and file. Error 13 means "Permission denied". -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Eg

<    3   4   5   6   7   8   9   10   11   12   >