MySQL Forums
Forum List  »  InnoDB

When creating a table can you use a windows share for the data directory
Posted by: Ronald Radowich
Date: March 03, 2022 07:38PM

When create a table in the INNodb engine, can the data directory clause point toward a windows share device?

CREATE TABLE geo_countries (
record_nbr INTEGER not null AUTO_INCREMENT,
country_name varchar(100) NOT NULL,
abv char(2) NOT NULL DEFAULT '' COMMENT 'ISO 3661-1 alpha-2',
abv3 char(3) DEFAULT NULL COMMENT 'ISO 3661-1 alpha-3',
abv3_alt char(3) DEFAULT NULL,
iso_3_code char(3) DEFAULT NULL COMMENT 'ISO 3661-1 numeric',
slug varchar(100) NOT NULL,
PRIMARY KEY (record_nbr),
UNIQUE KEY `slug` (`slug`)
)
ENGINE=innodb
AUTO_INCREMENT=1
DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_0900_ai_ci
DATA DIRECTORY= '"\\wdmycloud\mysql_databases"'

Options: ReplyQuote




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.