Hello.
There are numerous bugs in MySQL Administrator (but mostly closed)
where the key word is 'profile'. If necessary, you can access the source
repository and build the latest available version, including the bugfix,
yourself. More information about accessing the source trees is
no,you do not need to modify anything,it just because utf8 which phpmyadmin2.6
default setting conflict with mysql's latin1,so just copy a set of phpmyadmin
2.5.5,and install the mysql 4.1 as default,and every will be ok,that's all.
王静 [EMAIL PROTECTED] 写道:hi all.
Here is the suituation. i've
Hi,
Recently had a few problems with comparing numbers stored in text mysql fields
char(2), which I
solved by chnging the field to int(1)
Now my question is why do you sometimes appear to get away with this?
--
zzapper
Success for Techies and Vim,Zsh tips
http://SuccessTheory.com/
--
MySQL
zzapper wrote:
Hi,
Recently had a few problems with comparing numbers stored in text
mysql fields char(2), which I solved by chnging the field to int(1)
Now my question is why do you sometimes appear to get away with
this?
My guess is that if the numbers are of the same length (number of
On Wed, 12 Oct 2005 13:27:52 +0200, wrote:
zzapper wrote:
Hi,
Recently had a few problems with comparing numbers stored in text
mysql fields char(2), which I solved by chnging the field to int(1)
Now my question is why do you sometimes appear to get away with
this?
My guess is that if the
I'm sorry, my mistake. The type definition is
*nloc_num,ins_numero and ins_digi are decimal(5,0)
2005/10/11, Luciano Centeno [EMAIL PROTECTED]:
hello, my friends, the query option 1 return the right value,
the query option 2 not. Why concat function make the difference?
*nloc_num,ins_numero
Hello,
could someone help me please to construct correct query or tell me what I'm
doing wrong?
I have three tables:
table products
table products_codes where some products could have assigned another additional
codes
table products_prices
I want to get all rows from product_prices listed
Hi, I am trying to restore from an .sql file created by mysqldump.
To restore I am using mysqldump as well.
I deleted all of the rows in a table.
When I restore it is still empty.
I noticed on my screen that the dump does inserts but the restore does not.
I am using the -c option.
Can
John Doneker wrote:
Hi, I am trying to restore from an .sql file created by mysqldump.
To restore I am using mysqldump as well.
I deleted all of the rows in a table.
When I restore it is still empty.
I noticed on my screen that the dump does inserts but the restore does not.
I am using the -c
Just rebuilt one of my servers and when setting up MySQL again an old
problem I'd had and worked around came up again.
Why is it that if I grant a user@'%' permissions, that user can access
the database from any other machine on the network, but that same user
logon accessing the db from the
Dušan Pavlica wrote:
Hello,
could someone help me please to construct correct query or tell me what I'm
doing wrong?
I have three tables:
table products
table products_codes where some products could have assigned another additional codes
table products_prices
I want to get all rows from
John Doneker [EMAIL PROTECTED] wrote on 10/11/2005 04:43:40
PM:
Hi, I am trying to restore from an .sql file created by mysqldump.
To restore I am using mysqldump as well.
I deleted all of the rows in a table.
When I restore it is still empty.
I noticed on my screen that the dump does
Jeff [EMAIL PROTECTED] wrote on 10/12/2005 08:43:16 AM:
Just rebuilt one of my servers and when setting up MySQL again an old
problem I'd had and worked around came up again.
Why is it that if I grant a user@'%' permissions, that user can access
the database from any other machine on the
I've downloaded the MySQL Admin 1.1 freeware tool to backup a mysql database.
It works fine except that the timer doesn't work. When I set a time in the
'time' field, lets say 8:00, the backup never kicks off.
Is this because this free software doesn't supply this functionality? Or could
it
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Due to the complexity of my query I don't know how to get this down to a
simple test case to demonstrate the error.
This works under mysql 4.1.8 btw, so it is failing due to a change
introduced recently. It also worked under mysql 5.0.9, but I
Thanks, Michal, for your help.
Your query works as I need.
I tried to use same syntax as in MS Access, but results are for some reason
different for this query. I'm working on application which should be able to
connect to MySQL or to MSAccess (users' choice) and I didn't want to write
If you open your terminal, you'll see some error messages waiting for you.
Apparently it's buggy. I turned off my admin backups.
Cheers
John Doneker:
Is this because this free software doesn't supply this functionality? Or could
it be a bug? Is there another answer?
--
MySQL General
Shawn,
Thanks again for responding :o)
All understood, it seems to me though that this is achieved when you
create the user by specifying where the specific user can login from.
So granting permissions to user@'%' means from anywhere while
[EMAIL PROTECTED] means only when they access from that
Hi:
I was visiting the Aspect Oriented Software Development (AOSD) -Europe
Workshop 2005 website,
(http://www.aosd-europe.net/workshop-web/discussions.html) especially the
discusion area. There, I read the following:
What is the state of application of AOSD especially in industry?
The exact
James Black [EMAIL PROTECTED] wrote on 10/12/2005 09:57:51 AM:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Due to the complexity of my query I don't know how to get this down to a
simple test case to demonstrate the error.
This works under mysql 4.1.8 btw, so it is failing due to a
Hi all,
This may be a simple solution that I'm just not seeing. logrotate has
trouble with binlogs since the extension keeps changing, so instead of
actually rotating logs out, I just get a dir filled with
binlog.001.1
binlog.002.1
binlog.003.1
binlog.004.1
binlog.005.1
binlog.006.1
and on
Dušan Pavlica [EMAIL PROTECTED] wrote on 10/12/2005 10:00:53 AM:
Thanks, Michal, for your help.
Your query works as I need.
I tried to use same syntax as in MS Access, but results are for some
reason
different for this query. I'm working on application which should be
able to
connect to
Hello,
Is it possible for a MySQL connection to request a downgrade in privileges?
What I'd like to be able to do is create one database user account for a
database application with read and write privileges to the tables, but if
an application user logs in who only has read access, then to
Hi,
How is the sintax to in my.cnf listen only to specified ip-addresses or
ip-ranges? I tried:
bind_address 127.0.0.1 192.168.0.10 192.168.0.20
and
bind_address 127.0.0.1, 192.168.0.10, 192.168.0.20
and
bind_address 127.0.0.1 192
bind_address 192.168.0.10
bind_address 192.168.0.20
Non of them
Kristen G. Thorson wrote:
Hi all,
This may be a simple solution that I'm just not seeing. logrotate has
trouble with binlogs since the extension keeps changing, so instead of
actually rotating logs out, I just get a dir filled with
binlog.001.1
binlog.002.1
binlog.003.1
binlog.004.1
Jon,
hmm... maybe one of the indexes inevitably is in a random order.
Please post a typical
SHOW INNODB STATUS\G
when the inserts happen slowly.
What is your my.cnf like?
Regards,
Heikki
Innobase/Oracle
- Alkuperäinen viesti -
Lähettäjä: Jon Frisby [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote on 10/12/2005 10:56:43 AM:
Hello,
Is it possible for a MySQL connection to request a downgrade in
privileges?
What I'd like to be able to do is create one database user account for a
database application with read and write privileges to the tables, but
if
[EMAIL PROTECTED] writes:
Is it possible for a MySQL connection to request a downgrade in
privileges? What I'd like to be able to do is create one database
user account for a database application with read and write
privileges to the tables, but if an application user logs in who
only has
James,
You can reproduce that error by writing ...
SELECT ...
FROM a, b INNER JOIN c ON a.x=c.y
The error goes away if you instead write ...
SELECT ...
FROM b, a INNER JOIN c ON A.x=c.y
so you might try swapping
FROM items i
, nams.netids n
PB
-
[EMAIL PROTECTED] wrote:
What you describe is how I have it set up today. My thoughts on the matter
are that it makes more sense to maintain a single SQL user account for the
application with on password to manage, rather than two or three or four,
and then allow that SQL user, when the connection is made, what
hello,
does anybody knows the error:
can't create table '.\Cherry\#sql-288_5d.frm'
(errno:150)
it happens when i try to create foreign keys in
Table1, and that foreign key is actually primary key
in Table2 (to which i relate my foreign key)
Thanx a lot!
Tatjana
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Fernando Asteasuain wrote:
Hi:
I was visiting the Aspect Oriented Software Development (AOSD) -Europe
Workshop 2005 website,
(http://www.aosd-europe.net/workshop-web/discussions.html) especially the
discusion area. There, I read the
You are correct in that each mysql user account only has one set of
permissions. Your application talks to the database and it may only need
one login. One login = one set of permissions. When I am designing a
web-based application, I always create at least two accounts. One will be
read-only,
Tatjana Cukic [EMAIL PROTECTED] wrote on 10/12/2005 12:28:47 PM:
hello,
does anybody knows the error:
can't create table '.\Cherry\#sql-288_5d.frm'
(errno:150)
it happens when i try to create foreign keys in
Table1, and that foreign key is actually primary key
in Table2 (to which i
[EMAIL PROTECTED] wrote on 10/12/2005 10:46:46 AM:
You are correct in that each mysql user account only has one set of
permissions. Your application talks to the database and it may only
need one login. One login = one set of permissions. When I am
designing a web-based application, I
Thanks por answering Mark!
By the way, how do you know that JDBC driver uses AspectJ?
I´ve vissited several jdbc web sites and i didn´t find this information.
Quoting Mark Matthews [EMAIL PROTECTED]:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Fernando Asteasuain wrote:
Hi:
I
probablemente por que mark es el manager del desarrollo de software de
conectividad para Mysql...entre ellos jdbc.. :-)
Saludos,
Alvaro Avello.
Fernando Asteasuain wrote:
Thanks por answering Mark!
By the way, how do you know that JDBC driver uses AspectJ?
I´ve vissited several jdbc web
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Fernando Asteasuain wrote:
Thanks por answering Mark!
By the way, how do you know that JDBC driver uses AspectJ?
I´ve vissited several jdbc web sites and i didn´t find this information.
Fernando,
Because I write/maintain the JDBC driver for
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Peter Brawley wrote:
James,
You can reproduce that error by writing ...
SELECT ...
FROM a, b INNER JOIN c ON a.x=c.y
The error goes away if you instead write ...
SELECT ...
FROM b, a INNER JOIN c ON A.x=c.y
I will try it.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Peter Brawley wrote:
James,
You can reproduce that error by writing ...
SELECT ...
FROM a, b INNER JOIN c ON a.x=c.y
The error goes away if you instead write ...
SELECT ...
FROM b, a INNER JOIN c ON A.x=c.y
so you might try
[EMAIL PROTECTED] writes:
[...]
Your application will still need access to the data it gets from
MySQL so changing your MySQL permissions doesn't make any sense,
does it. It's your application that needs to say no to the
user. You don't want MySQL saying no to your application. Do you?
James Black [EMAIL PROTECTED] wrote on 10/12/2005 02:06:26 PM:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Peter Brawley wrote:
James,
You can reproduce that error by writing ...
SELECT ...
FROM a, b INNER JOIN c ON a.x=c.y
The error goes away if you instead write
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED] wrote:
SELECT...
FROM items i
INNER JOIN nams.netids n
INNER JOIN ...
...
Does the problem remain? If it goes away, this would be useful information
to include in your bug report.
Thank you for the suggestion, but it led
James,
Both ...
SELECT ...
FROM a, b LEFT JOIN c ON a.x=c.y
and
SELECT ...
FROM a
LEFT JOIN B USING (x )
LEFT JOIN c ON a.x=c.y
work up to and including version 5.0.10, not in 5.0.11, 12 or 13.
http://bugs.mysql.com/bug.php?id=13832 reports...
"The two statements below are quite
I am not sure if you guys seen this:
http://www.msvistablog.net/news.php?item.82
http://www.ants.com/index.php?option=com_contenttask=viewItemid=29id=454
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
Desi Bay wrote:
I am not sure if you guys seen this:
http://www.msvistablog.net/news.php?item.82
http://www.ants.com/index.php?option=com_contenttask=viewItemid=29id=454
No, I haven't, but a trillion thanks for pointing it out. It doesn't
surprise me in the least that there are spammers out
Does anyone know a sw that can reverse engineering a mysql table? I want to
be able to draw a entity-relationship model from an already made MySQL
table.
Thanks,
Bruno
Bruno Cochofel wrote:
Does anyone know a sw that can reverse engineering a mysql table? I want to
be able to draw a entity-relationship model from an already made MySQL
table.
Thanks,
Bruno
There's MySQL Workbench here: http://forums.mysql.com/list.php?113 which
is a bit shakey but will do
Bruno Cochofel wrote:
Does anyone know a sw that can reverse engineering a mysql table? I
want to
be able to draw a entity-relationship model from an already made MySQL
table.
Dezign from Datanamic does a good job. MydbPal for Mysql is free and
advertises reverse engineering; I haven't used
Graham Reeds wrote:
Bruno Cochofel wrote:
Does anyone know a sw that can reverse engineering a mysql table? I
want to
be able to draw a entity-relationship model from an already made MySQL
table.
[snip]
Also people say great things about DBDesigner4 but I haven't used it to
talk about
Hi List,
I need to track the changes made in the database using the insert, update
and delete statements in MySQL 4.1.9. Can I use the Binary Log to get this
information or is there another better solution?
Thanks for any help.
Andre
--
Andre Matos
[EMAIL PROTECTED]
--
MySQL General
Andre Matos wrote:
Hi List,
I need to track the changes made in the database using the insert, update
and delete statements in MySQL 4.1.9. Can I use the Binary Log to get this
information or is there another better solution?
Thanks for any help.
Andre
The binary log is the recommended
MySQL General Discussion List,
I am curious to know if the MySQL mailing list uses MySQL in
managing the list and it's archives. The articles are surely archived in
a database, and I would assume that if the MySQL developers were to use
any database, it would be a MySQL one.
What
I am using InnoDB and replication, is there any issues?
Thanks.
Andre
--
Andre Matos
[EMAIL PROTECTED]
-Original Message-
From: Daniel Kasak [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 13, 2005 1:01 AM
To: Andre Matos; 'mysql@lists.mysql.com '
Subject: Re: Tracking changes in
54 matches
Mail list logo