Installation and configuration iussues

Moderators: egami, macek, gesf

Post Reply
New php-forum User
New php-forum User
Posts: 8
Joined: Thu Apr 14, 2005 6:13 am

Thu Apr 14, 2005 1:38 pm

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.

Post Reply