i have a forum (database is 2 GB) and is very busy i changed servers and want to upload backup of DB on new server but facing problem since its huge and my net speed is not that fast to handle it ? any solution to this problem?
Yes the only solution as i know is Contact host people to collect the old database and restore in new one I hope they will do for a nominal fee its best u can do
Stupid host. At least they should provide a paid option. My host moved all my sites for me....without any charges. A few of my sites have large databases. In fact, every time I have changed my host in the past, I have bought hosting only on the condition that the new host will move my sites. With the kind of internet speeds that exist in some countries, it is impossible for webmasters to upload/download such huge databases.
You can hire someone to do the task for you.... someone who knows about uploading databases. (Try BST services section at DP). or Find a new host. ================================== A big portion of the disk space that a site uses, is taken by the "historical data" stored by analog, webalizer and awstats. Go to your cpanel > file manager > tmp > analog (or awstats or webalizer) See the file sizes. That will give you the idea. If you can clear the cache and logs, you will free a lot of disk space like this guy.....
Do you have root on both servers? If you do then you can send it from server to server without downloading it locally. If you don't, it's too big to upload via phpMyAdmin so you will need to upload it to the file system via FTP and use MysqlDumper to import it from the file system to MySql. Just FTP it to your file system overnight, i've done DB's bigger then yours on a slow connection.
"Slow connection" means different things in different countries.... 2 GB = 2000 MB = 2,000,000 KB My ISP charges 2 US cents per MB. Transferring 2000 MBs would mean a cost of $40. My ISP also has unlimited plans with speeds of 96 Kbps and 192 Kbps. 96 Kbps = 12 KBps. At 12 KB per second, 2,000,000 would take 166,666 seconds or around 46 hours. All this with the assumption that the connection will be uninterrupted and working with 100% efficiency.
In the old days i've done it on dial-up, 56k so i've been there done that with databases. When i started with PC's the max connection was 300 baud, or in perspective 45 minutes to transfer a 10,000 word plain text file. So believe me, i know what slow speeds are. Now days you can resume interrupted downloads, and use things like differential restore etc if the connection times out.