I'm using mySql in a web2py application.
Using the instructions here: https://help.pythonanywhere.com/pages/MySQLBackupRestore/
I'm trying to backup a mysql database using this command (I've replaced actual user name and database name with usrname and dbnam below):
mysqldump -u usrnam -h usrnam.mysql.pythonanywhere-services.com --set-gtid-purged=OFF --no-tablespaces 'usrnam$dbnam' > db-backup.sql
I'm getting this error:
mysqldump: Couldn't execute 'SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"') FROM information_schema.COLUM N_STATISTICS WHERE SCHEMA_NAME = 'usrnam$dbnam' AND TABLE_NAME = 'auth_cas';': Unknown table 'COLUMN_STATISTICS' in information_schema (1109)