RE: Repost - Subject - Backup/Recovery Strategies for MySQL

2001-09-29 Thread Daniel Ouellet
I am not sure it that would provide everything you want to know, but I was looking for the same thing last week and I setup this replication database and it work great and make it very easy. http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm inistration.html#Replication

RE: flush performance

2001-09-29 Thread Daniel Ouellet
Hi, This is a guess, but I would assume that would wouldn't get accurate result by using ODBC. If you write your test in C, you may as well use the C library available and not use ODBC. Just my 0.02$ worth. Daniel Hi. I believe you missed his point: He expected a time difference but did

RE: Powered by MySQL?

2001-09-29 Thread Daniel Ouellet
True you did email, but look at the email address you send your request; Quote I have sent email to [EMAIL PROTECTED], but I have received no response. So, you send to [EMAIL PROTECTED] Instead of the one point it out in the doc: [EMAIL PROTECTED] May be if you try thisone you may get the

RE: Powered by MySQL?

2001-09-29 Thread Haapanen, Tom
This is what the MySQL web site says: D. Use of Powered by MySQL. If you are a user of the MySQL database server, (whether under the GPL licence or a MySQL commercial licence) and have not modified the source code for the application or use in question, you may request permission to display

RE: Powered by MySQL?

2001-09-29 Thread Daniel Ouellet
Well, one thing for sure! Just this discussion on this mailing list that Monty Widenius him self, that design most of the MySQL, read and answer regularly, will sure find him and you will get an answer for sure. After all they want to promote it as much as they can and when they see someone that

update support sub-queries?

2001-09-29 Thread can
Hi all, I am new in mysql and want to analyse between some popular databases. I have a SQL: update ta set f1 = ( select af1 from tb where ta.id = tb.id ); It can be done in postgreSQL and Oracle. How can I do the same tasks in MySQL without using Perl? Is it possible to do this tasks just

RE: update support sub-queries?

2001-09-29 Thread Daniel Ouellet
At the moment, according to the doc: http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.html# Missing_Sub-selects MySQL only support the insert select and Replace Select. I am not sure if that answer your question as I am not a big guru on it either, but it is a place to

strange error message

2001-09-29 Thread Casey Tourangeau
Hi, I'm using MySQL v3.23.42 with Mac OS 10.1, and whenever I try to create a database (logged in as root), i get the error create database 'name'. (errno: 13). Does anyone have any idea what that might mean? I tried manually instering data into the mysql.* tables, but with