Database Export - Unknown or Incorrect Time Zone

I am trying to export a database using phpMyAdmin 3.4.5 in the same way as I did many times.

But there are html tags in the .sql file. So, I saved .sql as .html and opened it. The message appears:

Error SQL query: Edit Edit SET time_zone = "+00:00" MySQL said: Documentation #1298 - Unknown or incorrect time zone: '+00:00' 
+6
source share
5 answers
  • set the export method to "custom"
  • uncheck the "TIMESTAMP dump in UTC (allows you to reset TIMESTAMP columns and restart between servers in different time zones)" in the very bottom corner of the page

tested on XAMPP for Windows 5.6.19-0

0
source

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

You can set the time zone.

 SET time_zone = 'America/Los_Angeles'; 

or

 SET time_zone = '00:00'; 

Not

 SET time_zone = "+00:00"; 
+2
source

I tried all the solutions found on the Internet, but nothing works. Maybe I can’t apply them !!!! But if you encounter the same problem and you can change phpMyAdmin settings, you can easily eliminate flag deletion during UTC export in sql export settings. Sorry, I could not be more exaustive, because I am using the Italian version of XAMPP and phpMyAdmin. Please excuse my bad English.

+2
source

I have the same problem on my Mac. I know how to solve this problem. I get access to phpmyadmin at this link

  http: //longs-macbook-pro.local/phpmyadmin 
(Long is my name)
NOT
  http: // localhost / phpmyadmin / 
Hope you can solve this problem.
0
source

If Timezone is missing, for Linux, BSD, and Mac OS X you need to load the timezone table into the mysql database to support all cities:

 mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -uroot mysql 

This will support all these time zones:
https://en.wikipedia.org/wiki/List_of_tz_database_time_zones

0
source

Source: https://habr.com/ru/post/914514/


All Articles