Error 1067 trying to start service

[jusan]

Hi, I am using window xp, running visual basic ado accessing mysql database. Originally I set my data directory as in my C drive. It works fine. But when I change my data directory to novell server drive F, it gives me the error message 1067 saying that the service was stopped unexpectedly.

My novell server is in old version 4.11. I did not install mysql on it. I just tried to use it as data storage. But I did copy all the mysql database under F drive. The mysql service is running from my workstation locally. Is this configuration feasible? Or I have some other errors?

Please help!!!

 

[QatQat]

It is feasible.

Edit my.ini that you should find in c:\windows and change the datadir setting to your map drive F:



Bye


Qatqat

The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)

 

[QatQat]

Above instructions are to move all databases in a different location

If you want to store only one database in a different location you have to create something like a unix symbolic in the c:\mysql\data directory


EXAMPLE:

If your database is called database1 and you want to store it on F drive, create a file 'database1.sym' in the standard datadir

the content of
c:\mysql\data\database1.sym is as follows

f:\database1


Now, if you are using MySQL 3.XX you have to enable symbolic links; in My.ini add the following line in [mysqld] section


use-symbolic-links


Bye


Qatqat

The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)

 

[jusan]

Thank you very much for your response.

I tried with the first idea. I moved the whole database to F drive (which resides on another machine). And mysql service is running on my machine. But the database accessing becomes extremely slow.

But my original problem is that I cannot start the mysql service. What I did was I created the database on my machine and also set root password and other users with password. Then I copied my database as well as the mysql database to F drive. Then, when I tried to restart the service, I could not start it. I seems like to me that mysql database with password has some privilege on it. And it will cause fatal error.

 

[QatQat]

the mysql database has to stay where MySQL is installed as it stores all user, tables, rights, variables information about other db.

By no mean you should ever touch the MySQL database as it is updated and modified with the GRANT command. You can edit it directly only if you know what you are doing.


Bye


Qatqat

I have been happy throughout my life in thinking that samba was I kind of dance; now I live with Linux and all I do is working.