Time_zone variable cannot be set to null
I have a fairly new WampServer setup and when I use the original command on a new database:
source path/to/database.sql
Everything looks like
Query OK
Except for this bunch of errors at the end:
ERROR 1231 (42000): Variable ‘time_zone’ can’t be set to the value of ‘NULL’
ERROR 1231 (42000): Variable ‘sql_mode’ can’t be set to the value of ‘NULL’
ERROR 1231 (42000): Variable ‘foreign_key_checks’ can’t be set to the value of ‘NULL’
ERROR 1231 (42000): Variable ‘unique_checks’ can’t be set to the value of ‘NULL’
ERROR 1231 (42000): Variable ‘character_set_client’ can’t be set to the value of ‘NULL’
Query OK, 0 rows affected (0.00 sec)
ERROR 1231 (42000): Variable ‘collation_connection’ can’t be set to the value of ‘NULL’
ERROR 1231 (42000): Variable ‘sql_notes’ can’t be set to the value of ‘NULL’
I installed WAMP environments before and didn't have these errors.
+3
source to share
1 answer
If you are using a 64-bit WAMPServer, there was a small bug in the 64-bit version.
Edit the file my.ini
and change the section title from
[wampmysqld]
to
[wampmysqld64]
The header must match the service name that WAMPServer installs MYSQL as in the 64 bit version, the MYSQL service is called wampmysqld64
+1
source to share