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: mysql@lists.mysql.com
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]
