How to import more than 50Mb sql file in PhpMyAdmin

Hi, guys, I am here today with another database tutorial. A few days back someone asked me a question that how to import sql file more than 50MB size. He told me that he is migrating his hosting to godaddy and the server not letting him to import his 80mb sql file. So I decided to write a tutorial which not only helps him but others too. In this tutorial, we will learn to import a large (50+MB) sql file in phpMyAdmin database. You may already know that it is very difficult or you can say it is quite impossible to import sql file more than 50MB. There are many ways you can import large sql file into phpMyAdmin. Today I will only discuss the easiest way to do it so that anyone can do it. It requires no coding skills. Remember this tutorial is only applicable to linux run apache server as you need to run php script.

Steps to import large sql file in phpMyAdmin database

1. Download BigDump php file

2. edit the bigdump php file with text file editor(notepad of notepad++)

3. add database information and save bigdump php file

4. create a “temp” folder and upload bigdump php file and sql file in it. (you may use FTP wizard to upload your file, you can Filezilla to do it)

5. now visit url http://your-site-name.com/temp/bigdump.php (change your-site-name with your own domain name)

6. Perform import

7. Check database in phpMyAdmin

8. Delete "temp" folder

Comments

Post a Comment

Popular posts from this blog

How to get migration certificate from WBUT/MAKAUT [full details]

Image
Hello friends. Hope you people are enjoying our new section and law related question and answers. Few days ago one of my blog viewers asked me about the process to get a migration certificate from WBUT or Calcutta University. I told him to download the migration form from WBUT(West Bengal University of Technology)official website. He downloaded the form and found it was not new one i.e. recently WBUT has changed its name to MAKAUT(Maulana Abul Kalam Azad University of Technology). So I suggested him to visit WBUT’s (MAKAUT) head office which is situated at Salt Lake, Kolkata-700064. He went to the office and get the new form and he found that in that form both WBUT and MAKAUT was printed. I have given below the new form image   as well as the challan image. You can not use this form and challan. This form is given here to give you an idea that how the form and challan looks. Procedure of getting Migration certificate from WBUT 1.  Visit WBUT’s head office which is located at Salt Lake,
Read more

How to get JIO number back replace in case SIM is LOST STOLEN

Anything can happen with anyone at any time. Yesterday one of my friends lost his smart phone while travelling at train. This is definitely a serious situation. He asked me about the matter that what he should do at that time. I gave him all the instructions so that his phone can not be misused by any offender. What to do if your JIO SIM is lost or Phone with JIO SIM is stolen? The first thing comes to our mind when we lost our phone is that any offender may misuse it. If your phone or JIO SIM is lost then the first thing you need to do is file a police complaint or General Diary(GD) at your nearest police station. In my friend’s case he lost his smart phone at a Train Station so he lodged a GD(General Diary ) at nearest GRP(government railway police). Also read: How to write a GD for lost SIM /stolen Phone (Sample 1) ? Also read:   How to write a GD for lost SIM /stolen Phone (Sample 2) ? What to write in police General Diary? There are certain information which you must include to y
Read more

Telly Pulse trusted Indian Survey Panel payment proof and review 2016

Telly pulse survey panel previously it was known as Star panel India survey panel. It is one of the best survey panel networks available in India. India is now a growing economy , the world business is stooping towards in India. So to understand the need of Indian people there is a great need of market research by the global companies. So there is a great potential for the survey panelist to earn some rewards by participating in market research survey and providing honest valuable information to the brands. Telly pulse is a leading market research panel. The panel is growing it’s popularity among survey panelist. The brand name, wide range of reward option and timely paid to members are key points of Telly pulse panel’s success. Most of the people chose Flipkart gift voucher as reward option. I hope near soon they will add more reward withdraw options like freecharge, Amazon etc. Till now the survey panel is honestly paying to its panelist. I will keep reviewing this survey panel whene
Read more