Re: How to change mysql default database directory

2010-01-28 Thread Suresh Kuna
> >> >> *From:* Carlos Proal >> *To:* mysql@lists.mysql.com >> *Sent:* Fri, January 29, 2010 10:16:31 AM >> *Subject:* Re: How to change mysql default database directory >> >> >>

Re: How to change mysql default database directory

2010-01-28 Thread Carlos Proal
using Windows. Thanks in advance. *From:* Carlos Proal *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 var

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/20

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 /etc/init.d

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 d