The free forums are no longer in use. It remains available as read-only archive.
The forums are currently locked and only available for read only access
Database not being fully backed up and Warning: filesize(): stat failed error
November 7, 2013
2:39 pm
2:39 pm
Guest
Guests
I'm running the following CRON job in a Godaddy server for a Joomla Website:
/web/cgi-bin/php5 "$HOME/html/administrator/components/com_xcloner-backupandrestore/cloner.cron.php"
I had to set the "Server Use Options" of Tar to Active because without that setting active, the backup was crashing due to out of memory error. So even though the Cron log message below says "out of memory", the Cron Job is actually completing and I'm getting one big .TAR file as the result. But I have 2 issues which I can't figure out:
Issue #1: Even though in the Configuation-Cron tab I have the "Add Mysql Drop" set to green ( meaning active), the database records are not being backed up.
The full dtatasbe size is over 200 MB and it is only backing up 1.99 MB as the total database size.
Issue #2: Even though in the in the Configuation-Cron tab I have excluded the /home/content/63/10246263/html/stats directory, I'm still getting following error:
Warning: filesize(): stat failed for /home/content/63/10246263/html/my_backups/backup_2013-11-06_22-15_mywebsite.com-sql-drop.tar in /home/content/63/10246263/html/administrator/components/com_xcloner-backupandrestore/cloner.functions.php on line 1845
Below is the full message I'm getting via email after the Cron Job completes:
Content-Type: text/html; charset=utf-8
Set-Cookie: auth_clone=1
<b>Using default configuration file</b><br />
<b>Starting /home/content/63/10246263/html/administrator/components/com_xcloner-backupandrestore/cloner.cron.php</b><br />
<b>Starting XCloner for site mywebsite.com at 2013-11-07 00:35</b><br />
<b>Creating a fullbackup</b><br />
<b>Generating Backup ...</b><br />
Out of memory (Needed 996008 bytes)
<br />
<b>Warning</b>: filesize() [<a href='function.filesize'>function.filesize</a>]: stat failed for /home/content/63/10246263/html/my_backups/backup_2013-11-06_22-15_mywebsite.com-sql-drop.tar in <b>/home/content/63/10246263/html/administrator/components/com_xcloner-backupandrestore/cloner.functions.php</b> on line <b>1845</b><br />
<br />
<b>Warning</b>: filesize() [<a href='function.filesize'>function.filesize</a>]: stat failed for /home/content/63/10246263/html/my_backups/backup_2013-11-07_00-35_mywebsite.com-sql-drop.tar in <b>/home/content/63/10246263/html/administrator/components/com_xcloner-backupandrestore/cloner.functions.php</b> on line <b>1845</b><br />
<b> Archive Name: backup_2013-11-07_00-35_mywebsite.com-sql-drop.tar
<br />
Number of Files: 28294
<br />
Size of Original File: 4364.64 MB
<br />
Size of Archive: 4388.26 MB
<br />
Database Backup: <b>database9005A:</b> Backup Completed ( 1.99 MB )
<br />
### END REPORT
</b><br />
<b>Backup Done</b><br />
<b>Backup file: /home/content/63/10246263/html/my_backups/backup_2013-11-07_00-35_mywebsite.com-sql-drop.tar</b><br />
<br />
<b>Warning</b>: filesize() [<a href='function.filesize'>function.filesize</a>]: stat failed for /home/content/63/10246263/html/my_backups/backup_2013-11-07_00-35_mywebsite.com-sql-drop.tar in <b>/home/content/63/10246263/html/administrator/components/com_xcloner-backupandrestore/cloner.cron.php</b> on line <b>198</b><br />
<b>Total backup size: bytes</b><br />
<b>Notification Mail was sent to [email protected]</b><br />
<b><br />
ALL DONE! I will exit now from cron.</b><br />
Below is the content of the cloner.config.php file:
<?php
$_CONFIG['license_code']='';
$_CONFIG['backup_path']="/home/content/63/10246263/html/";
$_CONFIG['clonerPath']="/home/content/63/10246263/html/my_backups";
$_CONFIG['jcuser']='xxx';
$_CONFIG['jcpass']='xxx';
$_CONFIG['mysql_host']="database9005A.db.10246263.hostedresource.com";
$_CONFIG['mysql_user']='database9005A';
$_CONFIG['mysql_pass']='xxx';
$_CONFIG['mysql_database']="database9005A";
$_CONFIG['select_folders']="";
$_CONFIG['select_lang']="english";
$_CONFIG['secure_ftp']="0";
$_CONFIG['backup_compress']="0";
$_CONFIG['cron_logemail']="[email protected]";
$_CONFIG['cron_fromlogemail']="[email protected]";
$_CONFIG['cron_exclude']="/home/content/63/10246263/html/stats
/home/content/63/10246263/html/my_backups";
$_CONFIG['cron_send']="0";
$_CONFIG['cron_btype']="0";
$_CONFIG['cron_bname']="";
$_CONFIG['cron_ip']="";
$_CONFIG['cron_ftp_server']="";
$_CONFIG['cron_ftp_user']='';
$_CONFIG['cron_ftp_pass']='';
$_CONFIG['cron_ftp_path']="";
$_CONFIG['cron_ftp_delb']="";
$_CONFIG['databases_incl_list']="";
$_CONFIG['cron_sql_drop']="1";
$_CONFIG['cron_email_address']="";
$_CONFIG['cron_file_delete']="0";
$_CONFIG['cron_file_delete_act']="";
$_CONFIG['mem']="1";
$_CONFIG['backup_refresh']="1";
$_CONFIG['refresh_time']="1";
$_CONFIG['refresh_mode']="1";
$_CONFIG['recordsPerSession']="10000";
$_CONFIG['excludeFilesSize']="10000";
$_CONFIG['splitBackupSize']="2048";
$_CONFIG['backup_refresh_number']="100";
$_CONFIG['sql_mem']="";
$_CONFIG['enable_db_backup']="1";
$_CONFIG['zippath']="";
$_CONFIG['tarpath']="tar";
$_CONFIG['sqldump']="mysqldump --quote-names ";
$_CONFIG['system_dlink']="";
$_CONFIG['mosConfig_live_site']="mywebsite.com";
$_CONFIG['system_ftptransfer']="0";
$_CONFIG['system_mdatabases']="0";
$_CONFIG['add_backups_dir']="0";
$_CONFIG['cron_amazon_active']="";
$_CONFIG['cron_amazon_awsAccessKey']='';
$_CONFIG['cron_amazon_awsSecretKey']='';
$_CONFIG['cron_amazon_bucket']='';
$_CONFIG['cron_amazon_dirname']='';
$_CONFIG['cron_amazon_ssl']='';
$_CONFIG['cron_dropbox_active']='';
$_CONFIG['cron_dropbox_Key']='';
$_CONFIG['cron_dropbox_Secret']='';
$_CONFIG['cron_dropbox_dirname']='';
$_CONFIG['debug']="0";
?>
November 7, 2013
3:53 pm
3:53 pm
Guest
Guests
Thanks for the quick reply!
For the filesize issue: in the "System" tab, I have the option "Split Backup Archive if size larger than" set to 2048. When I run a backup from the Joomla interface, the backup gets split up inot multiple files. But when I run the CRON job it creates one huge over 4GB file. Why does the CRON job not split up the backup into multiple files?
Also, please see my issue #1 - why is the Database Backup not creating a dump of my database records?
Thanks!
Forum Timezone: America/Chicago
Most Users Ever Online: 867
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
mlguru: 30
Django29: 29
Andy: 21
D: 21
Marcus: 20
Jamie F: 19
Member Stats:
Guest Posters: 738
Members: 10030
Moderators: 2
Admins: 3
Forum Stats:
Groups: 3
Forums: 7
Topics: 2397
Posts: 8236
Newest Members:
Adrian StefanModerators: TriP: 0, Steve Burge: 0
Administrators: Ovidiu Liuta: 2484, Victor Drover: 1, Valentin Barbu: 0
© Simple:Press —