How to modify the mysql data file location

xiaoxiao2021-03-06  112

It can be so simple. The database file is placed under / var / db / mysql when mysql installation on FreeBSD5.2.

However, / var is 95%. Turn a big database in the past. The space is not enough, so I think of the location of MySQL's database files.

Ah.

It is OK to have a LN -S. what.

#DSA / USR / local / libexec / mysqld stop

#DSA MKDIR / DISK2 / DB

#DSA MV / VAR / DB / MYSQL / DISK2 / DB

#dsa ln -s / disk2 / db / mysql / var / db / mysql

#dsa / usr / local / libexec / mysqld start

Oh, it is okay. sweat

转载请注明原文地址:https://www.9cbs.com/read-102059.html

New Post(0)