Reset Search
 

 

Article

Backup fails with mysqlbackup: ERROR: InnoDB: An optimized(without redo logging) DDLoperation has been performed

« Go Back

Information

 
TitleBackup fails with mysqlbackup: ERROR: InnoDB: An optimized(without redo logging) DDLoperation has been performed
Symptoms
Back up with Extreme Management Center show error that the backup timed out.
CLI back shows error:  mysqlbackup: ERROR: InnoDB: An optimized(without redo logging) DDLoperation has been performed. All modified pages may not have been flushed to the disk yet. 
MEB will not be able take a consistent backup. Retry the backup operation. 

mysqlbackup failed with errors!
Environment
  • Extreme Management
  • NetSight
  • Console
Cause
Resolution
Add the following entry to the /Extreme_Management_Install_path/NetSight/mysql/my.ini

old_alter_table=1

Restart the server and database services and try again.
Additional notes

Feedback

 

Was this article helpful?


   

Feedback

Please tell us how we can make this article more useful.

Characters Remaining: 255