解决MYSQL工具mysqldump 遇到 Out of memory 方法
由于MYSQL数据库庞大，当使用mysqldump导出文件时碰到Out Of
Memory （10445）时只需在命令mysqldump后面加上-q 即可解决；
使用 -q (--quick) 的参数, 使用此参数就不会使用到 Memory.
例如: mysqldump -q -u root DB_NAME > DB_NAME.sql
说明如下:
--quick, -q
This option is useful for dumping large tables.
It forces mysqldump to retrieve rows for a table from the server a row at a time rather than retrieving the entire row set and buffering it in memory before writing it out.
come from：http://u.besgold.com/space-1-do-blog-id-17232.html
例如: mysqldump -q -u root DB_NAME > DB_NAME.sql
说明如下:
--quick, -q
This option is useful for dumping large tables.
It forces mysqldump to retrieve rows for a table from the server a row at a time rather than retrieving the entire row set and buffering it in memory before writing it out.
come from：http://u.besgold.com/space-1-do-blog-id-17232.html
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/90618/viewspace-661681/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- Oracle Temp 表空间切换
- 一步一步搭建oracle 11gR2 rac+dg之共享磁盘设置(三)
- Oracle dataguard failover 实战
- RMAN restore fails with ORA-01180: can not create datafile 1 (文档 ID 1265151.1)
- oracle process设置的注意事情
- Oracle 11gR2 Active DataGuard配置Step By Step（三）
- Oracle 10g DataGuard物理主备切换-switchover与failover
- oracle 10g dg切换步骤记录
- oracle 10g physical standby 切换操作
- Archiving not possible: No primary destinations errors
