Forums

errors from Backing up mysql database

Hi I followed the link to backup my database, but it failed, hope any suggestions, many thanks!

https://help.pythonanywhere.com/pages/MySQLBackupRestore/

I typed in a command like this:

mysqldump -u xgxofdream2 -h xgxofdream2.mysql.pythonanywhere-services.com --set-gtid-purged=OFF --no-tablespaces 'xgxofdream2$myenglish'  > db-backup.sql

then it went back to me like this:

    mysqldump: Couldn't execute 'SELECT COLUMN_NAME,                       JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specifie
d"')                FROM information_schema.COLUMN_STATISTICS                WHERE SCHEMA_NAME = 'xgxofdream2$myenglish' AND 
TABLE_NAME = 'auth_group';': Unknown table 'COLUMN_STATISTICS' in information_schema (1109)

Try running the command with --column-statistics=0 option as well.