MySQL Automatic backup failed

Today patrol found that JJM server automatic backup failed

650) this.width=650; "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/ Images/localimage.png ") no-repeat center;border:1px solid #ddd;" alt= "Spacer.gif"/>650 "this.width=650;" src= "http ://s5.51cto.com/wyfs02/m01/75/b9/wkiom1zbuaqrm4ioaabapjpzrjs219.jpg "title=" e1.jpg "alt=" Wkiom1zbuaqrm4ioaabapjpzrjs219.jpg "/>

1, view the backup processing file discovery, did not do database backup

650) this.width=650; "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/ Images/localimage.png ") no-repeat center;border:1px solid #ddd;" alt= "Spacer.gif"/>650 "this.width=650;" src= "http ://s1.51cto.com/wyfs02/m02/75/b9/wkiom1zbub6r0-uzaaobgnxbboo525.jpg "title=" e2.jpg "alt=" Wkiom1zbub6r0-uzaaobgnxbboo525.jpg "/>

2, by manually execute backup script, found error message

650) this.width=650; "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/ Images/localimage.png ") no-repeat center;border:1px solid #ddd;" alt= "Spacer.gif"/>650 "this.width=650;" src= "http ://s3.51cto.com/wyfs02/m00/75/b9/wkiom1zbuefyzf0paacebtx2vhg031.jpg "title=" e3.jpg "alt=" Wkiom1zbuefyzf0paacebtx2vhg031.jpg "/>

Find the table above the hint. Unable to lock table

3. Repair Process

650) this.width=650; "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/ Images/localimage.png ") no-repeat center;border:1px solid #ddd;" alt= "Spacer.gif"/>650 "this.width=650;" src= "http ://s4.51cto.com/wyfs02/m02/75/b9/wkiom1zbufuz3icoaapbwvgjfyk188.jpg "title=" e4.jpg "alt=" Wkiom1zbufuz3icoaapbwvgjfyk188.jpg "/>

4. After the repair is completed, the backup is successful again manually.

650) this.width=650; "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/ Images/localimage.png ") no-repeat center;border:1px solid #ddd;" alt= "Spacer.gif"/>650 "this.width=650;" src= "http ://s5.51cto.com/wyfs02/m02/75/b6/wkiol1zbulgrhoqqaabzvq9ikt4504.jpg "title=" e5.jpg "alt=" Wkiol1zbulgrhoqqaabzvq9ikt4504.jpg "/>

Summary: The need to continue tracking automatic backups will also fail, not quite sure why the automatic backup failed

2015-11-10

Fangy

This article is from the "Linux" blog, so be sure to keep this source http://fangyu.blog.51cto.com/4883282/1711295

MySQL Automatic backup failed