Re: Administrative Tools

2007-06-07 Thread Michael Raven
Check out http://www.sqlmanager.net/en/products/mysql http://www.sqlmanager.net/en/products/mysql AndrewMcHorney wrote: > > Hello > > I am looking for the tools that I would use to be able to do > administrative duties and to be able to create and update databases > (tables, indexes and so fo

When will partitioning be included in the MySQl stable release ?

2007-06-07 Thread Mariella Petrini
Dear All, I would like to know if there are short time plans (and eventually when approximately it will be) to include partitioning in the next MySQL stable release. Thanks in advance for your help. I look forward to hearing from you, Mariella - You s

Advanced Indexing

2007-06-07 Thread Cory Robin
Is there a way to only include certain matching conditions in indexes? Example if I have a row I want to index that is mysql dates (2007-06-07) and I only want to include CURRENT and FUTURE dates in the index and ignore any past dates. Is that possible at all? The issue I have is that the ratio

MYSQL data replication

2007-06-07 Thread sol beach
I have limited experience with MYSQL replication; which is why I am hoping others with more experience can answer a question or two. Let's say I have a MASTER MYSQL database. Let's say there are 50 - 60 other systems where I'd like to have MYSQL running on these "slave" systems. These slave system

String Locks

2007-06-07 Thread Michael Dykman
I saw mention of something called string locks in an earlier thread, yet I see nothing like it in the mysql documentation. Could somebody please point me at a reference? -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For

Rewriting PostgreSQL in another language - from "C" to SmartEiffel

2007-06-07 Thread Al_Dev
Rewriting PostgreSQL in another language - from "C" to SmartEiffel PostgreSQL is very stable, mature and fully grown up and is in spectacular shape. But what will the developers do next ? Will they run out of work? No!! We can give them more work to do. We can keep them very busy for many more

Re: Mysql 5.0.* client connection to Mysql 4.0.* Database

2007-06-07 Thread dpgirago
Yes, I did try. The issue was the security level setting on the new DB server, and not the password stuff. I've upgraded apache, mysql, and php in the last few weeks, and 3-4 issues became painfully apparent when going from php4 to php5, so I guess I was operating under similar assumptions and

Re: Mysql 5.0.* client connection to Mysql 4.0.* Database

2007-06-07 Thread Michael Dykman
Have youtried this yet? While 4.0 client can't connect to a v.5 server unless the passwords have explicitly beewen stored as old_password, I have never run into an issue connecting a 5.x client to a 4.0 server. - michael On 6/7/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Is it possible t

Mysql 5.0.* client connection to Mysql 4.0.* Database

2007-06-07 Thread dpgirago
Is it possible to connect to a 4.0.18 DB from the client of a 5.0.27 system? I know there is an old_passwords function. Can this be used somehow from a DOS command prompt? David

How to parition a table with a VARCHAR Primary Key?

2007-06-07 Thread Eric B.
Hi, I'm struggling with getting my tables partitioned. All the tables I want to partition have a single primary key id which is a varchar. They also have a created datetime field to let me know when each record was added to the db. Ex: CREATE TABLE `document` ( `document_id` varchar(50) NOT NUL

Re: recurring table corruption problems (MyISAM)

2007-06-07 Thread Quentin Gouedard
I recompiled my sql with "nocona" instead of k8 and the problem persists. Now, I found this: http://bugs.mysql.com/bug.php?id=17329 which definitely sounds similar to my problems. I'm gonna give a shot to disabling delayed_key_write. On 6/6/07, Quentin Gouedard <[EMAIL PROTECTED]> wrote: Hello

Re: MySQL Magazine - Issue 1 available NOW!!!!

2007-06-07 Thread Jon Ribbens
On Wed, Jun 06, 2007 at 05:56:44PM -0700, Peter Rosenthal wrote: > On 04/06/07, Jon Ribbens <[EMAIL PROTECTED]> wrote: > >Um, what? Both that and the methods described in the magazine are > >completely wrong. You use mysql_real_ecape_string(), that's it. > > I would disagree on the use of mysql_re

Re: My Experience on DRBD for MySQL

2007-06-07 Thread Vitaliy Okulov
Здравствуйте, Mohd. Вы писали 7 июня 2007 г., 12:46:32: > Good day, > I just want to share my experience in deploying DRBD for MySQL, I'm > blogging it at http://blog.irwan.name/?p=118 > I welcome any comments and critics, thanks. > -- > Regards, > Mohd Irwan Jamaluddin > Web: http://www.irwa

My Experience on DRBD for MySQL

2007-06-07 Thread Mohd Irwan Jamaluddin
Good day, I just want to share my experience in deploying DRBD for MySQL, I'm blogging it at http://blog.irwan.name/?p=118 I welcome any comments and critics, thanks. -- Regards, Mohd Irwan Jamaluddin Web: http://www.irwan.name/ Blog: http://blog.irwan.name/ -- MySQL General Mailing List For l