Planned for 11.32 [case 50724] Overwrite existing MySQL database on backup restore

[jeroman8]

Installing stable build helped us (from release).
Now we can transfer accounts again and mysql is setup ok.

[sneader]

Yes, thank you for the quick work on this issue!

- Scott

[VeZoZ]

Installing stable build helped us (from release).
Now we can transfer accounts again and mysql is setup ok.

Well not running into this issue now but it's possible ran into another that is related. Noted a an account transfer the user had stored procedures which were not transferred across. Also the mysql user privileges to deal with the prcoedures was now broken as well. The user previously came from a mysql 5.0 server. So not sure if that played a role or not. Although generating a backup of database as the user via cPanel does not give you the stored procedure there either.

Really running into a lot of surprises restoring accounts lately with backups not being complete or when running a restore things not all being restored

[Kent Brockman]

Well not running into this issue now but it's possible ran into another that is related. Noted a an account transfer the user had stored procedures which were not transferred across. Also the mysql user privileges to deal with the prcoedures was now broken as well. The user previously came from a mysql 5.0 server. So not sure if that played a role or not. Although generating a backup of database as the user via cPanel does not give you the stored procedure there either.

Really running into a lot of surprises restoring accounts lately with backups not being complete or when running a restore things not all being restored

VeZoZ: the servers between that account was transferred had the same MySQL and cPanel versions?

[VeZoZ]

VeZoZ: the servers between that account was transferred had the same MySQL and cPanel versions?

5.0 on one 5.1 on the new one but same cPanel versions. I think the issue is probably with the backup process. I'm using the download mysql database option and it does not provide the procedures. I assume the same code is used in the full backup process when generating the backups of the databases. If cPanel is using mysqldump to retrieve the databases you need to actually specify a flag to get the procedures as by default it's set to not.

I'm thinking this has been a problem for a while and discovered it by luck when dealing with this other bug.

[Kent Brockman]

5.0 on one 5.1 on the new one but same cPanel versions. I think the issue is probably with the backup process. I'm using the download mysql database option and it does not provide the procedures. I assume the same code is used in the full backup process when generating the backups of the databases. If cPanel is using mysqldump to retrieve the databases you need to actually specify a flag to get the procedures as by default it's set to not.

I'm thinking this has been a problem for a while and discovered it by luck when dealing with this other bug.

Well, that's interesting. If nothing bad happens if you specify that flag in mysqldump even if there is no procedures to backup, this may be seen as a bug in cPanel, easy to correct by the way.
If anybody from cPanel staff is reading this, may this particular note be taken as a bug report?

[cPanelDavidG]

Well, that's interesting. If nothing bad happens if you specify that flag in mysqldump even if there is no procedures to backup, this may be seen as a bug in cPanel, easy to correct by the way.
If anybody from cPanel staff is reading this, may this particular note be taken as a bug report?

Sounds like a bug to me, please treat it as such and submit it via http://go.cPanel.net/bugreport so we can get that fixed (bypassing the usual filtering/community support process we do here in feature requests). Everyone experiencing this is welcome to file their own bug report. The more reports we get, the more weight it carries with our developers. Everyone who submits a report will be emailed when this bug is resolved.

[cpanelkenneth]

5.0 on one 5.1 on the new one but same cPanel versions. I think the issue is probably with the backup process. I'm using the download mysql database option and it does not provide the procedures. I assume the same code is used in the full backup process when generating the backups of the databases. If cPanel is using mysqldump to retrieve the databases you need to actually specify a flag to get the procedures as by default it's set to not.

I'm thinking this has been a problem for a while and discovered it by luck when dealing with this other bug.

The MySQL Database download pretty much just dumps the database and tables, without considering other data (e.g. triggers, events, routines, etc). We are currently examining this for change since some of those items can rightfully be understood to be part of the database schema.