i should of used outside pub_html to save space... its not writing a file for me whatever dir i try or do... should of worked the first time, i'll read through this thread and see if i can find a solutions, cheers
EDIT, the solution for me was to write these databases outside of public_html, security and space saving...
The people having problems are forgetting the forward slash
/home/mysitecom/backups/
cheers
one last thing... to make it perfect this hack should gzip the output file and maybe have a setting to keep backups for a defined time period, say...going back 3 weeks or 2 days or whatever
cheers