Re: Default connection codepage

Hello. That is my my.ini snip (my.ini is located in MySQL base dir - is that correct?): On Windows, MySQL programs read startup options from the following files: WINDIR\my.ini C:\my.cnf Use --defaults-file=/path/ command line option to specify the exact location of my.ini file.

Re: Mysql upgrade problem 3.23 to 4.1

Hello. The password hashing mechanism was updated in MySQL 4.1 to provide better security and to reduce the risk of passwords being intercepted. Use OLD_PASSWORD() instead of PASSWORD. See: http://dev.mysql.com/doc/mysql/en/Password_hashing.html Jerry Swanson [EMAIL PROTECTED] wrote:

Re: LOAD DATA INFILE

Goutham Thanks for your help. The problem in this case was line endings. I use an Apple g4 for web work on system 10.2. By default BBEdit uses macintosh line endings. MySQL does not recognize them. As soon as I changed the textfile format to unix line endings, it imported the data without any

Re: How to use character_set_xxx in my.ini ?

Hello. Put this string into [client] section of my.ini. Zimoo [EMAIL PROTECTED] wrote: Hello Gleb, Sunday, December 19, 2004, 10:02:58 PM, you wrote: Also you can put in your [client] section of my.cnf something like: default_character_set=gbk I use my.ini in MySQL

Re: Regarding User creation and loading data

Hello. What error have you got? Send us compete command that you issued and the error message. Could any one of you help me in creating two users like First user with all dba privileges as root and the Second user with only dml operations. For root user use: grant all privileges on *.*

Re: Unique IDs

with implicit join : INSERT into table1(id, list of other columns) select m.newID, list of other columns from table2, tmpIDMAP where m.id = table2.id UPDATE table3, tmpIDMAP SET table3.parentID = m.newID where m.id = table3.parentID Andrew Mull wrote: Thank you. I'll have to review the SQL

RE: Regarding User creation and loading data

Hi, Thank you for your reply. When I log in as a DBA user and try to load data from a file, I am getting an error as Access Denied, so, here I want to know what type of permissions I have to give for a user to load data infile form a file. Thanks, Narasimha -Original Message- From:

updates after restart MySQL 4.0.18

Hi everyone, Our server crashed the Two questions : 1) is it normal to have a dramatic amount of UPDATES after a MySQL restart after crash ? 2) how to get valuable information from the following? ; Crash from 20/12/04 at 20.10(?) from server.err : mysqld got signal 11; This could be because

Re: MySQL tweaking.

On Tue, 21 Dec 2004 15:16:02 -0700 Sasha Pachev [EMAIL PROTECTED] wrote: The hardware you have is just fine. But start thinking about a clustered solution. As the traffic increases, you eventually reach a point where no hardware is good enough on one box. Hi, Thankyou for your reply. I

Re: Restore help! been going 2 weeks

Those are pretty much standard settings I had ours set almost exactly like that, and performance was worse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysqldump and innodb - set foreign_key_checks=0

Terence, - Original Message - From: Terence [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Wednesday, December 22, 2004 5:58 AM Subject: mysqldump and innodb - set foreign_key_checks=0 Hi, After reading the docs I realise that in order to use mysqldump with innodb tables i

RE: Regarding User creation and loading data

use root user of mysql. u wont get any privilege restrictions with root user. other wise the user you are using should have file privilege to load data from file or to write to a file Thanks Anil -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday,

RE: Restore help! been going 2 weeks

ours is InnoDB. we are not getting any performance problems with the settings. it is working fine since last 1 Year. to my knowledge due to myisam type you are getting performance issue. Thanks Anil -Original Message- From: matt_lists [mailto:[EMAIL PROTECTED] Sent: Wednesday, December

Re: [Fwd: Re: MUTIPLY function?]

Alex, you are correct. That particular formula cannot handle ANY non-positive number because the LOG() function is undefined for values less than or equal to zero. I just reviewed the archives and realized that this point has never been discussed before (I thought it had). Good catch. In

RE: mysqldump and innodb - set foreign_key_checks=0

just write the below lines of code to a file in the location where your mysqldump file exists SET FOREIGN_KEY_CHECKS = 0; SOURCE dumpfile name; SET FOREIGN_KEY_CHECKS = 1; then execute the following command mysql filename Thanks Anil DBA -Original Message- From: Heikki Tuuri

RE: myql command-line no warning

after executing command. use the below command to know the warnings it is throwing mysql show warnings; Thanks Anil -Original Message- From: Qunfeng [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 22, 2004 10:45 AM To: Paul DuBois; mysql@lists.mysql.com Subject: Re: myql

RE: Need more info about currently running queries

may be due to corrupted indexes it is taking long time. just re-org the table.if your table is InnoDB type then use below command to re-org it. mysql alter table table name type=InnoDB; based on size of the table it may execute for long time . for us it has solved performance issue. Thanks

Error when reading back dump file.

Hi, I am using the cygwin version of the mysql client. When trying to read back my dump file into the database, I get this error [EMAIL PROTECTED]:/cygdrive/c/Program Files/mysql/data 23:15$ ../bin/mysql.exe -h 10.224.3.3 -u root -p testdb -e ./zztest.sql Enter password: ERROR

Re: Restore help! been going 2 weeks

Anil Doppalapudi wrote: ours is InnoDB. we are not getting any performance problems with the settings. it is working fine since last 1 Year. to my knowledge due to myisam type you are getting performance issue. Thanks Anil based on this email list, myisam is prefered for heavy query/index use,

Re: duplicate key with back slash character in the key?

Does your code properly escape the backslash character as it writes to the database? IF you are NOT using 'cn=abc\\, def, ou=accounts' in your INSERT and UPDATE statements, you will get values that look like 'cn=abc, def, ou=accounts' in your data. Without actual data, actual statements, a few

Re: Error when reading back dump file.

The -e parameter is intended to allow you to directly execute a SQL statement. In this case the SQL statement you tried to execute was ./zztest.sql which is not valid SQL. You need to use the redirector to tell mysql to use the file you name as an input source. 23:15$ ../bin/mysql.exe -h

verbose

can anyone tell me about what verbose mode mean? is it Uppercase or Lower case matter or something with backtick? By the way what do backslash for in mysql query? Thanx guys __ Do you Yahoo!? Yahoo! Mail - You care about security. So

Fulltext + order by strategy

Hi there, Is there any common strategy (of using indexes) to avoid filesorts while sorting searches by a field ? Eg. I want fulltext search, then sort results by some other table field. For example .: create table article ( id int not null primary key auto_increment, sort1 int not null,

Calculating User Ranks (SQL Query Question)

Im trying to come up with a more efficient method to do this. I have a table where people enter some info into the table. The more entries they add the more points they get. (1 point per entry). I would like to allow the users to be able to see where they stand rank wise with everyone else. Right

Re: Calculating User Ranks (SQL Query Question)

Try this: CREATE TEMPORARY TABLE tmpRankings ( Rank int auto_increment, entries int, user_id int ) INSERT tmpRankings (points, user_id) SELECT count(1), user_id FROM sometablenamehere GROUP BY user_id ORDER BY entries DESC; This way the tmpRankings table contains an

Re: Fulltext + order by strategy

Since you are already splitting your data into fulltext columns and other data I would keep that design. Others on the list have greatly improved their performance by running their tables in this same fashion. If by some chance your non-fulltext columns are all fixed width, there is another

Re: [Fwd: Re: MUTIPLY function?]

[EMAIL PROTECTED] wrote: Michael Stassen wrote: EXP(SUM(LOG(COALESCE(*the field you want to multiply*,1))) which works because LOG(xy) = LOG(x) + LOG(y), and EXP(LOG(x)) = x. Hence, sum of the logs = log of the product, so exp of the sum of the logs = exp of the log of the product = the

CRITICAL BUG in 4.1: innodb_file_per_table can corrupt secondary indexes

Hi! http://bugs.mysql.com/bug.php?id=7496 A critical bug found: if one uses the 4.1 my.cnf option innodb_file_per_table to create tables, and some of the secondary index records are inserted to the InnoDB 'insert buffer', then after a normal mysqld shutdown InnoDB loses all those secondary index

last_insert_id() and load data infile

Hi, I am trying to find in the manual what select last_insert_id() will return after a load data infile command is executed. From my experiments, it returns the id of the FIRST record in the file, I would have expected the LAST, but that is not the case. Is that documented somewhere? Can I

Re: Fulltext + order by strategy

[EMAIL PROTECTED] wrote: Since you are already splitting your data into fulltext columns and other data I would keep that design. Others on the list have greatly improved their performance by running their tables in this same fashion. If by some chance your non-fulltext columns are all fixed

MySQL inadvertently messing with the path in the Windows' registry?

Hello. After installing the latest GA (Generally Available) version, 4.1.8, of the MySQL Server [1] on my Windows XP SP2 system, I noticed something strange with the PATH environment variable. Upon opening a command prompt window, I could not directly execute any of the usual applications

Copying DB and full-text search files from one server to another

Is it possible to copy the database files (both MyISAM and InnoDB) that contain tables, indices, and full-text indices from one MySQL server to another running/active MySQL server and start using them right away? I appreciate your help! Homam

simple subquery syntax not working!

I have read through quite a bit of the MySQL manual concerning subqueries and cannot seem to get even the simplist of queries to work! I have a table called PersonRole which is the many-to-many joint table between two upper tables, Person and Role. I have tested the two pieces of the query

Re: simple subquery syntax not working!

Make sure the subquery returns a scalar value. Either the roleDBNum column has to be unique or you need to apply an aggregate function to reduce to a single value. If the the subquery returns many values, use the IN operator instead of =. Disclaimier: I'm still new to MySQL, but I'm assuming it

RE: simple subquery syntax not working!

Hi Renee, Check the version of your MySQL. The subqueries feature is available from MySQL 4.1 Hope this helps you. - Harish -Original Message- From: Renee Henderson [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 6:17 AM To: mysql@lists.mysql.com Subject: simple subquery

Re: MySQL inadvertently messing with the path in the Windows' registry?

Ney André de Mello Zunino wrote: I will post again, if I find any conclusive evidence. I have just obtained that conclusive evidence. The MySQL installer is indeed messing up the type of the /Path/ value on the registry, changing it from REG_EXPAND_SZ to REG_SZ. The problem will only take place

scanning 2 rows slow index fast 26GB MyISAM

I am experiencing extreme slowness performing a query in which 2 rows are returned hanging in the sending data status. Performing an index only query such as SELECT COUNT(*) is extremely quick so I know the only extra step is retrieving the data from the MYD. I am looking for thoughts on why

Access deined for user 'root@sales'

I'm running v 4.0.22 on Win XP 2003 Server with a client running XP Pro. I have mysql running on 192.168.0.8 and I want to administer it from 192.168.0.202 (aka SALES). While on 192.168.0.8 running mysql, I issued the following commands: mysql GRANT ALL ON *.* TO 'root'@'192.168.0.22';