Exporting database - unknown or incorrect time zone

Question

I'm trying to export database using phpMyAdmin 3.4.5 same way as I many times did.

But, in .sql file are html tags. So, I saved .sql as an .html and opened it. There is a message:

Error

SQL query: Edit Edit
SET time_zone = "+00:00"

MySQL said: Documentation
#1298 - Unknown or incorrect time zone: '+00:00' 

Answer 1

1. set export method to "custom"
2. uncheck "Dump TIMESTAMP columns in UTC (enables TIMESTAMP columns to be dumped and reloaded between servers in different time zones)" checkbox on the very bottom of the page

tested on XAMPP for Windows 5.6.19-0

Answer 2

http://www.electrictoolbox.com/mysql-set-timezone-per-connection/

You may want to set your time zone.

SET time_zone = 'America/Los_Angeles';

or

SET time_zone = '00:00';

Not

SET time_zone = "+00:00";