Estimating the MySQL Dump size before actual export.,
As far as searched through its not possible in MySQL
Here is the comparision between MySQL 6 and ORACLE.
http://blogs.mysql.com/peterg/category/mysql-60-new-features/
Will explore more, if any other tools are available.
However, one quick way might be something like,
checking the size in phpmyadmin or something like that, the rows and overhead by each tables,
then applying some ratios or compression factors to calculate the rough dump size,
It might be something useful.
Will try on this more.
However ORACLE > 10 has ESTIMATE_ONLY
Internet is vague. It has nothing left to be covered now. However, things get messed up sometimes and I forgot where I used to find the materials I had just searched for some days ago. So, I am now gathering all those into this blog. This is just my bookmark or my scrapbook or anything you wish to say. If you think these are helpful, you can take references, no any rights to be defined here. No styles and no colorful designs, just an area to jot down some scraps and all. Enjoy
Pages
Tuesday, April 20, 2010
Estimating MySQL Dump Size before actual export
Labels:
Database,
HowTO,
Internet,
mysql,
oracle,
Professional,
References
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment