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