ndb_mgmd on windows?

2006-10-01 Thread Sebastian Mork 
Hi,

I wanna create a mysql-cluster with two data-nodes running on
linux-servers.
so I've got two linux-servers available but for the management-node I'd
need a third one..
I just wanna test my app first to see how it is running in a cluster,
later in production there'll be three linux-servers.
so is it possible to run the management-node on a windows-machine?

here someone said he saw it running on win:
http://forums.mysql.com/read.php?25,70539,79253#msg-79253

I tried using cygwin on my win-pc to run ndb_mgmd but it doesnt start
there...
-- 
Sebastian Mork [EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: comparing two databases

2006-10-01 Thread Steve Buehler 
I want to thank all of you that responded to my question.  I 
have not tried all of the programs yet, but I think I will when I get 
time.  I have tried DBTools Manager Enterprise Edition and it does 
what I was looking for and more.  I might even purchase it after I 
test it some more and see that it will do everything that I need for 
other things too.  I like that it can do a type of CVS for a database 
too.  A couple of long term projects that I am on could really use 
something like that.


Thanks
Steve

At 05:45 AM 9/29/2006, COS wrote:

Hi,

Look at DBTools Manager Enterprise Edition
(http://www.dbtools.com.br/EN/dbmanagerpro)
It compares the dbs and shows the changes in a Tree View. You can select
which changes will apply or not and view the DDL commands before apply them
to the destination.
Screenshot available at
http://www.dbtools.com.br/EN/dbmanagerpro/images/database_compare.png

Best Regards,

COS


- Original Message -
From: Steve Buehler [EMAIL PROTECTED]
To: mysql mysql@lists.mysql.com
Sent: Thursday, September 28, 2006 5:06 PM
Subject: comparing two databases


 Is there a program out there that I can use to compare two
 databases?  Just the structure, not the content.

 Thanks
 Steve


 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Low priority copy?

2006-10-01 Thread mos 

At 01:54 PM 9/27/2006, you wrote:

I have a very busy 14,000,000 record table. I made a new version of
the table, that's more efficient, and now I just need to copy over
the data. Just about anything I try swamps the machine and locks up
MySQL with too many connections because it's so damn busy. Can
anyone suggest the most efficient way to copy over all the data to
the new table with low priority so I don't kill the machine? It's OK
if it takes up to around 10 minutes. Thanks...


If your table is constantly being queried, even a delayed insert may not 
have a chance to complete. See 
http://dev.mysql.com/doc/refman/5.0/en/insert-delayed.html (I believe all 
inserts to the table must be a delayed insert-you can't mix them with 
non-delayed inserts. Also you run the risk of losing the updates if the 
server crashes because the delayed updates are in memory.)


Rather than looking for MyISAM workarounds, why can't you bite the bullet 
and switch to InnoDb? Use transactions to move the rows into the table and 
tweak your configuration settings to improve InnoDb caching and you'll 
likely have a more robust table than MyISAM. Granted it takes more time to 
tweak, and updates may be a tad slower, but at least it will work without 
worrying about a locking problem. I'm going to have to do this myself and 
although I'm not going to relish the idea, it's the only legitimate 
solution for a locking problem.


Mike  


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Can't set password for user

2006-10-01 Thread Deckard 
Hello,

I'm trying to set a password for a user with the command:

mysql set password for 'gamito'@'localhost'=password('bla');

but i always get the error:
ERROR 1133 (42000): Can't find any matching row in the user table

although i'm pretty sure that he user exists.

I'm using MySQl version 4.1.20

Any help would be appreciated.

Best Regards,
Deckard

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]