CSV imports fail - stalling In Progress, Runtime Less than 1 second

After another diversion I now want to try to “fix” or “restore” the lead_event_log table with whatever solution I can find. I thought I could use mysqlcheck r- ..., but this site says mysqlcheck only works for MyISAM tables, not InnoDB.

Is that correct or is stellarinfo.com just trying to sell their software? What are my alternative options?

I can access ‘the MariaDB monitor’ via SSH, by simply typing mysql and enter, but logged in as root. Can I manage MySQL as root or will that cause all kinds of file permission and ownership problems again? Should I log in as some kind of user? With a user/pass for a specific database? How would I access a specific database?