Hello,

When I installed Oracle Linux 8 I was assigned 250GB and did not realize:

root partition 70GB
home partition 180GB

MYSQL runs on root partition and I wonder how can I expand. I know I can add extra storage and extend by merging: https://www.redhat.com/sysadmin/resize-lvm-simple

I wonder if there are:

- a way without adding extra storage
- a way to point MySQL database to pint to /home partition instead or /root partition.

Thank you

yes, you need to move the database. I think it is just a directory, you can move it (first copy and remove the original if the new one is working). When you open a database you can specify the location. But anyway, would be nice to know more to give better help. (In general putting database onto the root filesystem is not a good idea).

Thank you for your quick reply.

I will fix that.

I will search for how to expand the root partition in a virtual machine.

Here are the steps for moving mysql data to another folder / partition:

yum install rsync

systemctl stop mysqld

rsync -av /var/lib/mysql /home/mysql

mv /var/lib/mysql /var/lib/mysql.bak

change data in /etc/my.cnf
datadir=/home/mysql
socket=/home/mysql/mysql.sock

ln -s /home/mysql/mysql.sock /var/lib/mysql/mysql.sock

service mysqld start

in mysql:
SELECT @@datadir;

show databases;

mysql -uroot -p -h 127.0.0.1 or:

mysql -uroot -p but create:

[client]

socket=/var/lib/mysql/mysql.sock

at final:
[root@whdnew mysql]# df /home/mysql
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/mapper/ol_whdnew-home 200303044 3813816 196489228 2% /home

mysql> select @@datadir;
+--------------+
| @@datadir |
+--------------+
| /home/mysql/ |
+--------------+
1 row in set (0.00 sec)

yes, that looks almost perfect, just you can use the original socket /var/lib/mysql/mysql.sock, do not need to move it and/or link it. But you can use the new socket too.

yes with old socket I had:

mysql -uroot -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)


and after I added:

[client]

socket=/new directory/mysql/mysql.sock

it fixed: mysql -u root -p and no more error poping out

I hope it helps others in need of moving MySQL from one partition to another

And, if you need to expand space in a virtual machine ... I hope that you have LVM = Logical Volume Management installed, which is the usual default. [i](If not, you can install it.)

Then, you create a new virtual disk, add it to a "storage pool," then expand the "logical volume" using space from that pool. Finally, expand the filesystem to recognize the new space. (All of which you can do without downtime.) There are an abundance of online tutorials showing you exactly how the trick is done.