MySQL client ran out of memory

Hi

While trying to backup a quite big vBulletin forum database - probably around 250 MB, on a virtual private server, it stopped and gave me this error:
MySQL Error : MySQL client ran out of memory
Error Number : 2008

Could someone please suggest what to do to have the big database backed up? Thank you.

 

check your php memory settings! some parameters define the RAM allowed for each scripts at execution time.

Check for this one:
memory_limit = 60M ; Maximum amount of memory a script may consume

 

Don't backup and restore large databases through web interfaces.
Open a shell and type (replace username, password, database_name, filename):

mysqldump --opt --no-create-db --user=username --password=password database_name > filename.sql

Code (markup):

andre restore via:

mysql --user=username --password=password database_name < filename.sql

Code (markup):

Its lightning fast. You can put that in your crontab and it won't create any of those problems.

 

Ditto. Shell is the best way for uploading/downloading large MySQL database files, and won't put all the strain on your server/VPS.

 

Many thanks pals ! I followed your advice and it went smooth and fine.