MSQL Administrator backup growth dwarfs actual table size.

[andrewmoir]

HI All,

 

just a quick question - please note I'm fairly new to MySQL.

 

I am using MySQL Administrator to backup my database  (I also backup via .csv export as a backup backup)

 

I have watched the backup files from MySQL Admin grow in size in 6 months from 20 to 30 megabytes.

 

However using PHPmyadmin to look at the database I note that my main table is only 11 megabytes (it has only grown by 4 megabytes in 6 months).  Note all other tables are in KB sizes and no tables are linked.

 

Is there a reason for the difference in size??

 

regards

 

Andy