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. Generating free SSL certificate from LetsEncrypt on localhost
  2. Running Plesk auto reapir
  3. Viewing package information using yum history command
  4. Deleting empty folders recursively using Linux command line tools
  5. Deleting files older than 1 year using Linux command line tools
  6. Setting file permissions with rsync
  7. Using Rsync over custom SSH port
  8. Finding name server records for domains using Dig
  9. Backing up and restoring LXD containers
  10. Resizing Linux root partitions without unmount on Google Cloud
  11. Running multiple versions of mailx command
  12. Using PSCP command for copying files and directories
  13. Configuring SFTP/SSH access for LXC Containers
  14. Debugging programs on Linux using strace
  15. Generate Certificate Signing Request (CSR) for ssl certificates
  16. Split large files using split command in Linux
  17. Monitoring user activity with acct package
  18. Error in pushing changes to remote git repository
  19. Permanently authenticating with remote git repositories
  20. Passing command line arguments to Python script
  21. List users currently logged in
  22. Using Redir command for redirecting ports
  23. Importing Ldap configuration from file gives, "Wrong attributetype" error
  24. How To Change Account Passwords on an OpenLDAP Server
  25. Sending email through Gmail server using mailx command
  26. Fetching website resource over https using wget
  27. Delete downloaded file using Wget
  28. Using Oauth2l
  29. How to Backup and Restore LXC containers
  30. Fix ntfs disk is corrupt error
  31. Recover deleted files on ext3/ext4 file system using Photorec
  32. Convert pdf files to text files
  33. Using Rsync to copy all files recursively into one folder
  34. Viewing number of files in directory
  35. Using SED tool for replacing text in files
  36. Automate scp command using sshpass