I'm working with **confidential data** stored on a network drive, and I need to ensure that this data never leaves the network drive. The data is a **300GB** **.mysql** file that I need to import into a MariaDB database. My setup involves a remote machine where I have mounted this network drive with
uid
, gid
set to ubuntu
.
My goal is to create the MariaDB database directly on the network drive due to the confidentiality requirements. I tried to change the datadir
in the 50-server.cnf
configuration file to a new directory located on the network drive.
However, when I restart the MariaDB service, I encounter the following errors related to InnoDB:
Aug 13 06:11:15 mariadbd: 2024-08-13 6:11:15 0 [ERROR] InnoDB: The data file './ibdata1' must be writable
Aug 13 06:11:15 mariadbd: 2024-08-13 6:11:15 0 [ERROR] InnoDB: The data file './ibdata1' must be writable
Aug 13 06:11:15 mariadbd: 2024-08-13 6:11:15 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Aug 13 06:11:15 mariadbd: 2024-08-13 6:11:15 0 [Note] Plugin 'FEEDBACK' is disabled.
Aug 13 06:11:15 mariadbd: 2024-08-13 6:11:15 0 [Note] Zerofilling moved table: './mysql/plugin'
Aug 13 06:11:15 mariadbd: 2024-08-13 6:11:15 0 [ERROR] Unknown/unsupported storage engine: InnoDB
Aug 13 06:11:15 mariadbd: 2024-08-13 6:11:15 0 [ERROR] Aborting
Aug 13 06:11:15 systemd: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Aug 13 06:11:15 systemd: mariadb.service: Failed with result 'exit-code'.
I'm not very experienced with MariaDB or setting up databases on network drives, and I'm unsure how to resolve these errors.
Any help would be greatly appreciated!
Asked by Sarandeep Singh
(1 rep)
Aug 13, 2024, 05:25 PM
Last activity: May 29, 2025, 12:04 AM
Last activity: May 29, 2025, 12:04 AM