Anand Siddharth Anand Siddharth - 10 months ago 70
MySQL Question

mysqldump Disable conversion of datetime

mysqldump -u root -pPASSWORD databasename > db.sql


When process is completed. The dates in mysqldump convert into local timezone. How to prevent from converting dates. And remain the original date.

Answer

mysqldump --skip-tz-utc -u root -pPASSWORD databasename > db.sql

http://dev.mysql.com/doc/refman/5.7/en/mysqldump.html#option_mysqldump_tz-utc

Thankyou @Abhik