How to skip row when importing bad MySQL dump

mysql bash backup mysqldump mysql-error-1062
Almad picture Almad · Oct 1, 2011 · Viewed 69.1k times · Source

Given bad mysqldump that causes error on import:

namtar backups # mysql -p < 2010-12-01.sql
Enter password: 
ERROR 1062 (23000) at line 8020: Duplicate entry 'l�he?' for key 'wrd_txt'

Is there an easy way to tell import to just skip given row and continue?

(Yes, I know I can manually edit the file or parse output, but it's not very convinient)

Answer

jmlsteele picture jmlsteele · Oct 1, 2011

If you can make the dump again you could add --insert-ignore to the command-line when dumping.

Or you can try using the mysqlimport command with --force,which will continue even if it encounters MySQL Errors.

Related questions

Suppress warning messages using mysql from within Terminal, but password written in bash script

When I tried running the following command on MySQL from within Terminal: mysql -u $user -p$password -e "statement" The execution works as expected, but it always issues a warning: Warning: Using a password on the command line interface can …

Read More
Install MySQL on Ubuntu without a password prompt

How do I write a script to install MySQL server on Ubuntu? sudo apt-get install mysql will install, but it will also ask for a password to be entered in the console. How do I do this in a non-interactive …

Read More
How to run mysql command on bash?

The following code works on the command line mysql --user='myusername' --password='mypassword' --database='mydatabase' --execute='DROP DATABASE myusername; CREATE DATABASE mydatabase;' However, it doesnt work on bash file on excecution #!/bin/bash user=myusername password=mypassword database=mydatabase …

Read More