While performing a Database Backup, you may encounter the following error:
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column '' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by.
This is an error returned from the MySQL Process. We have found that changing the MySQL mode to only_full_group_by can resolve this issue. To do this, please run the following MySQL query.
SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));After setting the MySQL mode, try running the backup again and see if the error persists.
