I have an external HD and i'd like to run a 2nd mysql instance on it. I used the windows installer to install/configure mysqld as a service on windows7. I took the my.ini from
C:\Program Files\MySQL\MySQL Server 5.5\my.ini
Then edited the port (client and mysqld), datadir and innodb_data_home_dir. After running this command
"C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld" --defaults-file="f:/dev/my.ini"
I found an error which was all about the innodb_data_home_dir directory not existing. After that I ran the command again. Mysqld simply starts up for a second then immediately closes. I see no message in my command prompt. I know this command line args are correct as i see the mysqld service using the same one except a different my.ini path. Also it did tell me about the directory not existing so i know it is reading the new ini file.
How do i figure out why this 2nd instance of mysqld is closing? How do i get 2 instance running?
I'm using v 5.5