Hi James,
Check the whole /mnt filesystem hasn't been mounted read-only.
Regards
---------------------------------------------------------------
********** _/ ********** David Logan
******* _/ ******* ITO Delivery Specialist - Database
***** _/ ***** Hewlett-Packard Australia Ltd
**** _/_/_/ _/_/_/ **** E-Mail: [EMAIL PROTECTED]
**** _/ _/ _/ _/ **** Desk: +618 8408 4273
**** _/ _/ _/_/_/ **** Mobile: 0417 268 665
***** _/ ******
****** _/ ******** Postal: 148 Frome Street,
******** _/ ********** Adelaide SA 5001
Australia
i n v e n t
---------------------------------------------------------------
-----Original Message-----
From: news [mailto:[EMAIL PROTECTED] On Behalf Of James Brown
Sent: Friday, 30 December 2005 2:30 AM
To: [email protected]
Subject: Re: How to share databases on dual-boot machines?
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.
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.
An ls -al on the database files now shows this:
> # 'jamebrow' is my username
> # mysql is running as user 'mysql'
> -rwxr-xr-x 1 jamebrow 9063 2006-01-06 13:03 wp_options.frm*
> -rwxr-xr-x 1 jamebrow 222224 2006-01-07 02:22 wp_options.MYD*
> -rwxr-xr-x 1 jamebrow 8192 2005-12-28 15:28 wp_options.MYI*
The symlink looks like this:
> lrwxrwxrwx 1 mysql 25 2005-12-29 13:40 wordpress ->
/mnt/docs/mysql/wordpress/
Does anyone have any ideas?
Many thanks,
James.
Logan, David (SST - Adelaide) wrote:
> Hi James,
>
> There are a couple of options (from the Linux side of things) :
>
> 1) set the datadir either in the start options of safe_mysqld (or
> mysqld_safe I can never remember) or set it in the options file
(my.cnf
> or a .my.cnf in your home directory) see
> http://dev.mysql.com/doc/refman/5.0/en/option-files.html
>
> 2) move it to /mnt/wordpress and use a symbolic link from
/var/lib/mysql
> eg. mv /var/lib/mysql/wordpress /mnt ; ln -s /mnt/wordpress
> /var/lib/mysql/wordpress see
> http://dev.mysql.com/doc/refman/4.1/en/symbolic-links.html
>
> Regards
>
>
> ---------------------------------------------------------------
> ********** _/ ********** David Logan
> ******* _/ ******* ITO Delivery Specialist - Database
> ***** _/ ***** Hewlett-Packard Australia Ltd
> **** _/_/_/ _/_/_/ **** E-Mail: [EMAIL PROTECTED]
> **** _/ _/ _/ _/ **** Desk: +618 8408 4273
> **** _/ _/ _/_/_/ **** Mobile: 0417 268 665
> ***** _/ ******
> ****** _/ ******** Postal: 148 Frome Street,
> ******** _/ ********** Adelaide SA 5001
> Australia
> i n v e n t
> ---------------------------------------------------------------
>
> -----Original Message-----
> From: news [mailto:[EMAIL PROTECTED] On Behalf Of James Brown
> Sent: Thursday, 29 December 2005 12:54 PM
> To: [email protected]
> Subject: How to share databases on dual-boot machines?
>
> All,
>
> I'm new to MySQL (using v4.1) and have a dual boot machine with
Windows
> and Debian Linux (Etch).
>
> My goal is to share a database named "wordpress" between Linux and
> Windows by storing it on a FAT32 mount (I realise this limits me to
4GB
> in total).
>
> From what I can see at the moment, the "wordpress" tables live under
> /var/lib/mysql/wordpress.
>
> Numerous searches have revealed how to backup data, but I haven't seen
> any clues on how to permanently reloate a database to a different
> filepath (I'd like to move it to /mnt/wordpress). Could anyone
enlighten
>
> me please?
>
> Thanks in advance,
>
> James.
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
