Hello Sir, I am wanted to move 5 GB MySQL data base from one dedicated server to another dedicated server. I did not know the process how to backup and to transfer from one server to another. Please tell me the way how can I make this possible. Thanks
Do you have physical access to the servers, or are these with the same hosting company? This is such a large amount of data that transferring from server to server over the internet gets really painful. Best bet is to hook up an external hard drive and transfer it that way, or have your host transfer it over the LAN if it's possible.
Sir they are on different companies. I am currently on rapid vps and i buy the new dedicated linux server on the planet.
using ssh u can transfer it here is process 1. take backup from your first host 2. move file using ftp 3. restore it on ur second host http://www.devshed.com/c/a/MySQL/Backing-up-and-restoring-your-MySQL-Database/ Regards Alex
Use mysqldump to backup your database and shell command scp to transfer data from your old server to new one. I hope you won't run out of bandwidth while transferring 5GB data.
you can use scp commandline, which is the easiest way. check this out: http://corpocrat.com/2009/05/06/easy-methods-to-backup-your-cpanel-files/
Of course easiest way is to make database dump (mysqldump) and then ftp (scp will be slower than ftp) it to another server. It's also good to get dump compressed (gzip or bzip). But you also can copy DB files (usually located in /var/lib/mysql/) to a new server. But: 1. you should have the same mysql versions on both servers. 2. you will have to create empty DB first, then copy files.
At Thread Starter Whenever you move to new Dedicated Server, Companies usually offer free Data Migration from one host to another, You need not to worry. Ask them to move it for you.