My site has been growing exponentially over the last few months, and we've come to the point where the current dedicated server can no longer sustain the load nor the bandwidth that my forum is generating. So, I've decided to switch to a new server.
In the past, I have only dealt with minor transfers involving small databases, but now, with a 400MB database and several gigabytes of files, things aren't as easy. I suppose that it's better to transfer hosts now, before the site grows even bigger.
Basically I have two general questions:
1. Should I backup and transfer the database using phpmyadmin through plesk, or should I do so through SSH? If so, what SSH command should I use? Would I risk corrupting the database when downloading to my PC from the old server and re-uploading it into phpmyadmin on the new server?
2. How should I go about downloading the attachment files in my FTP directory? To I have to use binary transfer, or can I leave everything on 'auto' and just download my entire /forum/ folder?
Also, is there anything else I should keep in mind when transferring? Would you recommend that I close the board while backing up the DB? Thanks for your help!
In the past, I have only dealt with minor transfers involving small databases, but now, with a 400MB database and several gigabytes of files, things aren't as easy. I suppose that it's better to transfer hosts now, before the site grows even bigger.
Basically I have two general questions:
1. Should I backup and transfer the database using phpmyadmin through plesk, or should I do so through SSH? If so, what SSH command should I use? Would I risk corrupting the database when downloading to my PC from the old server and re-uploading it into phpmyadmin on the new server?
2. How should I go about downloading the attachment files in my FTP directory? To I have to use binary transfer, or can I leave everything on 'auto' and just download my entire /forum/ folder?
Also, is there anything else I should keep in mind when transferring? Would you recommend that I close the board while backing up the DB? Thanks for your help!
Comment