New answers tagged


If you want the table created in that data directory with .ibd file, do this chown -R mysql:mysql /home/egonzalez/Documentos Then, run this CREATE TABLE t2 (c1 INT PRIMARY KEY) ENGINE=InnoDB DATA DIRECTORY = '/home/egonzalez/Documentos'; The option innodb_file_per_table is enabled by default in MySQL 5.7 The reason for the error in the first place ? ...

Top 50 recent answers are included