Database not being fully backed up and Warning: filesize(): stat failed error | Joomla Support | Forum Archive

The free forums are no longer in use. It remains available as read-only archive.

Avatar
Lost password?
Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
The forums are currently locked and only available for read only access
sp_TopicIcon
Database not being fully backed up and Warning: filesize(): stat failed error
November 7, 2013
2:39 pm
Avatar
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
2:46 pm
Avatar
Ovidiu Liuta
Admin
Forum Posts: 2484
Member Since:
September 26, 2010
sp_UserOfflineSmall Offline

The filesize issue is a problem from the hosting company, please check with godaddy on that, that error usually appears when the backup files are larger than 2GB. As for the "Out of memory (Needed 996008 bytes)" , might want to try and increase your site php.ini memory_limit.

 

Ovidiu

November 7, 2013
3:53 pm
Avatar
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!

November 7, 2013
4:32 pm
Avatar
Ovidiu Liuta
Admin
Forum Posts: 2484
Member Since:
September 26, 2010
sp_UserOfflineSmall Offline

The issue #1 is related to the Out of memory you are receiving. The spli backup option is not yet implemeted in the cron mode.

 

Ovidiu

November 7, 2013
5:10 pm
Avatar
Guest
Guests

Thanks again for the quick reply Ovidiu.

Forum Timezone: America/Chicago
Most Users Ever Online: 867
Currently Online:
Guest(s) 1
Currently Browsing this Page:
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 Stefan
Moderators: TriP: 0, Steve Burge: 0
Administrators: Ovidiu Liuta: 2484, Victor Drover: 1, Valentin Barbu: 0