Sql Backup Question

[webgyrl]

I have a site that has 3 databases on it. I just did my first backup via cPanel and had a quick query about the file size.

 

The databases aren't huge, but it surprised me to see that the file sizes were tiny. Is this normal? I just want to make sure I really have backed these db's up. They are about 6kb, 15kb and 24kb is size. Is that right?

 

I thought they would be larger for some reason.

[Ayman]

What kind of site do you run? What are these databases for?

[webgyrl]

Ayman,

 

This particular site is an Association site. The databases are as follows:

1.) Directory Database: music managers come in and put in their address and company contact information and it is a searchable feature

 

2.)Jamroom script: this is a script/program that hosts musican profiles and music. All this info goes into the database set up for Jamroom

 

3.) aMember: this database is for our member only section for the site.

 

I just want to make sure I am properly backing up these databases because if we loose the data I have to make sure it's retrievable. I am also doing regular entire site backups.

 

The link to the site I am talking about is www.indiemanagers.com

 

Thanks for your help

[stevevan]

What is the size of the databases in question?

[woodygap]

If the file size is smaller than the data base, would it be that the backup file is compressed?

[TCH-Bruce]

All backup files are compressed that you make in cpanel.

 

Depending on the type of data being stored in the database the backup size will vary. If it's all text info it is quite possible to see 90% compression.

[webgyrl]

Looks like that compression works REALLY well! Those are my files, just squished to the max!

 

Thanks for explaining all that to me.