My host just upgraded to MySql version 3.23.59. This is the version I use on my local (test) machine.
There are two issues with the host's upgrade.
The first is the use of current_timestamp. This function seems to not exist on my local machine. When I try to execute a backup of my production database it fails on all create table statments with a timestamp field due to the current_timestamp command.
The second is the timestamp format. Prior to the host's upgrade the timestamp format was yyyymmddhhmmss.
Now the format is yyyy-mm-dd hh:mm:ss. How do I change my local MySql configuration so all timestamps are formatted as yyyy-mm-dd hh:mm:ss?
Any help on these two issues are greatly appreciated.