Script for automatic back up of database for cron jobs?

[Daniel15]

SleePy, I suggest you add a shebang line to the top of the file...
Above <?php, put:

Code Select Expand


#!/usr/bin/php -q


Then, just use the file path (without the php -q) in the cron job

[Farmacija]

you confusing me, which code i should use in cron jobs when i use daniel15's script for more then one databases?

[Daniel15]

If you use my script above, first edit the script to reflect the correct values (username, password, databases), and then change the cron job to something like /home/cpuser/database-backup.php .

[Farmacija]

i don't need to put this

Code Select Expand

mysqldump -ucpuser_username -ppassword  cpuser_database > before

Code Select Expand

/home/cpuser/database-backup.php?


I get this error => /bin/sh: /home/farmaceu/database-backup.php: Permission denied

edit2=> now it's ok, it was needed to chmod file database-backup.php to 744.
thank u very much daniel!!! 

[Daniel15]

No problem

i don't need to put this

Code Select Expand

mysqldump -ucpuser_username -ppassword  cpuser_database > before

Code Select Expand

/home/cpuser/database-backup.php?

No, you didn't need to do that, as the PHP script does the mysqldump call itself

[Farmacija]

yes, i figure it out

--
But, now i have this error

Code Select Expand

Failed loading /root/milan/ioncube/ioncube_loader_lin_4.4.so:  /root/milan/ioncube/ioncube_loader_lin_4.4.so: cannot open shared object file: Permission denied

[Farmacija]

Me again.

Now i have problem because back up file is huge, in a last time it was about 8gb???


Does someone know where is the problem?