kissybissy Posted December 1, 2006 Share Posted December 1, 2006 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??? Link to comment Share on other sites More sharing options...
bfarber Posted December 1, 2006 Share Posted December 1, 2006 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. Link to comment Share on other sites More sharing options...
kissybissy Posted December 1, 2006 Share Posted December 1, 2006 it has about 15,000 posts. Link to comment Share on other sites More sharing options...
Volvospeed Posted December 1, 2006 Share Posted December 1, 2006 it has about 15,000 posts.Cpanel will back that up no problem. Link to comment Share on other sites More sharing options...
Jaggi Posted December 3, 2006 Share Posted December 3, 2006 do it via the sql console either in dos or shell depending on your pc system. Link to comment Share on other sites More sharing options...
compindustries Posted December 4, 2006 Share Posted December 4, 2006 Use SSHCommand:mysqldump --opt -u (username) -p (database name) > /path/to/where/backup.sql Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.