version : mysql Ver 14.14 Distrib 5.7.34-37, for debian-linux-gnu (x86_64) using 8.0
mysqldump -u root -p’password’ db_name > /tmp/db_name.sql
mysql -u root -p’password’ db_name < db_name.sql
While restore, We are facing below issue .
ERROR 1136 (21S01): Column count doesn’t match value count at row 1
Appriciate quick help here…
Could you try option -v in MySQL? This will generate a lot of logs but also tell you the table and the specific insert that fails.
Yes, from error message i’m able to see which insert is failing.
I see insert command column values are more compared to number of actual columns in table.
Not sure from where Mysqldump took the extra values.
Once i dropped the database and recreated, some tables are automatically getting created.
Did dropping the database and recreating it fix the issue?