backing up your database

[kissybissy]

everytime I try to Back Up my SQL Database I get an error. I click on the link below the message "Once you have clicked the link below, please wait until your browser prompts you with a dialogue box. This may take some time depending on the size of the database you are backing up. " and it takes a long time loading, but the dialogue box does not appear, just a page saying the page could not be recovered.

I was told on IPSBeyond that is due to the size of the data base, which is too large to perform a back-up in the control panel. was something done to fix this error???

[bfarber]

There is nothing that CAN be done - how big is your db? If it's large enough, server resource restrictions (such as max_execution_time or memory_limit) will stop it, and there's little that can be done to work around it.

[kissybissy]

it has about 15,000 posts.

[Volvospeed]

it has about 15,000 posts.

Cpanel will back that up no problem.

[Jaggi]

do it via the sql console either in dos or shell depending on your pc system.

[compindustries]

Use SSH

Command:

mysqldump --opt -u (username) -p (database name) > /path/to/where/backup.sql