On Thursday 17 February 2005 10:56 am, Hassan Schroeder wrote: > Hal Vaughan wrote: > > I see that, but even when I bypass them, I can run 2 instances of mysqld, > > it shows up in the task list as 2 separate tasks, but they both use the > > data directory specified in the last instance I run. > > Uh, that doesn't really make sense -- a *running* instance isn't > going to switch data directories because another process started > up :-)
That's what's happening. I have no idea why. Here's what I'm doing now: (each command is in a separate console) mysqld --port=3307 --datadir=/dbtest/mysql mysqld --port=3306 --datadir=/var/lib/mysql mysql --port=3307 mysql --port=3306 When I do this, then do a "show databases;" in either new instance of mysql (both are open at the same time, in separate consoles), I get the databases in the last version of mysqld that I specified. > Sounds like something in the way you're invoking this is causing > the first instance to be restarted, and then it's using the second > set of parameters. I do a "ps-ax" and get this (only mysqld tasks pasted in): 13391 pts/10 S 0:00 mysqld --port=3307 --datadir=/dbtest/mysql 13401 pts/10 S 0:00 mysqld --port=3307 --datadir=/dbtest/mysql 13402 pts/10 S 0:00 mysqld --port=3307 --datadir=/dbtest/mysql 13403 pts/10 S 0:00 mysqld --port=3307 --datadir=/dbtest/mysql 13450 pts/9 S 0:00 mysqld --port=3306 --datadir=/var/lib/mysql 13451 pts/9 S 0:00 mysqld --port=3306 --datadir=/var/lib/mysql 13452 pts/9 S 0:00 mysqld --port=3306 --datadir=/var/lib/mysql 13453 pts/9 S 0:00 mysqld --port=3306 --datadir=/var/lib/mysql > My preference to do this is to create a complete new config file, > say /etc/alt.cnf, and use that to configure the second process. > That way you can be relatively sure there aren't any overlapping > resources. I'll try that, in case config options can trump a command line. Hal > HTH! > -- > Hassan Schroeder ----------------------------- [EMAIL PROTECTED] > Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com > > dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
