I've been trying the
MySQL backup via cron - Emailed to You and MySQL backup via cron - FTPed to You scripts

but it only emails/ftps a 20 byte backup.sql.gz file, any reason why?

Also another issue I have is crontab doesn't like this script as it outputs this error:
/home/morta8/public_html/cronbackupHkS7tt5Cm.php: line 1: ?: No such file or directory
/home/morta8/public_html/cronbackupHkS7tt5Cm.php: line 2: syntax error near unexpected token `('
/home/morta8/public_html/cronbackupHkS7tt5Cm.php: line 2: `$datestamp = date("Y-m-d");      // Current date to append to filename of backup file in format of YYYY-MM-DD'

so I have to execute it in my browser instead to my php file and it works (with an empty sql file). Would really like to get this working as the Backup and Restore function in CPanel only backups my site files but not the sql database.


edit: Managed to troubleshoot it a bit further, the cron errors above was due to me not putting a php in front of the /home/morta8/cronbackup.php line. Now that it's working, I have an idea why my sql backup is empty, because cron shows the following: mysqldump: Got error: 1045: Access denied for user 'username-removed'@'localhost' (using password: YES) when trying to connect. I need to be using lpsql01.lunariffic.com as database host as my welcome email says they host the sql on a seperate server.

i use MySQL backup via cron - Emailed to You backup my db
and my email quota is 20M
but my backup fules is over 20M
how can i use this to backup my db

i use gmail
i can not change quota

Why are you paying your hosting company for email accounts you aren't using (just wondering).  Troy is right though, if it's bigger than 2MB you should seriously consider putting the backup on your server and accessing it when you need it.

I had the same problem Solved now

Using the MySql FTP script

I am able to run it under Public_HTML to test without a path and the file uploads to the home directory.

Trying to use this filename with path:

$filename= "/home/EDITED/phpscriptbackup/doc/backup-$datestamp.sql.gz";

I get this error:

Connected to willow.lunarbreeze.com, for user EDITED@osagecollies.com
Warning: ftp_put() [function.ftp-put]: Rename/move failure: No such file or directory in /home/EDITED/public_html/phpscriptbackup/phpbackup.php on line 41
FTP upload has failed.

The directory structure exists and has world write permissions (777) on both the phpscriptbackup folder and the doc folder within it.

Am I missing something on the filename path?

Thanks!

*edited for username

I went back and changed to 755 on both folders and got the same error.

All the db information is correct and the script works fine if I don't put a path in the filename:

For example, if I use this instead:

$filename= "backup-$datestamp.sql.gz"; // The name (and optionally path) of the dump file

It creates the backup file fine and places it in my home directory. While that is functional, I'd rather the backup be placed in a particular directory for organizations sake. Line 41 of the script (the one that started the post) is:
$upload = ftp_put($ftp_conn, $filename, $filename, FTP_BINARY);

Thanks for the help.






Edit: Ugh... ok, I take it back, it IS creating the file without the path but the file is not "fine" per say. It has no data.

Server: Willow. I use cpanel.