Jump to content

backing up your database

Featured Replies

Posted

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???

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.

it has about 15,000 posts.

it has about 15,000 posts.



Cpanel will back that up no problem.

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

Use SSH

Command:

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

Archived

This topic is now archived and is closed to further replies.

Recently Browsing 0

  • No registered users viewing this page.