Database backup
 

hi there i have problem but i dont know what is problem exactly , with database always doing backup of database via ADMINCP but my backup have 500MB when i download database i get just 150 MB and nothing.. in end of sql i open with notepad in end must write "DATABASE DUMP COMPLETET" right!! but i get this error/!?

:confused: vB 3.8.4 PL1

Fatal error</b>: Maximum execution time of 30 seconds exceeded in <b>/home/alboz/public_html/includes/class_core.php</b> on line <b>715</b><br />

Hi in my opinion the safeway to do a back up is from your cpanel not the admin cp

Moved to vB3 discussions.


From the manual:
Backing Up The Database via SSH/Telnet or
Backing Up The Database via phpMyAdmin

Restoring The Database via SSH/Telnet or
Restoring The Database via phpMyAdmin

If you don't have shell access, some people have also reported success with these scripts:
MySQLDumper
MySQLHotxcopy
Bigdump

i have proved this script
MySQLDumper
MySQLHotxcopy
Bigdump


the bigdump is for import not for backup

So i have just one problem when sending email to users i give error just 1000 email going .. then get error

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@xxxxxxxxxxx.net and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

Why not use the automatic db backup script by Paul M?
Works fine with big boards.

does not work the paul script i try many time :S

It does :)
Just have to make a directory
/home/user/backups - chmod 777

then run it.

yyes is 777 but i get this error when run from scheduled task

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster @ xxxxxxxxxxxx and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

You set the path correctly?
/home/username/backups
create a folder lol, same level as public_html

lol i have create folder bro

/public_html/backups :S