Pak Jiddat - Innovative Software Services

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