Hi MySQL fans,
I just read in the news about Innobase being sold to Oracle.
Does anybody know whats going on with Innobase and what impact the selling out
to Oracle might have on MySQL ?
http://www.infoworld.com/article/05/10/12/HNnewmysql_1.html?source=rss&url=http://www.infoworld.com/article/05
Andre Matos wrote:
I am using InnoDB and replication, is there any issues?
Thanks.
Andre
It depends what you're doing. If you use the binary log, there are no
issues - in replication uses the binary log to achieve it's goals.
Since the plain-text log is depreciated, you probably should lea
Hi,
Can someone tell me if it is anyhow possible to import a dBaseIII+
database into MySQL and if so: how?
Thank you,
Huub
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 the
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 applicat
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
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 Mail
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 it
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 use
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 t
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
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_content&task=view&Itemid=29&id=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 o
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_content&task=view&Itemid=29&id=454
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mai
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
-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
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
[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
-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
-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 t
-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
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 site
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:
> >
> > H
[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
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 w
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,
-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 f
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
__
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 effecti
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:
[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 h
[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,
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]>
Vastaanott
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
binlog
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 wo
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 do
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
> conne
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
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
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
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
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 Ma
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
querries
-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 haven'
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 b
"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 o
"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 d
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 pro
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 local
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
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 someone
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 wit
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,
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 gues
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 (numbe
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/
--
MySQ
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
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 available
57 matches
Mail list logo
