Sql backup failed from remote database

• 10:30:02 AM : Starting scheduled job “Kseeker_Scheduled_Job” - “Full”. Server “TSDS”. Account “SYSTEM@TECHNO-SOFT”. App v.“12.4.8”.
• 10:30:07 AM : Connecting to: (5.7.27-log). 40.121.36.230.
• 10:30:09 AM : The backup folder “C:\Windows\TEMP\SYSTEM\Pranas.NET\SQLBackupAndFTP\backup” has “71.72GB” free space. The temporary folder “C:\Windows\TEMP\SYSTEM\Pranas.NET\SQLBackupAndFTP\backup” has “71.72GB” free space.
• 10:30:10 AM : Backing up “40.121.36.230” databases with “mysqldump.exe: Ver 8.0.13 for Win64 on x86_64 (MySQL Community Server - GPL)”
• 10:30:12 AM : The maximum file size for destination “Google Drive: Knowledge Seeker”: “4.768TB”.
• 10:41:05 AM : ERROR: Failed to backup “ksbronx” database with “Full” backup type: mysqldump: [Warning] Using a password on the command line interface can be insecure. mysqldump: Couldn’t execute ‘SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, ‘$.“number-of-buckets-specified”’) FROM information_schema.COLUMN_STATISTICS WHERE SCHEMA_NAME = ‘ksbronx’ AND TABLE_NAME = ‘attendance’;’: Unknown table ‘column_statistics’ in information_schema (1109) mysqldump: Couldn’t execute ‘SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, ‘$.“number-of-buckets-specified”’) FROM information_schema.COLUMN_STATISTICS WHERE SCHEMA_NAME = ‘ksbronx’ AND TABLE_NAME = ‘certification’;’: Unknown table ‘column_statistics’ in information_schema (1109) mysqldump: Couldn’t execute ‘SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, ‘$.“number-of-buckets-specified”’) FROM information_schema.COLUMN_STATISTICS WHERE SCHEMA_NAME = ‘ksbronx’ AND TABLE_NAME = ‘certificationcourses’;’:…
• 10:50:45 AM : ERROR: Failed to backup “ksqueens” database with “Full” backup type: mysqldump: [Warning] Using a password on the command line interface can be insecure. mysqldump: Couldn’t execute ‘SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, ‘$.“number-of-buckets-specified”’) FROM information_schema.COLUMN_STATISTICS WHERE SCHEMA_NAME = ‘ksqueens’ AND TABLE_NAME = ‘attendance’;’: Unknown table ‘column_statistics’ in information_schema (1109) mysqldump: Couldn’t execute ‘SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, ‘$.“number-of-buckets-specified”’) FROM information_schema.COLUMN_STATISTICS WHERE SCHEMA_NAME = ‘ksqueens’ AND TABLE_NAME = ‘certification’;’: Unknown table ‘column_statistics’ in information_schema (1109) mysqldump: Couldn’t execute 'SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, ‘$.“number-of-buckets-specified”’) FROM information_schema.COLUMN_STATISTICS WHERE SCHEMA_NAME = ‘ksqueens’ AND TABLE_NAME = ‘certificationcourses’…
• 10:53:08 AM : ERROR: Failed to backup “tlc_prod” database with “Full” backup type: mysqldump: [Warning] Using a password on the command line interface can be insecure. mysqldump: Couldn’t execute ‘SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, ‘$.“number-of-buckets-specified”’) FROM information_schema.COLUMN_STATISTICS WHERE SCHEMA_NAME = ‘tlc_prod’ AND TABLE_NAME = ‘aggregatedcounter’;’: Unknown table ‘column_statistics’ in information_schema (1109) mysqldump: Couldn’t execute ‘SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, ‘$.“number-of-buckets-specified”’) FROM information_schema.COLUMN_STATISTICS WHERE SCHEMA_NAME = ‘tlc_prod’ AND TABLE_NAME = ‘counter’;’: Unknown table ‘column_statistics’ in information_schema (1109) mysqldump: Couldn’t execute ‘SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, ‘$.“number-of-buckets-specified”’) FROM information_schema.COLUMN_STATISTICS WHERE SCHEMA_NAME = ‘tlc_prod’ AND TABLE_NAME = ‘delmetest’;’: Unknow…
• 10:53:10 AM : Cleaning up backups of “Kseeker_Scheduled_Job” job.
• 10:53:12 AM : ERROR: Job “Kseeker_Scheduled_Job” finished with “3” errors

kindly anyone tell me the solution??

Hi Ibtisam_Hussain,

Thanks for the details. Could you please go to the “MySQL Backup Options” and set “Generate statistics histograms” to “Default” it should resolve the issue if it doesn’t help, please try to set to “No”.

Thank you and sorry for the inconvenience.