set @file = CONCAT ('
-u root tableName>/backup/tableName', CURRENT_DATE(), '.sql'
)
mysqldump @file
is resulting in an error in syntax.
I just want to dump a backup - every day - labeled with the current date.
but I'm a mysql noob and I have been hunting for the correct syntax long enough I thought that I would ask...