shutdown mysql, move all the files in your current data directory to
the new location
in your my.cnf file (ie. unix: /etc/my.cnf)
[mysqld]
datadir=/my
---
all data files are in /my
- hcir
On Friday, January 3, 2003, at 07:56 AM, aman raheja wrote:
Hi All
Right now I have all my MySQL dat
Hi All
Right now I have all my MySQL database files getting stored in
/var/lib/mysql/
If I want to change that to another location, say, /home/mysql or something
else, how do I do it?
Thanks
Aman
-
Before posting, please check:
This is one thing I really can't stand about mysql. We should have the option when
creating
databases and tables of specifying where the database is located and the datafile and
indexfile.
Dave
On Fri, Aug 31, 2001 at 07:03:40PM +0200, Simon J Mudd wrote:
> On Fri, 31 Aug 2001, Peter Moscatt wr
On Fri, 31 Aug 2001, Peter Moscatt wrote:
> Can you change the location of a MySQL database ? The default is
> '/var/lib/mysql'.
The easy way I've always used is to change the name of the /var/lib/mysql
directory and make a symbolic link to another directory. You need to
reset up the mysql dat
Can you change the location of a MySQL database ? The default is
'/var/lib/mysql'.
Pete
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive