Posted by amax on December 8, 2009 at 10:07am
Hi all, I am currently moving servers and reimported a .sql dump of my small drupal newspaper site which was 189 MB. This has left me wondering as to what the maximum database file size can be for importing. Id love to hear what sizes some of the others have here when doing exports and backing up the databases and could this ever grow so large that it would cause an issue. Is there such a thing as too many nodes for your site?
Comments
I dont think you near any
I dont think you near any sort of maximum. We have more than 217K nodes, and our sql dump is more than 1gb. And we're doing good.
I think iForm (iform.dk) has more than 500k nodes.
No worries :-)
Another data point: We
Another data point:
We currently have 2.145.541 nodes in our production database. The cleaned-up dumps we use on our development machines are around 1 Gb.
If you experience db import timeouts
If you experience db import timeouts with phpMyAdmin, consider using BigDump
http://www.hotscripts.com/listing/bigdump/
http://www.ozerov.de/bigdump.php
thanks
Thanks guys, very interesting and useful to know. I came accross a program called SQLyog to use rather then phpMyAdmin which does the trick for all the exports and imports once connected. Scripts above look cool jdwalling