Got this error today when I browsed to my Joomla site, which I had just imported from elsewhere.
Once in the MySQL console, you can use show and purge to selectively delete portions like below:
Recently I had to monitor some data being output to a log table while an application was running. The log table was quite large, and being written to constantly and also by portions of that system I wasn’t interested in. So I only wanted to see the 10 or 20 most recent rows / records… Continue reading On demand “Tailing” of a database log table: select the last x records
After installing Jahia today, I wanted to use the MySql database instead of the default HyperSonic.