Unable to restore mysql database from dump

MySQL & MariaDB
1

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…

2

Hi @Bhargav_Naidu_M

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.

Pep

3

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.

4

Once i dropped the database and recreated, some tables are automatically getting created.

5

Did dropping the database and recreating it fix the issue?