Sample Header Ad - 728x90

MySQL one file per table not working

0 votes
2 answers
549 views
I've followed all of the instructions for enabling the one file per table in MySQL (v8, on Ubuntu 20): - Added innodb_file_per_table=ON - Restarted MySQL - Dumped all databases, one by one. However, when I import the databases back, everything is written to ibdata1 file. But, When I create a brand new DB via MySQL Client, and add a random table to it, the data is written to its own folder + table.ibd file. Any idea what I could be doing wrong? Few troubleshooting steps I tried: - Reboot - show variables like 'innodb_file_per_table'; (Value = ON)
Asked by FlyingZebra1 (113 rep)
Dec 24, 2020, 02:54 AM
Last activity: Dec 25, 2020, 11:23 PM