How to move large MySQL Database from one server to another ?

Moving large database files from one server to anotherserver has always been a huge headache for all developers. It consumes lot of time.

Whenever DB filesize is more than 500 MB you have to first download the database and then onnew server you need to upload new db. But here comes tricky situation where most ofthe shared hosting and reseller hosting has PHPMYADMIN providing not more than50 MB file uploading capacity at once. So its simple that user cant uploadlarge DB from phpmyadmin. In that caseuser need to raise a ticket to the hosting people to help upload db from theirside.

For this you need to first upload db to your server root and then givingthem db path. This whole process involves lot of time and project duration getsdelayed and delayed creating wrong impression on the client at first go.

To deal withthis situation, MySqlDumper tool provides a very easily solution. MySQLDumper is a web based backup/restore script for MYSQL which canhandle huge dbs. Additionally – like in phpMyAdmin – you can create, dropdatabases, tables and views or view, search, delete, edit or add fields in aneasy to use SQLBrowser.

Some Key Features:

MYSQLDUMPERINSTALLATION:

1. We need to choose installation Language.

2. We needto fill some credentials such as hostname, user and MySQL password.

3. We can test the connection to the database by clicking Connect to MySQL button. If it succeed, then wewill see a message saying that Database connection was established

4. Once you got the message, click the Save and continue installation button. You will be taken into the home screen.

 

 

 

Exporting & Importing Process using MySQLDumper

Looking to build a brand new website ?

Send us your requirements and we will send you no obligation proposal.