I've attached an updated version of the shell script which handles the change in recent versions where there are multiple users per mysql database.
And here are a few extra lines to add to the end of the sed script (/root/scripts/convert_date.sed):
# Mon, 4 07 2005 09:59:05 +0200 (CEST)
s/^[A-Z][a-z][a-z], \([0-9][0-9]*\) \([0-9][0-9]\) \([0-9][0-9][0-9][0-9]\) \([0-9][0-9]:[0-9][0-9]:[0-9][0-9]\) +\([0-9]*.*\)$/\3-\2-\1 \4/
s/-\([1-9]\) /-0\1 /
Rgds - Angus |