There is a serious problem with the backups that Cpanel is creating on a nightly basis. We already reported it but its a big one.
For all who think their backups are working without incident, maybe you should run /scripts/cpbackups/ manually one night to see what im talking about.
There are issues with the backup of MySQL db's. Dont be surprised if you have to restore one of these backup to find a totally messed up mysql restore.
Here is an example of what we are seeing during backup time.
Grabbing mysql dbs............
Done
Grabbing mysql privs...DBD::mysql::st execute failed: There is no such grant defined for user 'hoodup4' on host 'localhost' at /usr/local/cpanel/Cpanel/Mysql.pm line 359.
DBD::mysql::st fetchrow_arrayref failed: fetch() without execute() at /usr/local/cpanel/Cpanel/Mysql.pm line 360.
DBD::mysql::st execute failed: There is no such grant defined for user 'hoodup4' on host 'localhost' at /usr/local/cpanel/Cpanel/Mysql.pm line 359.
DBD::mysql::st fetchrow_arrayref failed: fetch() without execute() at /usr/local/cpanel/Cpanel/Mysql.pm line 360.
Done
This happens on most of the backups where sites are hosting mysql. Not all but most. Its already been reported but i was told that its because our users have a dash in their usernames. We dont have one account where our users have a dash in their usernames.
For all who think their backups are working without incident, maybe you should run /scripts/cpbackups/ manually one night to see what im talking about.
There are issues with the backup of MySQL db's. Dont be surprised if you have to restore one of these backup to find a totally messed up mysql restore.
Here is an example of what we are seeing during backup time.
Grabbing mysql dbs............
Done
Grabbing mysql privs...DBD::mysql::st execute failed: There is no such grant defined for user 'hoodup4' on host 'localhost' at /usr/local/cpanel/Cpanel/Mysql.pm line 359.
DBD::mysql::st fetchrow_arrayref failed: fetch() without execute() at /usr/local/cpanel/Cpanel/Mysql.pm line 360.
DBD::mysql::st execute failed: There is no such grant defined for user 'hoodup4' on host 'localhost' at /usr/local/cpanel/Cpanel/Mysql.pm line 359.
DBD::mysql::st fetchrow_arrayref failed: fetch() without execute() at /usr/local/cpanel/Cpanel/Mysql.pm line 360.
Done
This happens on most of the backups where sites are hosting mysql. Not all but most. Its already been reported but i was told that its because our users have a dash in their usernames. We dont have one account where our users have a dash in their usernames.
