Installation and configuration iussues

Moderators: macek, egami, gesf

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


Post by jakeharlan » 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

Who is online

Users browsing this forum: No registered users and 0 guests