MySQL Forums
Forum List  »  Oracle

Unable to start msyqld service after modifying datadir from default /var/lib/mysql to /u01/mysql
Posted by: Jamsher Khan
Date: December 22, 2020 07:49AM

Hi,

Mysql Version : Server version: 8.0.22 MySQL Community Server - GPL
OS Version : OEL 7.9

I am unable to start mysqld service after I changed datadir location from default /var/lib/mysql to /u01/mysql

2020-12-22T13:28:34.343524Z 0 [Warning] [MY-010091] [Server] Can't create test file /u01/mysql/mysqld_tmp_file_case_insensitive_test.lower-test
2020-12-22T13:28:34.343623Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.22) starting as process 68273
2020-12-22T13:28:34.348703Z 0 [Warning] [MY-010091] [Server] Can't create test file /u01/mysql/mysqld_tmp_file_case_insensitive_test.lower-test
2020-12-22T13:28:34.348716Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /u01/mysql/ is case insensitive
2020-12-22T13:28:34.349653Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-12-22T13:28:34.349907Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.22) MySQL Community Server - GPL.

Please help to fix this issue.

Best Regards
Jamsher

Options: ReplyQuote


Subject
Views
Written By
Posted
Unable to start msyqld service after modifying datadir from default /var/lib/mysql to /u01/mysql
179
December 22, 2020 07:49AM
104
December 22, 2020 11:25AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.