MySQL ERROR 1366 (HY000): Incorrect integer value: ” for column ‘id’ at row 1 Problem & Fix

 

Problem:

MySQL throw the following error message on insert or update statement executed

 

Why?

Try to update string value into integer column, and strict sql mode is enabled.

Mainly occurred on MySQL 5.x or above.

 

How to Fix:

1. Disable strict sql mode

Update /etc/my.cnf , and remove STRICT_TRANS_TABLES from sql-mode

 

References:

https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sqlmode_strict_trans_tables

Most Simple and Fastest Way to Backup and Restore a MySQL Database (mysqldump & mysql client)

How to mysqldump and mysql to backup and restore a database:

Backup to .sql file

 

Restore from .sql file

 

Suggested to run the command in database server to get the fastest speed.

 

References:

https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html

How to Install MySQL 5.7 on RHEL/CentOS 7

Basic Server Setup

 

 

 

Setup MySQL 5.7

 

 

Setup Firewall (Optional)

 

Reboot after Setup

 

Optional Settings for MySQL 5.7

Disable MySQL Strict Mode

Reference: https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html

 

Fix MySQL Password Expired

To establish a global policy such that passwords never expire.

Update /etc/my.cnf

Reference: https://dev.mysql.com/doc/refman/5.7/en/password-expiration-policy.html