Anand Siddharth Anand Siddharth - 3 months ago 9
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