how to change location of database files?

[killerwhale65]

hi,

I am currently using a dualboot system Ubuntu - windows XP. I have XAMPP installed under windows, but i would like to access the database from under linux as well. In linux, i can change the location of the website-files, but not the database files. I want to work with the same database both in windows and linux, so i would have to alter the location XAMPP linux looks for its database files. But how do i do that?

Thanks!

Matt

[Nobbie]

>But how do i do that?

Edit the MySQL Configuration File (my.cnf) and supply the DataDir-Value as needed.

For example, if your WindowsXP NTFS(?) Filesystem is mounted to /media/c, and mysql is installed in c:/mysql, you shoul supply the following value to DataDir:

Code: Select all

DataDir = /media/c/mysql/data

Be sure that the user which runs the mysqld server process have sufficient rights (read and write) to change the data in /media/c/mysql/data. This depends on the mount options and on the NTFS driver of Linux.

[killerwhale65]

thanks, i will try that!

[killerwhale65]

hello again,

could you tell me where to find my.cnf? I only find one in /opt/lampp/etc, but that seems to be a sample file and not the actual one, and it does not contain "datadir".

thanks!

Matt

[Dave_L]

That probably is the actual file. Add the datadir setting to the [mysqld] section.