On Sun, 4 Sep 2005, Alexey Polyakov wrote:
Why do you choose to convert varchar to tinytext? Doesn't look like
good idea to me.
trailing spaces and mysql 4.x
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-
Hello.
Have you run 'FLUSH PRIVILEGES'?
[EMAIL PROTECTED] wrote:
On Sun, Sep 04, 2005 at 10:08:32PM -0400, [EMAIL PROTECTED] wrote:
Now I have all the users in the new mysql.user table. But when I try
to login, the same credentials do not work.
A bit more info on this. This
Hello.
At first, we should ensure that most time query is spending in the
ordering of the results. What state is SHOW PROCESSLIST reporting
for this query?
Michael Monashev [EMAIL PROTECTED] wrote:
Hello
GP And MySQL uses a filesort algorithm.
How to make the filesort
Hello.
Are you sure that the logging isn't enabled in a different way.
For possible ways to enable logs see:
http://dev.mysql.com/doc/mysql/en/program-options.html
What version of MySQL are you running?
T. Horsnell [EMAIL PROTECTED] wrote:
Someone kindly replied to my log query
Hello.
Maybe this could help you somehow:
http://bugs.mysql.com/bug.php?id=12191
Check that you are running the latest release.
Nico Grubert [EMAIL PROTECTED] wrote:
Hi there,
I am running MySQL 4.1 on Linux.
I have some problems sorting records with german umlauts.
Hello.
If you think that it is possible to have several records with the same
post and title, then, in my opinion, your table should have two indexes for
foreign key constraints and one AUTO_INCREMENT field for primary key.
mysql show create table titles_posts\G;
Hello.
Please, start a new thread when you're asking a different question.
In my opinion, it is safer to restore an archive into the datadir
of 4.0.23 server. Then perform a dump using mysqldump utility
and finally import it to the new 5.x instance. I suggest you to
read this page before
Hello.
I'm not familiar with this subject, however, have you been at:
http://dev.mysql.com/doc/mysql/en/howto-cf.html
http://dev.mysql.com/doc/mysql/en/programs-known-to-work-with-myodbc.html
http://dev.mysql.com/doc/mysql/en/myodbc-tested-applications.html
Hello.
When I suggested to create a trace file, I wanted to find the place
where mysqld hangs. In my opinion, it is possible. You should
research the last entries at the end of the trace file (using tail,
for example) after mysql has hung. I'm not sure if we are able to find
any clues in
Hello
GP What state is SHOW PROCESSLIST reporting for this query?
Fulltext initialization
Sincerely,
Michael,
http://xoib.com/ http://3d2f.com/
http://qaix.com/ http://ryxi.com/
http://gyxe.com/ http://gyxu.com/
http://xywe.com/ http://xyqe.com/
--
MySQL General Mailing List
For
pissed
I would like someone from MySQL AB to clarify issue with SCO asap. I
wouldn't like to use technologies for my business that later could be
used against me (in legal sense). Does MySQL AB understand that it helps
funding their legal cases against us (GPL users) ? If someone feels OK
Hi,
Ok. Is there a way to get a timestamp in the file too? If
this happens while I'm not near a machine I want to make sure I can
find the right time frame in the file.
Thanks, Tuc
Hello.
When I suggested to create a trace file, I wanted to find the place
where
__
Mirza [EMAIL PROTECTED] wrote on 05/09/2005 14:31:12:
pissed
I would like someone from MySQL AB to clarify issue with SCO asap. I
wouldn't like to use technologies for my business that later could be
used against me (in legal sense). Does MySQL AB understand that it
I have created a table, sfyc and as root I issued the following:
grant all on * to todd identified by 'my_password' with grant option;
However, todd cannot access sfyc with
mysql -u todd -p sfyc
And the mysql db contains the following:
user table
+---+--+
| host | user |
Hi all,
We have a problem with our mysql 4.1.11 system. It has been working well
since the installation, we only have one problem. In the case of certain
selects, it always stop with Sort aborted error. To the client it
returns errors like ERROR 3 (HY000): Error writing file
Did you run the statement witht he mysql database as the current
database? If so , you're statement probably got converted to this:
grant all on mysql.* to todd identified by 'my_password' with grant option;
It seems like a logical thing
The grant statement applying to all databases/tables
Hello.
grant all on * to todd identified by 'my_password' with grant option;
May be you wanted '*.*' instead of '*'? See:
grant all on *.* to todd identified by 'my_password' with grant option;
mysql -u todd -p sfyc
You should specify the database name not a table name
Hello.
Fulltext initialization
Ok, now we exactly know that we should optimize the FULLTEXT part
of your query. I don't know the options which directly affects the speed
of the FULLTEXT searches, so I suggest you to play with key_buffer and
table structure. The ratio of Key_reads to
Hello.
I don't know. You may want to hack MySQL source (it seems not
too hard to change the dbug/dbug.c file). As an alternative you can
make a feature request at:
http://bugs.mysql.com
In my opinion, timestamp is a helpful thing (however, it may affect the
performance which is already
Chris et al -
The MySQL online manual does show *.* to be used for global priviledges,
but my MySQL book only used the *. My mistake! However, the online
manual does not indicate (or I am missing it) what the use of * grants.
Thank you for the help...it is now working and my DB, sfyc does
Hello.
I don't know. You may want to hack MySQL source (it seems not
too hard to change the dbug/dbug.c file). As an alternative you can
make a feature request at:
http://bugs.mysql.com
Done. Thank you.
In my opinion, timestamp is a helpful thing (however, it may affect the
To test the char vs byte index I created a unique bcol(2), on a tiny text
utf8 field.
I then preceded to insert the numbers 00..99 in Chinese whose hex values
are below. Since we are using utf8 vs ucs2 they are going to be 3 bytes
per char, totaling 6 bytes per numbers.
If the index is
Hello,
First all it is not recommended at all to dump and
import user information.
Secondly the user authentication system has changed
between 4.0 and 4.1 so old passwords from 4.0 wont
work. Its given in the docs.
Thirdly, MySQL does not store the actual password in
its database. It always
I have been using SQLyog's ODBC Import tool for quite
some time now.
http://www.webyog.com
Karam
--- Nguyen, Phong [EMAIL PROTECTED] wrote:
Look at http://www.ispirer.com
It is free and very good tool to do it. I did it
from Oracle to MySQL, but
you can do it from Mysql to oracle. Good
On Mon, Sep 05, 2005 at 12:41:50PM +0300, Gleb Paharenko wrote:
Hello.
Have you run 'FLUSH PRIVILEGES'?
Doh! I got everything else find, but forgot something stupid.
Murphy's law, I suppose.
Thanks for the prompt!
Ross
--
MySQL General Mailing List
For list archives:
On Mon, Sep 05, 2005 at 11:00:43AM -0700, Karam Chand wrote:
First all it is not recommended at all to dump and
import user information.
Why not? They are just entries in a database, like any other. How
would you propose I move a large batch of users to another database
server?
Secondly
Here is the official link:
http://www.sco.com/products/openserver6/mysql.html
SCO states that they will distribute MySQL with a commercial license.
According to this they do not plan to stick with GPL...
Bye
Bgs
[EMAIL PROTECTED] wrote:
__
Mirza [EMAIL PROTECTED] wrote
Mirza wrote:
pissed
I would like someone from MySQL AB to clarify issue with SCO asap. I
wouldn't like to use technologies for my business that later could be
used against me (in legal sense). Does MySQL AB understand that it
helps funding their legal cases against us (GPL users) ? If
On Sep 5, 2005, at 3:10 PM, Daniel Kasak wrote:
This is the part that gets me:
As part of the agreement, the companies will work together on a
range of joint marketing, sales, training, business development
and support programs that will benefit customers throughout the
Americas,
You guys should subscribe to the Planet MySQL RSS feed. The entire issue
was cleared up there by a member of the MySQL AB staff.
http://www.planetmysql.org/
Rich Allen wrote:
On Sep 5, 2005, at 3:10 PM, Daniel Kasak wrote:
This is the part that gets me:
As part of the agreement, the
Hi there.
I am looking for the syntax to lock individual records in an InnoDB table.
I can't seem to find anything outside of locking full tables.
Any urls out there?
Cheers
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
something along the lines of:
mysql select * from table where column = value lock in share mode
On Sep 5, 2005, at 4:01 PM, Rich wrote:
Hi there.
I am looking for the syntax to lock individual records in an InnoDB
table.
I can't seem to find anything outside of locking full tables.
Schalk Neethling wrote:
You guys should subscribe to the Planet MySQL RSS feed. The entire
issue was cleared up there by a member of the MySQL AB staff.
http://www.planetmysql.org/
The argument is given that this is all about helping out the SCO users.
A counter argument is that by doing
MySQL General List,
Server specifications:
MySQL 4.1.3-beta, phpMyAdmin 2.5.7-pl1, PHP 4.3.8
My specifications:
MySQL beginner, PHP intermediate, HTML and CSS advanced.
The situation:
I have a database of users for my web site, in which all the text
data that is inserted
34 matches
Mail list logo