If you've changed your database properties to use innodb_large_prefix = 1 and innodb_file_format = Barracuda in my.cnf as below:
![](https://lxadm.com/content/images/2022/09/Ekran-Resmi-2022-09-21-18.17.44.png)
you may want to convert all your existing tables to use DYNAMIC or COMPRESSED ROW_FORMAT.
For a single table, you need to run the following:
![](https://lxadm.com/content/images/2022/09/Ekran-Resmi-2022-09-21-18.17.48.png)
To convert all tables in a given database, here is a short bash script to do it:
![](https://lxadm.com/content/images/2022/09/Ekran-Resmi-2022-09-21-18.17.53.png)
The script assumes you can use mysql without specifying a password (i.e. password added to .my.cnf).