Sample Header Ad - 728x90

Creating MariaDB database on network drive

0 votes
1 answer
308 views
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