Pak Jiddat

Read: In the name of thy Lord Who createth, Createth man from a clot. Read: And thy Lord is the Most Bounteous, Who teacheth by the pen, Teacheth man that which he knew not. Nay, but verily man is rebellious That he thinketh himself independent!. Lo! unto thy Lord is the return. (Sura Alalaq 96:8)

Ignoring errors during MySQL import

Created On: 01 May, 2018: 11:48:59 - Tags : command line tools | database management

Url: https://stackoverflow.com/questions/11263018/mysql-ignore-errors-when-importing

While importing large database backups we may come across errors such as duplicate indexes. It would be useful to ignore such minor errors. The mysql command provides the --force switch which allows us to ignore the errors. For example:


sudo mysql -u {mysql_user} -p --force < {sql_file}

Related Articles

  1. Removing ONLY_FULL_GROUP_BY sql mode
  2. Upgrading Postgresql from version 9.4 to 9.6
  3. Upgrading MySQL server from version 5.6 to 8.0
  4. MariaDB/MySQL user password not being set
  5. Sorting a MySQL string column as a number
  6. MySQL server out of resources
  7. MySQL Tuner
  8. Create backup of Mongo Db database
  9. Deleting a Mongo Db database
  10. Restoring a database backup in Plesk
  11. How to login to MySQL server as root user on Plesk
  12. List all databases for Postgresql
  13. Solution for mysql header mismatch error
  14. Backing up and Restoring MongoDB data
  15. Removing Replication in MongoDb
  16. Exporting Mysql database data in CSV format using Mysql Work Bench
  17. Generating free SSL certificate from LetsEncrypt on localhost
  18. Running Plesk auto reapir
  19. Viewing package information using yum history command
  20. Deleting empty folders recursively using Linux command line tools
  21. Deleting files older than 1 year using Linux command line tools
  22. Setting file permissions with rsync
  23. Using Rsync over custom SSH port
  24. Finding name server records for domains using Dig
  25. Backing up and restoring LXD containers
  26. Resizing Linux root partitions without unmount on Google Cloud
  27. Running multiple versions of mailx command
  28. Using PSCP command for copying files and directories
  29. Configuring SFTP/SSH access for LXC Containers
  30. Debugging programs on Linux using strace
  31. Generate Certificate Signing Request (CSR) for ssl certificates
  32. Split large files using split command in Linux
  33. Monitoring user activity with acct package
  34. Error in pushing changes to remote git repository
  35. Permanently authenticating with remote git repositories
  36. Passing command line arguments to Python script
  37. List users currently logged in
  38. Using Redir command for redirecting ports
  39. Importing Ldap configuration from file gives, "Wrong attributetype" error
  40. How To Change Account Passwords on an OpenLDAP Server
  41. Sending email through Gmail server using mailx command
  42. Fetching website resource over https using wget
  43. Delete downloaded file using Wget
  44. Using Oauth2l
  45. How to Backup and Restore LXC containers
  46. Fix ntfs disk is corrupt error
  47. Recover deleted files on ext3/ext4 file system using Photorec
  48. Convert pdf files to text files
  49. Using Rsync to copy all files recursively into one folder
  50. Viewing number of files in directory
  51. Using SED tool for replacing text in files
  52. Automate scp command using sshpass