Either put
datadir=/home/mydatadir
in the [mysqld] paragraph of the my.cnf file,
or move the data directory and create a symbolic link pointing the new
to the old.
Either way, shut down the server first.
tpchan wrote:
> Dear all,
>
> I installed mysql version 3.22.32 on Red Hat 6.2 using th
Dear all,
I installed mysql version 3.22.32 on Red Hat 6.2 using the rpm package.
Since mysql data directory is stay in /var/lib/, plus my database is growing
bigger day by day, my problem now is that the '/var' partition running short
of free hard disk space.
What I'm trying to do is to transfe
