Full Error: Warning: #1264 Out of range value adjusted for column ‘id’ at row 1 We have a database that was used to store some valuable data. The Id column was set to auto increment when a new record was inserted. After about 127 records we started to get the above error message. come to [...]
[[Category:MySQL]] Reference: http://dev.mysql.com/doc/refman/5.1/en/time-zone-support.html Some customer will attempt to use the SET SESSION time_zone query to set the time zone for their database. This will only work if we have loaded the zone data into the mysql.time_zone_name Table. One of the error will be mysql> SET SESSION time_zone = ‘US/Central’; ERROR 1298 (HY000): Unknown or incorrect [...]
You will need to convert you Excel worksheet to a csv file by saving it as .csv If you have mysql installed locally on your pc , you can run the following query to import your data . *please note you should remove the first column which includes the columns titles. * LOAD DATA local [...]
Seems it is no longer enough to have localhost in the servers local hosts file (C:\Windows\System32\drivers\etc\hosts) you also have to comment out or remove the IPv6 equivalent. 127.0.0.1 localhost #::1 localhost **this seem to work only when connecting locally ** Thanks Bruce
– packet 6 bytes shorter than expected in – Client does not support authentication protocol requested by server; consider upgrading MySQL client Error: This means you are connecting to a mysql server using the new hash client while the server is setup to receive the old. You will first need to make sure old-password is [...]