Re: MySQL database into network drives

[Federico Miliacca]

Eric Bergen Wrote:
-------------------------------------------------------
> You should be able to place the databases on the
> network drive by setting the datadir option in
> my.ini. You should note that unless you're using
> myisam with external locking only one instance of
> mysql will be able to access the tables.


Thanks Eric! I have already done this test but the problem is that when I restart MySQL Server after the modify to my.ini, the service is not start because it seems that not detect or not access the database file placed on the network. If I reset datadir to the original value C:\Program Files\MySQL\ ... everything works properly.

I'm using WindowsXP SP3 with IIS 5.1 and MySQL 5.0.51b.

Federico