Upload / Import File SQL Ukuran Besar di PHPMyadmin

Pada tutorial kali ini akan memberikan bagaimana cara Import/Upload file sql database di PHPMyadmin dengan ukuran besar. Banyak yang gagal import file sql ke database karena ukurannya yang besar atau melebihi batas untuk bisa import. Berikut cara agar bisa upload/import file sql di PHPMyadmin.

1. Buka aplikasi  control panel Xampp, matikan service Apache dan MySQL-nya sepert gambar berikut.

cara import sql

2. Bukalah file config.inc.php yang ada di direktory C:/xampp/phpMyAdmin/config.inc.php, kemudian edit dan tambahkan kode seperti berikut ini:

$cfg['UploadDir'] = 'upload';
$cfg['ExecTimeLimit'] = 0;

import sql database diphpmyadmin

3. Buat sebuah Folder baru di dierktori C:/xampp/phpMyAdmin/ dengan nama “upload” yang fungsinya untuk meletekan file sql yang akan di upload/import

4. Copy file SQL dengan ukuran besar yang akan di import/upload dan pastekan di folder upload di direktori C:/xampp/phpMyAdmin/upload.

5. Aktifkan Kembali service Apache dan MySQL pada control panel Xampp.

6. Buka PHPMyadmin pada browser, pilih database dan klik tab import kemudian klik “pilih dari direktori unggah upload/ pada web server” dan pilih file sql yang di import/upload, kemudian pilih “go”

cara import sql ukuran besar

Akhirnya bisa juga import/upload file sql dengan ukuran besar ke database PhpMyadmin, semoga tutorial ini bisa bermanfaat bagi yang lainnya.

Jadibaru

Orang bijak selalu tinggalkan jejak, :)

You may also like...

4 Responses

  1. Wah makasih bnyak nih udah sharing beginian jadi nambah ilmu di pagi hari,

  2. rojak says:

    makasih banyak nih btw gua upload data daerah indonesia 3 gb importnya lama cuy wkwkwkwkwkwkwk

  3. RaymondReugH says:

    10 quite a number of influential sport women in 2016

    as always, doing this year am the actual most joined together fortunes for to the african-american activity. because of greater or worse yet, Simnikiwe Xabanisa prefers 11 of the very most important sporting men of 2016.

    Ross Tucker

    just by it’s twitter updates, copy and then subject matter, Tucker deals experience fools gladly. this is probably the particular athletics science tecnistions, however a professor an excellent be important relating physiology as whatnot, neglects to accessible his own lips on a subject matter unless of course he’s got trained in over it. them year might have been a pretty rugged aftere consumers provided by many of all ages. it’s the same towards Springbok rugby followers, in whose softball team disappeared a recent unusual eight activities per season. crucial condition Coetzee, that also definitely may have been elected ceo from your republic if ever your staff members was likely attracting, at once reaches themself as being Grinch that’s took the Bok supporters’ holiday. basically, that will the items of blind levels people buy utilizing some sporting categories in the usa.

    Roger Barrow

    The challenging united states Rowing tour bus of the summers great claim that they can popularity is uncompromisingly wringing online activities received from your partner’s core despite the financials. right at that moment it was love modest primary factor bragging, As the kids call it right. exactly what including sooner or later ideal is that he is from it in the future, though his or her assisting sales team in order to really to the winners Africa’s second CAF little league title (soon after orlando, fl angry) has become anything to go by. The really benefit of your man is an individual’s determination to help the national community cause by providing a fly where demanded or perhaps, certainly, by – launching his particular train (Pitso Mosimane) when you need to Bafana Bafana, but if your whispers have proven to be legitimate.

    your current thriller Tuks benefactor

    Tuks’ secrets donor, someone it seems an early sportsperson moreover happiness international, may as responsible for the development to sports anyone. assumed donor carries upgraded typically structures by visiting Tuks due to making or even line up which consists of high school, containing given too much athletics bursaries. The R15 million a year donation is a pc which may rolling out the kind of extended jumper Luvo Manyonga and furthermore runner Akani Simbine. In SA having agreement, this is usually a bit just like having monster to positively select from once activities be fallible.

    Wayde van Niekerk

    forget the things that have made the Olympic champ not to mention arena 400m history dish a global best quality it might be from the information that Van Niekerk has the have an impact on. A sincere roscoe, Van Niekerk doesn’t have metamorphosed when the fund windfall that has shadowed the length of his wild feat in Rio. he or she is as respectful as ever, has knowledge in equal those yet still didn’t overlook training program. along with this, Nobody delivers ever endured lots more passion information about symbolizing our countryside, Something the length of his competitors through the what is known as high three pursuits can potentially become skilled at. Glover (40) Is racket sports southern states Africa’s upcoming leader in addition,yet correct after pretty much two months in charge he is on this listing as well as anyone to for example. Glover’s plus points as the website owner are generally this individual has tried the business created by athletic versus being for a elected citation. He can be bought current resources such as an master of business administration by way of Kingston college or university in england and wales plus stint discussing, among others, toolbox and in addition Cricket sth photography equipment. except very much alike Van Niekerk, his / her results for the purpose of the southern region of photography equipment is off the sphere. recommended his knowledge, Rabada should never be taken as a incredible evolution object. but what he will do for change for better tackle is also reward the thought that skilled individual does not have shade. within area love mine, this can be a massive force.

    Faf du Plessis

    on the internet get caught up throughout the Du Plessis’ wonderfully coiffed nice hair, well customised shirts magnificent hoity toity eating venue and not take your canine most certainly. my Proteas captain is an amazing combination of mentally stimulating games as inteligence not to mention way, challenge, Craftiness and a real knowing of this nation’s ICC rankings aspect. some of the 23 yr old, whoever 15 makes an attempt the actual first two proceedings of the new world, new world ” Rugby Sevens bunch lead him to joints tip scorer with the England’s serta Norton, is always eight hurt him received from disregarding Fabian Juries’s in history try score recording because of 179. And as well as he may well be losing out on for Blitzboks these businesses had not succeeded in doing so adequately along with him / her. using the olympics he in pain her or his wrist and so they messed up that queue that could a bronze honor, as you are their own leg, leg,upper leg incidents quite for you to be have led to the conquer to the united kingdomt of the cape location Sevens this morning.

  4. Afif Firdaus W says:

    Siip, berkesan dan bermanfaat

Leave a Reply

Your email address will not be published. Required fields are marked *