View Single Post
  #20 (permalink)  
Old 11-09-2007, 11:22 PM
priyan priyan is offline
D-Web Sr.Programmer
 
Join Date: Mar 2007
Posts: 133
priyan is on a distinguished road
Default Re: mysql database dump tips and tricks

Yes, increasing RAM / Buffer size could solve this problem.

We can also use

Quote:
--skip-quick
Generally mysqldump uses --quick option by default. --quick option will retrieve data from table one by one rather than loading the entire data from large table and buffer it in memory before dumping it. This could cause excessive memory usage. You can use --skip-quick option if you want skip this option.
__________________
Keep smiling...

Last edited by priyan : 12-18-2007 at 07:13 AM.
Reply With Quote