MySQL Forums
Forum List  »  General

ERROR 1210 (HY000): Incorrect arguments to DATA DIRECTORY
Posted by: Supriya Mayekar
Date: November 27, 2020 06:09AM

I have recently upgraded my database from 5.6 to 5.7 and then on 8.0.22.
On mysql 8,
when I am trying to add column in existing table, I am getting error as below.
ERROR 1210 (HY000): Incorrect arguments to DATA DIRECTORY

Innodb_file_per_table is ON.

Data directory in mysql is set properly.

acknowledges | CREATE TABLE `acknowledges` (
`acknowledgeid` bigint unsigned NOT NULL,
`userid` bigint unsigned NOT NULL,
`eventid` bigint unsigned NOT NULL,
`clock` int NOT NULL DEFAULT '0',
`message` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`acknowledgeid`),
KEY `acknowledges_1` (`userid`),
KEY `acknowledges_2` (`eventid`),
KEY `acknowledges_3` (`clock`),
CONSTRAINT `c_acknowledges_1` FOREIGN KEY (`userid`) REFERENCES `users` (`userid`) ON DELETE CASCADE ON UPDATE RESTRICT,
CONSTRAINT `c_acknowledges_2` FOREIGN KEY (`eventid`) REFERENCES `events` (`eventid`) ON DELETE CASCADE ON UPDATE RESTRICT,
CONSTRAINT `userid` FOREIGN KEY (`userid`) REFERENCES `users` (`userid`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=latin1 DATA DIRECTORY='/data/mysql/' |


When I try to add additional column to above table, I am getting an error.

mysql> ALTER TABLE acknowledges ADD COLUMN action INT DEFAULT 0;
ERROR 1210 (HY000): Incorrect arguments to DATA DIRECTORY

Options: ReplyQuote


Subject
Written By
Posted
ERROR 1210 (HY000): Incorrect arguments to DATA DIRECTORY
November 27, 2020 06:09AM


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.