Orion

Sorry if I was kinda vague. Here\'s the scenario I\'m wondering about. I have MySQL 4.01 running on my Win2k machine and I have created a database and everything is working fine. I\'m trying to see if I can move that database to another drive on our network, and MySQL is not running on that server. I just want my machine to look at the database no matter where I put it. I tried editing my.ini file and I also tried creating a symbolic link, but I don\'t seem to have the information I need to make these work. Any advice?

Is it possible to have MySQL and MyODBC running on a local machine and have it point to a database placed on a server that isn\'t running MySQL? If so, what do you have to edit in the my.ini and MyODBC? I can\'t get my computer to connect to the database I\'ve placed on my server. Any advice would be awesome.

Thank you very much for the help. I appreciate all of your advice and tips. It\'s kinda weird though. I setup MySQL on another Win2k machine, and it runs perfectly. Everytime you reboot, the service starts automatically. Everything is great. But on my machine, and a WinXP machine I also set it up on, I can\'t get the service to run automatically. Like I said before, if you reboot, or just close the WinMySQLAdmin instead of hiding it, you can never get the service started again... Manually or automatically. I know there\'s got to be something that\'s set incorrectly that I just have to find. I\'m going to try comparing the my.ini on the working computer with that on the non-working computers. Maybe I can see something there and just manually edit the my.ini on the non-working computers. Worth a shot I guess.

Do I even need to use WinMySQLAdmin to get MySQL running on my computer? Is there any other way or program to do this?

I am trying to setup MySQL on my local Windows 2000 machine and I\'m running into a problem that hopefully someone here can help with. Loaded MySQL 4.0 Loaded MyODBC 2.5 Setup the DSN to point to the database I\'m going to create. Opened up WinMySQLAdmin 1.4 to establish a connection. Used command prompt to create database, and everything seemed to work just fine. However, if I close WinMySQLAdmin or reboot my machine. I can\'t get the service to start up again. WinMySQLAdmin won\'t connect, and if I try to manually restart the service, I get \"error 1067: The process terminated unexpectedly.\" The only way I\'ve found to get it working again is to uninstall everything, redownload MySQL and MyODBC, reinstall, and sometimes this works. That\'s obviously really crappy and not an acceptable solution. Does anybody have any ideas?