I hae a problem with exporting/importing an mysql database.
- I have a good working xampp
- I have a good working joomla website under localhost
When I export the specific database to an plain sql file (all default options) in xampp phpadmin it results in an sql file and reports something about a timezone.
I have tried to understand the documentation, but sorry I really do not understand where I have tochange this option or with WHAT value to set a variable.
With earlier versions of xampp-phpadmin I have never met such errors.
====result of the export =====
<div class="error"><h1>Fout</h1><p><strong>SQL-query:</strong>
<a href="db_sql.php?sql_query=SET+time_zone+%3D+%22%2B00%3A00%22&show_query=1&db=acaadmin-3&token=cc0ab3c9b3e0f3022bbdca650829d90d"><span class="nowrap"><img src="themes/dot.gif" title="Wijzigen" alt="Wijzigen" class="icon ic_b_edit" /> Wijzigen</span></a> </p>
<p>
<code class="sql"><pre>
SET time_zone = "+00:00"
</pre></code>
</p>
<p>
<strong>MySQL meldt: </strong><a href="./url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.7%2Fen%2Ferror-messages-server.html" target="mysql_doc"><img src="themes/dot.gif" title="Documentatie" alt="Documentatie" class="icon ic_b_help" /></a>
</p>
<code>#1298 - Unknown or incorrect time zone: '+00:00'</code><br/></div>
========end========
Can someone help me with this issue.
Thanks a lot
Regards
Jan van IJsseldijk