# Unable to restore mysql database from dump

**URL:** <https://forums.percona.com/t/unable-to-restore-mysql-database-from-dump/21340>\
**Category:** MySQL & MariaDB\
**Tags:** mysql\
**Created:** [April 11, 2023, 7:24pm UTC](https://forums.percona.com/t/unable-to-restore-mysql-database-from-dump/21340 "2023-04-11T19:24:29Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bhargav\_Naidu\_M](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/bhargav_naidu_m/32/9767_2.png) [@Bhargav\_Naidu\_M](https://forums.percona.com/u/Bhargav_Naidu_M)\
**Post date:** [April 11, 2023, 7:24pm UTC](https://forums.percona.com/t/unable-to-restore-mysql-database-from-dump/21340/1 "2023-04-11T19:24:29Z")

</div>

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…

---

<div class="post-metadata">

**Author:** ![Pep\_Pla](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pep_pla/32/9735_2.png) [@Pep\_Pla](https://forums.percona.com/u/Pep_Pla)\
**Post date:** [April 11, 2023, 8:04pm UTC](https://forums.percona.com/t/unable-to-restore-mysql-database-from-dump/21340/2 "2023-04-11T20:04:32Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Bhargav\_Naidu\_M](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/bhargav_naidu_m/32/9767_2.png) [@Bhargav\_Naidu\_M](https://forums.percona.com/u/Bhargav_Naidu_M)\
**Post date:** [April 12, 2023, 6:45am UTC](https://forums.percona.com/t/unable-to-restore-mysql-database-from-dump/21340/3 "2023-04-12T06:45:15Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Bhargav\_Naidu\_M](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/bhargav_naidu_m/32/9767_2.png) [@Bhargav\_Naidu\_M](https://forums.percona.com/u/Bhargav_Naidu_M)\
**Post date:** [April 12, 2023, 7:12am UTC](https://forums.percona.com/t/unable-to-restore-mysql-database-from-dump/21340/4 "2023-04-12T07:12:35Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Pep\_Pla](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pep_pla/32/9735_2.png) [@Pep\_Pla](https://forums.percona.com/u/Pep_Pla)\
**Post date:** [April 12, 2023, 8:20am UTC](https://forums.percona.com/t/unable-to-restore-mysql-database-from-dump/21340/5 "2023-04-12T08:20:03Z")

</div>

Did dropping the database and recreating it fix the issue?