Siddus Posted June 28, 2004 Report Share Posted June 28, 2004 Help .... I have been trying to find the file my.cnf on my Mandrake 10 Powerpack-installation, but I don't seem to be able to find it ??? Does anyone know where it is located, MySQL is installed in it's default directory .. Siddus Quote Link to comment Share on other sites More sharing options...
idud Posted June 28, 2004 Report Share Posted June 28, 2004 Try here: /usr/share/mysql In my download edition, the direcory above is containing: -rw-r--r-- 1 root root 773 Feb 23 18:02 binary-configure drwxr-xr-x 2 root root 4096 Jun 7 10:41 charsets/ -rw-r--r-- 1 root root 482 Feb 23 18:02 Description.plist drwxr-xr-x 2 root root 4096 Jun 7 10:41 english/ -rw-r--r-- 1 root root 1081 Feb 23 18:02 Info.plist -rw-r--r-- 1 root root 8105 Feb 23 18:02 make_binary_distribution -rw-r--r-- 1 root root 1912 Feb 23 18:02 make_sharedlib_distribution -rw-r--r-- 1 root root 4702 Feb 23 18:02 mi_test_all -rw-r--r-- 1 root root 1365 Feb 23 18:02 mi_test_all.res -rw-r--r-- 1 root root 4866 Feb 23 18:02 my-huge.cnf -rw-r--r-- 1 root root 4842 Feb 23 18:02 my-large.cnf -rw-r--r-- 1 root root 4825 Feb 23 18:02 my-medium.cnf -rw-r--r-- 1 root root 2410 Feb 23 18:02 my-small.cnf -rw-r--r-- 1 root root 25277 Feb 23 18:02 mysql-4.0.18.spec -rw-r--r-- 1 root root 657 Feb 23 18:02 mysql-log-rotate -rwxr-xr-x 1 root root 6271 Feb 23 18:02 mysql.server* -rw-r--r-- 1 root root 2694 Feb 23 18:02 MySQL-shared-compat.spec -rw-r--r-- 1 root root 431 Feb 23 18:02 postinstall -rw-r--r-- 1 root root 578 Feb 23 18:02 preinstall -rw-r--r-- 1 root root 460 Feb 23 18:02 StartupParameters.plist Try to read the my*.cnf file, so you can choose which one is fits your need, and copy it as /etc/my.cnf. Quote Link to comment Share on other sites More sharing options...
Siddus Posted June 28, 2004 Author Report Share Posted June 28, 2004 The ting is that I am trying to change the location of mysql's datadir but I don't know how to do this ??? Can anyone help me with this ???? Siddus Quote Link to comment Share on other sites More sharing options...
idud Posted June 29, 2004 Report Share Posted June 29, 2004 You mean you want to move /var/lib/mysql to somewhere else? I want to do the same thing sometime ago, but I found out that I have to compile mysql by myself to do that. I don't know if there's some other way. Is there anybody experienced with this? Quote Link to comment Share on other sites More sharing options...
gem-in-eyez Posted April 10, 2006 Report Share Posted April 10, 2006 fixed the issue with the missing my.cnf file. basically from my research there are some distros that do not have the mysql my.cnf file placed in the respective /etc directory. In this case I had to go to /usr/share/mysql/ take 1 of the 4 files there called: /usr/share/mysql/my-huge.cnf /usr/share/mysql/my-large.cnf /usr/share/mysql/my-medium.cnf /usr/share/mysql/my-small.cnf edit it and then save the edited file to the /etc directory as my.cnf if done correctly when the mysql database is restarted (within webmin is where I did it), you can not click on the mysql server configuration link and you will see your options for configuring it. the choice above for the my-***.cnf file to configure varies according what your system is doing with mysql. Just open them up and read the notations and proceed from there... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.