更新时间:2022-09-16 15:22:01
SET TIME_ZONE='+00:00' at top of dump to allow dumping of TIMESTAMP data when a server has data in different time zones or data is being moved between servers with different time zones.
mysql> select * from t1; +----+---------------------+ | id | cur_time | +----+---------------------+ | 1 | 2010-03-14 08:58:18 | +----+---------------------+
mysqldump --tz-utc=1 -t test t1 > t1.sql #查看内容 cat t1.sql /*!40103 SET TIME_ZONE='+00:00' */; .... INSERT INTO `t1` VALUES (1,'2010-03-14 00:58:18');
mysqldump --tz-utc=0 -t test t1 > t1_1.sql
#查看内容
cat t1_1.sql
INSERT INTO `t1` VALUES (1,'2010-03-14 08:58:18');