Results 1 to 1 of 1
I just backup my mysql db using mysqldump. I run it around 6pm of the evening but I just notice that on the last part of the dump file, it ...
- 01-15-2010 #1Linux Newbie
- Join Date
- Mar 2006
- Posts
- 101
mysqldump completed time different on system time
I just backup my mysql db using mysqldump. I run it around 6pm of the evening but I just notice that on the last part of the dump file, it says "Dump completed on 2010-01-14 11:30:01". The time is "Jan 14 19:30" when I run mysqldump. Though the content is corrent, I still want to know why the dump reported it was completed but wrong time. I don't have my.cnf on my /etc so it means all was default by mysql. If I'm not mistaken, timezone by default in mysql is gmt.
My /etc/sysconfig/clock is
When I do "select now();" on mysql shell, it was the same with my system.ZONE="Asia/Manila"
UTC=true
ARC=false
Anyone could be an idea why this happen? I want to prove my backup was right but this thing confuse me a bit.


Reply With Quote