Finds ny SQL data but no output | General Questions and 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
Finds ny SQL data but no output
October 20, 2013
12:03 pm
Avatar
ron
Member
Members
Forum Posts: 4
Member Since:
October 20, 2013
sp_UserOfflineSmall Offline

Hello,

I have sucessfully backed up files using Xcloner – perfect, no problems.

Then I tried to backup the MySql tables. On the screen for Generate Database it correctly shows my list of tables in MySql.

Then during processing it reports 51.8 MB of data which is probably correct

Then it prints any Filesystem results if I choose (some or none) to backup.

However the finished tar file is always missing any SQL content but any chosen filessytem folders are there. If I choose not to backup any web files then the final size of tar is 1.5k. Notice the estimated size became 0Mb even though 51mb sql was determined.

 

 Initializing backup…



Backup /home/carlukeh/public_html/xcl/administrator/backups/backup_2013-10-20_06-18_www.carlukehistory.co.uk-sql-nodrop.tar created, we may continue!

Database backup…


[carlukeh_jackson] 127 tables (51.80 MB)

Filesystem backup…

Scanning files system… done! (Estimated size:0.00MB) in 1 files

Processing Files: 100% (1 files)

Backup Name: backup_2013-10-20_06-18_www.carlukehistory.co.uk-sql-nodrop.tar

Backup Size: 0.00MB


 

Backup completed!

 



 

It produces the same lack of SQL output no matter whether I include web files or not. I have saved some snapshots of the display here

http://www.carlukehi.....te_backup/

When a downloaded tar is opened the backed up folders for one of my attempts is visible but no folder named SQL or anything else.

 

October 20, 2013
7:26 pm
Avatar
Ovidiu Liuta
Admin
Forum Posts: 2484
Member Since:
September 26, 2010
sp_UserOfflineSmall Offline

Could you post also a screenshot from the generate backup screen, files tab? are you excluding any folders?

October 20, 2013
8:17 pm
Avatar
ron
Member
Members
Forum Posts: 4
Member Since:
October 20, 2013
sp_UserOfflineSmall Offline

Yes excluding folders, e.g. in the sample below only 3 folders extracted out of a hundred or more.

In some tests I excluded ALL the folders in the filesystem to only extract the MySql files.

 

Image Enlarger

 

Image Enlarger

 

 

three folders extracted below /stories, /gedcom and /security  ech of them off the root directory. This image is of the exploded tar file when downloaded.

Image Enlarger

October 20, 2013
9:44 pm
Avatar
ron
Member
Members
Forum Posts: 4
Member Since:
October 20, 2013
sp_UserOfflineSmall Offline

Judging from your question about excluding folders, I did a new backup will full filesytem backup plus sql backup. The message  

Backup Size: 0.00MB

 did not appear. The size of the tar was nearly 4GB split into two files and I am still waiting for the first part to download. The feature of having the ability to exclude folders is one of the attractions for this reason, that a download takes too long for a full backup.

 

Untill I have both parts downloaded I cannot tell if the sql backup is included.

October 21, 2013
1:21 am
Avatar
ron
Member
Members
Forum Posts: 4
Member Since:
October 20, 2013
sp_UserOfflineSmall Offline

OK, problem has been resolved.

Either of two solutions seem appropriate.

 

1. The administrator/backups folder must be immediately off the public_html folder, even if the Xcloner software is placed in its own folder like I have in  public_html/xcl/

or

2. Your software needs to read the path to (in my case) public_html/xcl/administrator/backups

When I installed Xcloner it by itself created administrator/backups off of the install folder even though there was a folder I created off publc_html

 

ALSO  your documentation should mention that SQL backups will be written to the administration/backups folder, and will so appear in the tar file.  I did not see this notated anywhere in your documentation.

Of course when there is a folder named (in my case)  public_html/xcl/administrator/backups what was happening was that the sql backup was not being written to either of the backup folders. But now that I removed tbe one in  /xcl/ the problem was fixed.

Maybe I am just being stupid or misunderstaanding the notes but I feel the documentation could have been more obvious.

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:
Omar Vera
Moderators: TriP: 0, Steve Burge: 0
Administrators: Ovidiu Liuta: 2484, Victor Drover: 1, Valentin Barbu: 0