Just wondering if someone starts a website on a shared host, and the mysql database grows really huge.. (lets suppose 1 GB).. how it is possible to transfer the 1GB database from one host to another.
SSH or Telnet would work... Or just download and upload, but be careful with the 2nd method as a lot of strings might become broken.
if its unix(tm) based Source Host $ mysqldump -u username -p database > database.sql && scp database.sql new.unix.host.net:. Destination Host $ echo "create database database" > tmp.sql ; mysql -u username -p < tmp.sql $ mysql -u username -p database < database.sql
If you had PhpMyAdmin then you can just use the 'export' function from your old host, save the exported DB then use the 'import' function on your new host. This will take time to download/upload the DB, so be patient if you decide to use this method.
I would go with this method if you can. I personally use Navicat, which I have used to transfer 10GB+ Db's without problem.
Hello, You can Try using the script called mysqldumper ( mysqldumper.de) and configure it to take backups in parts of small size like 100mb or so. But this can be a hectic process. so do it through SSH command thats it. connect thro putty and put in the command : ( linux) mysqldump -uuser -ppass -h localhost dbname > backup_file_name.sql then transfer the backup file to ur other host, and import it to your new mysql database through this command : mysql --user=user --pass=pass --host=localhost db_name < file_name.sql hope it helped
I tried this method. but didn't work out well for me even though the DB wasn't even half this size. i would recommend a different method for a big DB such as this.
u cant do it with phpmyadmin, connection gets timeout. phpmyadmin is good only for taking backups of databases less than 15~20mb thats it.
Try Navicat: http://www.navicat.com/ They have a free trial, and a free personal version for non commercial. I've personally used it for DB's over 10GB.