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.
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:
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
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
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 *.*
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
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:
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
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
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]
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
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,
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
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
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
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
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
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
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,
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
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
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
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,
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
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
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
[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
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
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
[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
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
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
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
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
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
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
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
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';
38 matches
Mail list logo