How to change mysql default database directory

2010-01-28 Thread Lucky Wijaya
Hi all, I've installed MySQL on 320GB Harddisk (partitioned into 3 partitions). I want to know if there's a way to change MySQL default database directory from C: to D:. Thanks.

Re: How to change mysql default database directory

2010-01-28 Thread Carlos Proal
Absolutely, check for the variable datadir on the config file (my.ini on windows and my.cnf on *nix). Carlos On 1/28/2010 9:12 PM, Lucky Wijaya wrote: Hi all, I've installed MySQL on 320GB Harddisk (partitioned into 3 partitions). I want to know if there's a way to change MySQL default

Re: How to change mysql default database directory

2010-01-28 Thread prabhat kumar
Hi, For Linux:*How to change the mysql database location* 1. Create the directory that will be the new datadir. ( example: /home/db ) 2. Change ownership of new folder to the mysql user and group: sudo chown -R mysql:mysql /home/db 3. Stop the MySQL database server: sudo

Re: How to change mysql default database directory

2010-01-28 Thread sureshkumarilu
--Original Message-- From: Carlos Proal To: mysql@lists.mysql.com Subject: Re: How to change mysql default database directory Sent: Jan 29, 2010 8:46 AM Absolutely, check for the variable datadir on the config file (my.ini on windows and my.cnf on *nix). Carlos On 1/28/2010 9:12 PM

Re: How to change mysql default database directory

2010-01-28 Thread Carlos Proal
Windows. Thanks in advance. *From:* Carlos Proal carlos.pr...@gmail.com *To:* mysql@lists.mysql.com *Sent:* Fri, January 29, 2010 10:16:31 AM *Subject:* Re: How to change mysql default database directory Absolutely, check

Re: How to change mysql default database directory

2010-01-28 Thread Suresh Kuna
carlos.pr...@gmail.com *To:* mysql@lists.mysql.com *Sent:* Fri, January 29, 2010 10:16:31 AM *Subject:* Re: How to change mysql default database directory Absolutely, check for the variable datadir on the config file (my.ini on windows and my.cnf on *nix). Carlos On 1/28/2010 9:12 PM