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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
