由于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博客 ” ,链接:http://blog.itpub.net/90618/viewspace-661681/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/90618/viewspace-661681/