best way to approach this is to use a script like bigdump that wont upload but download and make it do like each database will dump at a certain amount of mb or gb then do a continue on script...

Basicly something that can dump partial dumps of each database to do multiple dumps then join the dumps
Loonycgb2 Reviewed by Loonycgb2 on . mysql hotcopy scripst any one know any good mysql hotcopy scripts which can run by cron , i have large databses around 20 gb dumping them takes really long time killing all sites on server :( Rating: 5