Hi guys
I am going to fetch out the data from remote mysql database according to
timestamps colmmen, however my local date is different from the one on
remote mysql database,
how can I get right timestamp using the date of remote time zone? that
is to say I set the date and send itto remote
When you are using SQL connected to the server (mysql -ublah) the timestamp
is the server one. If you use app time functions it will be client time.
Bottom line: use server sql functions.
Ciao
Claudio
Il giorno 4 lug, 2009 8:50 m., Nathan Huang nathan.vorbei.t...@gmail.com
ha scritto:
Hi guys
I
On 4 Jul 2009, at 07:48, Nathan Huang wrote:
I am going to fetch out the data from remote mysql database
according to timestamps colmmen, however my local date is different
from the one on remote mysql database,
how can I get right timestamp using the date of remote time zone?
that is to
Assuming that synchornizing the clocks between the systems is beyond
your control you could try getting the UTC timestamp from both
systems, then adjust your date/time math according to the difference
between them.
select unix_timestamp(utc_timestamp());
It is more than a little hacky, but it
Hi Tim,
On Mon, Jun 22, 2009 at 4:41 PM, Little,
Timothytlit...@thomaspublishing.com wrote:
We have a 20 gig db (that includes the MYIs and MYDs and FRMs).
We are wondering how long LVM snapshots take.. in that how long might
the DB be read-locked? Do we have to read-lock it and flush