mysqldump with access denied
$ mysqldump -u xxxxx-h xxxxx.mysql.pythonanywhere-services.com 'xxxxx$dbpython' > backup_03ago2023.sql;
mysqldump -u xxxxx -h xxxxx.mysql.pythonanywhere-services.com --set-gtid-purged=OFF --no-tablespaces 'xxxxx$dbpython2' > backup_03ago2023.sql;
( Both commands returns error )
mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces mysqldump: Couldn't execute 'SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"') FROM informa tion_schema.COLUMN_STATISTICS WHERE SCHEMA_NAME = 'lisot$dbpython' AND TABLE_NAME = 'auth_group';': Unknown table 'COLUMN_STATISTICS' in infor mation_schema (1109)
How to GRANT ALL privileges? How to backup only one table? Do I need to inform the destination folder?
Thank You
lisot
|
11
posts
|
sboyd
|
279
posts
|
PythonAnywhere staff
|
