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:
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
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
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