Exporting database - unknown or incorrect time zone
mysql, phpmyadmin, xampp
Solution
- set export method to "custom"
- 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
Problem
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' ```