Skip to content

Instantly share code, notes, and snippets.

@dhrp

dhrp/insert.db.sql

Created June 25, 2013 08:57
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dhrp/5857028 to your computer and use it in GitHub Desktop.
Save dhrp/5857028 to your computer and use it in GitHub Desktop.
Download ZIP
mysql -f -uadmin -p****** admin_magento5 < db
Raw
insert.db.sql
Result of mysql import with -f (force) option
bash-3.2# mysql -f -uadmin -p********* admin_magento5 < db
ERROR 1062 (23000) at line 1374: Duplicate entry '1633-81-0' for key 2
ERROR 1062 (23000) at line 1409: Duplicate entry '1601-64-0' for key 2
ERROR 1062 (23000) at line 1479: Duplicate entry '1601-70-0' for key 2
ERROR 1062 (23000) at line 1575: Duplicate entry '1611-62-0' for key 2
ERROR 1062 (23000) at line 1647: Duplicate entry '1611-71-0' for key 2
ERROR 1062 (23000) at line 5169: Duplicate entry '3394-13' for key 2
ERROR 1062 (23000) at line 5237: Duplicate entry '956-12' for key 2
ERROR 1062 (23000) at line 7990: Duplicate entry '2959169-1401' for key 2
ERROR 1062 (23000) at line 8099: Duplicate entry '2957050-837' for key 2
ERROR 1062 (23000) at line 8100: Duplicate entry '3037578-1129' for key 2
ERROR 1062 (23000) at line 8342: Duplicate entry '2011-07-01-0-395' for key 2
ERROR 1062 (23000) at line 8343: Duplicate entry '2012-05-01-0-303' for key 2
ERROR 1062 (23000) at line 8378: Duplicate entry '2011-01-01-0-66' for key 2
bash-3.2#
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment