When importing a dump file: Error code:1406. Data too long for Column-mysql

MySQL would truncate any insert value that exceeds the specified column width.

The without error try Switch your MySQL mode to the use STRICT.

Here some docs

EDIT:

To change the mode

This can is done in the ways:

1. Open your "My.ini" file within the MySQL installation directory, and look for the text "Sql-mode".

Find:

Code:

# Set the SQL mode to strict sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Replace with:

Code:

# Set the SQL mode to strict sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Or

2. You can run an SQL query within your database management tool, such as PhpMyAdmin:

Code:

SET @@global.sql_mode= ‘‘;

When importing a dump file: Error code:1406. Data too long for Column-mysql