I used this query to find out my database size
SELECT table_schema "Data Base Name", sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema ;
it returned as 849MB but when I exported the database it was only 501MB.
Being that there seemed to be over 300MB of info missing I decided to export in parts all the a,b,c etc, once done the total size of the folder the parts where stored in it was 606MB
This was better 100MB more but that still leaves around 200MB unaccounted for, I didn't export as zip or gzip archive just straight .sql file so really it should not differ and when the difference is over 200MB I'm thinking there is something wrong but I haven't a clue what or why each try returns a different size ...
...any suggestions on why this is happening?