Topic: mysql DB location

[jor70]

Im running mysql fine. The problem is located in the same HD of sme6 and Im coming short of space
How can I do to locate the mysql DBs (just them) in another HD
thks

[ergozd]

MySQL databases are stored at
# /var/lib/mysql

[jor70]

MySQL databases are stored at
# /var/lib/mysql

Is there a way to locate them in another place ?
thks

[Souley]

I think you should succeed by using the ln -s command
Man ls for more details

Good luck
Souley

[ergozd]

You can store MySQL databases "whereever you like"... The settings are in
#/etc/my.cnf

[mysqld]
datadir=/var/lib/mysql

If you plan to change make sure to modify you templates for my.cnf

OR as Souley suggested you can store them somewhere else and create a link with ln

Best rgds, Ergin

[jor70]

You can store MySQL databases "whereever you like"... The settings are in
#/etc/my.cnf

[mysqld]
datadir=/var/lib/mysql

If you plan to change make sure to modify you templates for my.cnf

OR as Souley suggested you can store them somewhere else and create a link with ln

Best rgds, Ergin

Please correct me if Im wrong
will be /sbin/e-smith/expand-templates /etc/my.cnf ?
thks

[ergozd]

File to modify is
/etc/e-smith/templates/etc/my.cnf/008datadir

In order to re-genarate new my.cnf YES, you run
#/sbin/e-smith/expand-template /etc/my.cnf as you alreay knew.