mysql source 忽略错误继续执行

最新推荐文章于 2025-10-22 19:39:41 发布

原创最新推荐文章于 2025-10-22 19:39:41 发布 · 2w 阅读

5 ·

CC 4.0 BY-SA版权

MySql 专栏收录该内容

151 篇文章

订阅专栏

本文探讨了在使用MySQL命令行工具进行批量数据导入时遇到的问题，并提供了如何避免因单条语句错误而导致整个导入过程失败的有效解决方案。

mysql -h$1 -P$2 -u$3 -p$4 -D$5 -s -N -e " source$TAB_ONLY_LIST"

发现一个语句报错，整个过程就失败了。

增加--force 或-f依旧报错

mysql -h$1 -P$2 -u$3 -p$4 -D$5 -s -N -f -e " source$TAB_ONLY_LIST"

网上查了一下，说这不是bug，解决方案是

mysql -h$1 -P$2 -u$3 -p$4 -D$5 -s -N -f <"$TAB_ONLY_LIST"

https://bugs.mysql.com/bug.php?id=533

Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

--force is intended to be used in Batch Mode only. I.e. like:

mysql --force < myscript.sql

# Unix style
cat myscript.sql | mysql --force

# Windows style
type myscript.sql | mysql --force

-e "" is intened to send Single query or command that's why --force does not make much sence for it. Single query can either succeed or fail. Maning of --force is to continue executing batch of queries even if some of them fail. Without it mysql will stop after first error.