Will not back up large database
phpMyBackupPro is the MySQL backup tool - especially without ssh!
Status: Abandoned
Brought to you by:
datz
Menu
▾
▴
#126 Will not back up large database
LINUX server
PHP Version 5.5.28
MySQL Version 5.6.28
phpmybackup version 2.5
Smaller DB has 6 tables, 14700 rows, 542KB
Larger DB has 23 tables, 28320 rows, 8.06MB
Smaller DB backs up OK, larger DB never gives a "completed" message, and .sql files are 0bytes.
Php.ini has memory_limit = 128M,
No error messages, after hitting "backup" screen goes blank, .sql file is 0 bytes.
This seems to be a problem with the php time limit.
Did you check the php log files?
http://php.net/manual/en/info.configuration.php#ini.max-execution-time explains how to increatse the time limit.
Try to increatse the may execution time.
memory_limit was too low (rookie mistake),
Script works fine when backing up from phpMyBackupPro/backup.php, but something is still amiss when I try to back up in a scheduled job.,
My max_execution_time was 30; changed it to 300, still have the problem. I'm downloading the error log now (I hope it's the right one).
The empty .sql files show up immediately in the "import" tab as 0 length files. It doesn't look as though the script is running for 30 seconds and dying; looks like it's abortind and writing the files right away. See attachment.