SUSE / openSUSEThis Forum is for the discussion of Suse Linux.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
I have more than one os installed on my computer and I would like to place my mysql dbs on my fat 32 partition so that all os's can have access to the same db. I have a folder on my fat 32 called mysql_dbs and I don't know how to point mysql, under suse, to this folder on my fat 32 fs where the dbs are stored? any suggestions??
macmichael01@linux:/> mysqld_safe --datadir=file:/windows/D/my_db/data
Starting mysqld-max daemon with databases from file:/windows/D/my_db/data
STOPPING server from pid file file:/windows/D/my_db/data/linux.pid
050625 12:32:34 mysqld ended
am I missing a file? maybe linux.pid???
I dont know what I did but it doesn't seem to work now. Maybe I need to restart! I shall try that. I looked for the file my.cnf in the etc/ folder and could not find a place in that file where I could by the directory path. my DB is on a Fat 32 partition so I hope that won't be a problem.
Below is what is in the mysql log file if this helps any. As I mentioned earlier, my db is located on a fat 32 FS and I recently changed the settings to give read and write access to the fat 32 FS by setting the unmask=000. The gid=users and the mysql is part of that group what else should I do if it is a read write error? One thing that I did knotice is that I can't goto the directories and right click to change the permissions. I guess the fstab sets the permissions to global for the whole partition. what should i do?
here is the line in my fstab for the fat 32 FS
------------------------------------------------------
/dev/hda4 /windows/D vfat users,gid=users,umask=000,iocharset=utf8 0 0
here is what php has to say when trying to load my page
--------------------------------------------------------
Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /windows/D/web_stuff/index.php on line 5
Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /windows/D/web_stuff/index.php on line 6
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /windows/D/web_stuff/index.php on line 8
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
here is the mysql log file
-----------------------------------------------------
050626 17:26:39 mysqld started
050626 17:26:39 Can't start server: Bind on TCP/IP port: Address already in use
050626 17:26:39 Do you already have another mysqld server running on port: 3306 ?
050626 17:26:39 Aborting
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.