Database backup

[bleros]

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

[steve1966]

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

[Lynne]

Moved to vB3 discussions.


From the manual:
Backing Up The Database via SSH/Telnet (http://www.vbulletin.com/forum/../docs/html/maintenance_ssh_backup) or
Backing Up The Database via phpMyAdmin (http://www.vbulletin.com/forum/../docs/html/maintenance_phpmyadmin_backup)

Restoring The Database via SSH/Telnet (http://www.vbulletin.com/forum/../docs/html/maintenance_ssh_restore) or
Restoring The Database via phpMyAdmin (http://www.vbulletin.com/forum/../docs/html/maintenance_phpmyadmin_restore)

If you don't have shell access, some people have also reported success with these scripts:
MySQLDumper (http://www.mysqldumper.de/en/index.php)
MySQLHotxcopy (http://www.vbulletin.com/forum/showthread.php?t=134821&highlight=mysqlhotcopy)
Bigdump (http://www.ozerov.de/bigdump.php)

[bleros]

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.

[ChopSuey]

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

[bleros]

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

[ChopSuey]

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

then run it.

[bleros]

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.

[ChopSuey]

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

[bleros]

lol i have create folder bro

/public_html/backups :S

[ChopSuey]

NOT IN PUBLIC_HTML!!!!
just when you login to your server via ftp, create a new folder there.

[bleros]

aha but i know in lol but now i get this error

Automatic Database Backup for vBulletin
An error occured during the Backup :

[ChopSuey]

You need to CHMOD the directory to 777

[bleros]

hyh is 777 i set to 777

[ChopSuey]

You set the path correctly?
Got to be like this
/home/user/public_html

Backups:

/home/user/backups

Got it?

[bleros]

bro path is correct .

[ChopSuey]

If you get that error then path is not chmodded to 777 or its incorrect.
Dont want to be posting the same thing over and over so thats the only problem.

[bleros]

bro look i create folder backups but why when i run manual from Scheduled Tasks one folder is created with backups2009 and date and the backups continues but is stoped with error in my admicp internal server error

see pic
http://img710.imageshack.us/img710/1308/80315426.png

[ChopSuey]

I believe the modification IS supported :)
maybe ask in the thread.