View Single Post
  #12  
Old 6th February 2010, 21:27
go0ogl3 go0ogl3 is offline
Member
 
Join Date: Jul 2008
Posts: 69
Thanks: 4
Thanked 38 Times in 6 Posts
Smile Optimize not suported by the database

Quote:
Originally Posted by jmp51483 View Post
I'm receiving the following error when trying to use your script... any ideas??

./back-res: line 238: [: -gt: unary operator expected
mysql.general_log
note : The storage engine for the table doesn't support optimize
mysql.slow_log
note : The storage engine for the table doesn't support optimize
This is because that particular database is not supporting the optimize option of mysql. This is an error which does NOT really interfere with the backup option, the database is still backed up, you can check this by looking at the database archive from that day.

This appears because I've included an optimize function of all databases before back up.
Reply With Quote