Description:
1)dump-date(below are mysqldump --help output)
--dump-date Put a dump date to the end of the output.
dump-date TRUE
=================
As we all known,the dump-date default is true and write dump completed time in end of the dump file,"-- Dump completed on 2013-01-16 2:20:01" for example.
I want to display the start time in dump file at the first line
advantage:
a)If i give dump file to developer,tell him the method how to take out the start and end time from the backupset,i did't need to check crontab for find out the backupset's start time.
b)Work out the backupset elapse time easier.
2)log-error(below are mysqldump --help output)
--log-error=name Append warnings and errors to given file.
log-error (No default value)
=================
We have mass mysql hosts,and write a script for monitor the error file generally,it send mail if the error file add and content.
a)Advise this parameter default value setting to std error file(hostname.err)
How to repeat:
no
Suggested fix:
1)copy several source code from write_footer to write_header in client/mysqldump.c and then modify the mysqldump help
==============================
if (opt_dump_date)
{
char time_str[20];
get_date(time_str, GETDATE_DATE_TIME, 0);
print_comment(sql_file, 0, "-- Dump completed on %s\n", time_str);
}
else
print_comment(sql_file, 0, "-- Dump completed\n");
check_io(sql_file);
==============================
2）no
Description: 1)dump-date(below are mysqldump --help output) --dump-date Put a dump date to the end of the output. dump-date TRUE ================= As we all known,the dump-date default is true and write dump completed time in end of the dump file,"-- Dump completed on 2013-01-16 2:20:01" for example. I want to display the start time in dump file at the first line advantage: a)If i give dump file to developer,tell him the method how to take out the start and end time from the backupset,i did't need to check crontab for find out the backupset's start time. b)Work out the backupset elapse time easier. 2)log-error(below are mysqldump --help output) --log-error=name Append warnings and errors to given file. log-error (No default value) ================= We have mass mysql hosts,and write a script for monitor the error file generally,it send mail if the error file add and content. a)Advise this parameter default value setting to std error file(hostname.err) How to repeat: no Suggested fix: 1)copy several source code from write_footer to write_header in client/mysqldump.c and then modify the mysqldump help ============================== if (opt_dump_date) { char time_str[20]; get_date(time_str, GETDATE_DATE_TIME, 0); print_comment(sql_file, 0, "-- Dump completed on %s\n", time_str); } else print_comment(sql_file, 0, "-- Dump completed\n"); check_io(sql_file); ============================== 2）no