<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<font size="-1">I think I just found out something nasty.<br>
<br>
<font face="Courier New, Courier, monospace">ubuntu@arm:~$
date;salt 'select
inbound_call_log_id,started,UNIX_TIMESTAMP(started) from
inbound_call_log limit 1'<br>
Sat May 31 00:16:56 UTC 2014<br>
+---------------------+---------------------+-------------------------+<br>
| inbound_call_log_id | started |
UNIX_TIMESTAMP(started) |<br>
+---------------------+---------------------+-------------------------+<br>
| 1 | 2014-05-22 16:53:39 |
1400777619 |<br>
+---------------------+---------------------+-------------------------+<br>
<br>
[support@support ~]$ date ; mysql -h 127.0.0.1 -e 'select
inbound_call_log_id, started,UNIX_TIMESTAMP(started) from
inbound_call_log limit 1' SALT;<br>
Fri May 30 20:16:40 EDT 2014<br>
+---------------------+---------------------+-------------------------+<br>
| inbound_call_log_id | started |
UNIX_TIMESTAMP(started) |<br>
+---------------------+---------------------+-------------------------+<br>
| 1 | 2014-05-22 16:53:39 |
1400792019 | <br>
+---------------------+---------------------+-------------------------+<br>
[support@support ~]$ </font><br>
<br>
support is a mysql slave. Does this mean my data is only valid if
I restore it on a server in the UTC zone? The slave is in
US/Eastern and the master is in UTC.<br>
<br>
Chris<br>
<br>
</font>
</body>
</html>