Hi James, all!
James Brown wrote:
Thanks for the advice David. I opted for your method 2 and symlinked to
my database files which now reside on a FAT32 partition.
Unfortunately, I've hit a slight issue which I'd like to run past you,
but I do think this could turn out to be a FAT32 problem rather than a
MySQL one.
Right.
Search the Linux docs / newsgroups / FAQs / HowTos for info on "mount"
options specific to FAT file systems, there you should find more hints.
Basically, the following error appears when I try to run an UPDATE on
the relocated database:
WordPress database error: [Table 'wp_options' is read only]
I've tried 'chmod 777 *' on all the "wordpress" database files, but
still couldn't get universal write permissions. 'chown mysql *' also
failed with an error.
FAT file systems store neither access rights nor owners.
What is shown to you by "ls -l" is just fake info (not coming from the
disk but added by the Linux kernel), but this fake info is also used for
checking access.
Basically, "mount" has options that allow you to set the user, group,
and access rights for all files and directories on that mounted file system.
[[...]]
Does anyone have any ideas?
For me (SuSE 9.3), "man mount" contains this info:
=== start quote ===
uid=value and gid=value
Set the owner and group of all files. (Default: the uid and gid
of the current process.)
umask=value
Set the umask (the bitmask of the permissions that are not
present). The default is the umask of the current process.
The value is given in octal.
dmask=value
Set the umask applied to directories only. The default is the
umask of the current process. The value is given in octal.
fmask=value
Set the umask applied to regular files only. The default is the
umask of the current process. The value is given in octal.
=== end quote ===
Regards,
Jörg
--
Joerg Bruehe, Senior Production Engineer
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]