Fix MYSQL ERROR 1406 (22001) at line...
Hello, I’m following your tutorial on how to import databases in mysql
I receive the following error after attempting to import:
ERROR 1406 (22001) at line 5450: Data too long for column ‘IP’ at row 1
I suspect the error is due to how the import is executed: By creating a blank database first, then importing.
Is there a way to import the database without creating a blank one beforehand?
This is for a WordPress database.
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.×