Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Is the --sparse option suitable for .dbf files

2 views
Skip to first unread message

Dariusz Dolecki

unread,
Sep 5, 2012, 12:25:54 PM9/5/12
to
Please let me know

Kevin Korb

unread,
Sep 5, 2012, 12:31:57 PM9/5/12
to
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Essentially, a sparse file is a file that is stored sparsely meaning
that any long string of nulls that happens to be on a filesystem block
will not actually be allocated by the filesystem so you don't have to
store that block of nothing. When you read such a file you get nulls
but they aren't actually read from disk. If you ever write something
to that part of the file the file size will not change but it will
occupy more disk space.

The only reason it doesn't work with grub is that grub is not using
the kernel to access the filesystem. It is using a very stripped down
filesystem module that is usually good enough to figure out which disk
sectors to load a kernel from but it can't handle sparseness. Pretty
much everything else won't know the difference.

Also, this is during a restore that I am talking about. I don't see a
problem with using --sparse on everything during the backup.

On 09/05/12 12:25, Dariusz Dolecki wrote:
> Please let me know
>
>

- --
~*-,._.,-*~'`^`'~*-,._.,-*~'`^`'~*-,._.,-*~'`^`'~*-,._.,-*~'`^`'~*-,._.,-*~
Kevin Korb Phone: (407) 252-6853
Systems Administrator Internet:
FutureQuest, Inc. Ke...@FutureQuest.net (work)
Orlando, Florida k...@sanitarium.net (personal)
Web page: http://www.sanitarium.net/
PGP public key available on web site.
~*-,._.,-*~'`^`'~*-,._.,-*~'`^`'~*-,._.,-*~'`^`'~*-,._.,-*~'`^`'~*-,._.,-*~
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.19 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAlBHfn0ACgkQVKC1jlbQAQehxwCg4aqHiTci7IroZcHGh4dYCo/Z
+qoAoNcrgabuaXYjc4vg2KLOpD42NUJ6
=d36y
-----END PGP SIGNATURE-----
--
Please use reply-all for most replies to avoid omitting the mailing list.
To unsubscribe or change options: https://lists.samba.org/mailman/listinfo/rsync
Before posting, read: http://www.catb.org/~esr/faqs/smart-questions.html

Jason Haar

unread,
Sep 5, 2012, 8:26:52 PM9/5/12
to
On 06/09/12 04:31, Kevin Korb wrote:
> Also, this is during a restore that I am talking about. I don't see a
> problem with using --sparse on everything during the backup.

Conversely, is there any problem with NOT using sparse on sparse files?
i.e. I know it will use more space - but will a sparse file copied
somewhere by rsync NOT using the "--sparse" option be 100% equivalent to
the original?

--
Cheers

Jason Haar
Information Security Manager, Trimble Navigation Ltd.
Phone: +1 408 481 8171
PGP Fingerprint: 7A2E 0407 C9A6 CAF6 2B9F 8422 C063 5EBB FE1D 66D1

Kevin Korb

unread,
Sep 5, 2012, 8:29:55 PM9/5/12
to
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Nope, it will just eat space storing nothings rather than generating
the nothings when you read the file.

Note that when you copy a sparse file sparsely it doesn't necessarily
sparse the same blocks so the files still might not be the same size.

On 09/05/12 20:26, Jason Haar wrote:
> On 06/09/12 04:31, Kevin Korb wrote:
>> Also, this is during a restore that I am talking about. I don't
>> see a problem with using --sparse on everything during the
>> backup.
>
> Conversely, is there any problem with NOT using sparse on sparse
> files? i.e. I know it will use more space - but will a sparse file
> copied somewhere by rsync NOT using the "--sparse" option be 100%
> equivalent to the original?
>

- --
~*-,._.,-*~'`^`'~*-,._.,-*~'`^`'~*-,._.,-*~'`^`'~*-,._.,-*~'`^`'~*-,._.,-*~
Kevin Korb Phone: (407) 252-6853
Systems Administrator Internet:
FutureQuest, Inc. Ke...@FutureQuest.net (work)
Orlando, Florida k...@sanitarium.net (personal)
Web page: http://www.sanitarium.net/
PGP public key available on web site.
~*-,._.,-*~'`^`'~*-,._.,-*~'`^`'~*-,._.,-*~'`^`'~*-,._.,-*~'`^`'~*-,._.,-*~
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.19 (GNU/Linux)

iEYEARECAAYFAlBH7oMACgkQVKC1jlbQAQcYMwCglf11Z3ZVXnOVDfs9anuSj3N5
c0oAoKYP4hNpMvKNZV6m7cFmNL15tWCN
=MZuR
-----END PGP SIGNATURE-----
0 new messages