Comments - Troubleshooting Row Size Too Large Errors with InnoDB

2 years, 2 months ago Luca Accomazzi

The script rowcount.sh was very useful to me but it may fail with error 1064. I got

ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-home' at line 1

This happened because a table of mine uses the hyphen (-) in its name. The script should be changed to use backticks (`) around table names. Unfortunately I'm not good enough with shell scripting to provide a fix myself.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.