Database plays a vital role in every application considering from a simple to huge. If it is fatty in size then the complexity of managing and handling that data will become bottle neck to a developer.
Majorly the problem will be raised when you need to transfer database from one server to another that doesn’t has ssh access and which is bulky in size for example magento databases .
Usually the database tools like “phymyadmin” restricts importing files to a specific size even you modified the parameters in php.ini and my.cnf configuration files. To get out from these type problems we would like to provide you a smart solution in a wise and simple procedure.
Before starting have a look on this video which might help you.
Take the sql file that need to be imported
Download the php file from the below link and provide the database login details and sql file name.
Place these two files in the same location and the run the php file from the browser.
All the details like size of database and the status of importing will be clearly displayed.
Yup! Your big data transfer is completed….
Now “The ball is in your court”, Just try it to taste the efficiency of this Big Data Transfer procedure.