Beranda > Error > Fatal error: Maximum execution time of 300 seconds exceeded with phpMyAdmin

Fatal error: Maximum execution time of 300 seconds exceeded with phpMyAdmin

Saya pengguna  xampp-1.6.7 , ketika akan melakukan restore database melalui phpmyadmin – 2.11.7 dengan cara menginport file *.sql keluar error: Fatal error: Maximum execution time of 300 seconds exceeded in C:\xampp\phpMyAdmin\libraries\import\sql.php on line 89.

Hal ini terjadi content database tersebut terlalu banyak sehingga program melakukan ekseskusi melebihi  Maximum execution time yang pada error di atas melebihi 300 seconds.

Untuk mengatasi error seperti ini ada dua cara:

1. Membagi database menjadi beberapa bagian sehingga dimungkinkan untuk melakukan berapakali eksekusi yang tidak akan melebihi Maximum execution time dengan hasil sesuai dengan database aslinya. Jika cara 1 ini sulit dilakukan, silahkan lakukan cara kedua, walaupun cara ini tidak dianjurkan.

2. Merubah konfigurasi PHPMyadmin untuk item :

$cfg[‘ExecTimeLimit’] = 300; (karena errornya menginformasikan 300 seconds)

yang terdapat pada C:\xampp\phpMyAdmin\

Jika tidak ada item ini, bisa terdapat juga di C:\xampp\phpMyAdmin\libraries\config.default.php.

* maximum execution time in seconds (0 for no limit)
* @global integer $cfg[‘ExecTimeLimit’]
$cfg[‘ExecTimeLimit’] = 300;

Tapi ingat sebaiknya jangan dilakukan perubahan di file ini (config.default.php) , tapi copy saja code tersebut pada file C:\xampp\phpMyAdmin\, kemudian rubah menjadi:

$cfg[‘ExecTimeLimit’] = 0; (0 eksekusi tanpa batas)

Selanjutnya restart xampp (atau yang sejenisnya)

Lakukan restore ulang.

Setelah restore berhasil, sebaiknya nilainya dikembalikan ke semula.


Semoga bermanfaat.

Nana Sutisna

  1. eka
    April 28, 2012 pukul 3:36 am

    saya sudah merubah degan nilai 0 atau lebih besar dari 300, tetapi masih bekum berhasil, tetap muncul error

    • Nana Sutisna
      April 28, 2012 pukul 10:25 am

      Sudah di restart belum web serveicenya?
      Sudah di coba dikecilin database yang mau di importnya?
      Bisa lihat

  2. Januari 24, 2013 pukul 4:22 am

    Hello, Neat post. There’s an issue along with your site in internet explorer, could test this? IE still is the market chief and a huge section of other folks will omit your magnificent writing because of this problem.

  3. April 29, 2013 pukul 4:52 pm

    Whats up are using WordPress for your site platform? I’m new to the blog world but I’m
    trying to get started and create my own. Do you need
    any coding expertise to make your own blog? Any help would
    be really appreciated!

  4. April 30, 2013 pukul 3:40 am

    I don’t even understand how I ended up here, however I believed this post used to be good. I don’t recognize who you might be however definitely
    you’re going to a famous blogger in case you aren’t already.

  5. Mei 8, 2013 pukul 9:52 pm

    If you are not ready to fight with yourself, to say “NO” to things you liked to do or which were just a habit to you then
    nothing on Earth will help you to get rid of those excess pounds.
    These tablets are frequently over the a hundred and fifty mark but offer you
    a considerably broader and longer lasting expertise. Aided by the Pills rapidly getting best tablet pc all of the direct
    device when using the iphone, it is really distinct that we should expect to witness it develop worldwide recognition for countless years.

  6. Juni 8, 2013 pukul 7:50 am

    I was wondering if you ever thought of changing the structure of your
    site? Its very well written; I love what youve got to
    say. But maybe you could a little more in the way of content so people could connect with
    it better. Youve got an awful lot of text for only having one or two pictures.
    Maybe you could space it out better?

  7. Juni 17, 2013 pukul 5:27 am

    Very quickly this website will be famous among all blog
    viewers, due to it’s fastidious articles

  8. Juni 27, 2013 pukul 11:41 am

    Hey there! I’ve been following your website for some time now and finally got the bravery to go ahead and give you a shout out from Atascocita Texas! Just wanted to mention keep up the excellent job!

  9. Juni 29, 2013 pukul 11:58 pm

    Social media networking sites are a valuable resource for promoting your products or services and fostering discussions about their quality
    and benefits. More advanced methods are required to
    draw people to your website and these include things such as blogging,
    Facebook, Linked-in and other progressive marketing strategies that use the latest advances.
    Post a picture or two and let them know what happened.

  10. Karl
    September 7, 2013 pukul 10:53 pm

    I love this web site a lot, It’s really good to read and learn more information.

  11. Desember 26, 2013 pukul 11:44 pm

    Dogfunk, c’est le gros supermarché américain de tout ce qui est skatewear,
    surfwear, snowwear et tout le matériel qui va avec.

    Si vous avez prévu des vacances à la neige, c’est là qu’il faut vous rendre pour obtenir des
    réductions allant jusqu’à 50% sur une large sélection de produits.

    L’excellente boutique Need Supply fête également Thanksgiving avec un code promo “BLACKWEEKEND” offrant 25% de réduction sur les articles déjà en soldes
    valide tout le week-end. Dans le camion, on adore cette boutique et sa très bonne sélection de marques.
    Unibet , premier site de paris en ligne en France propose des bonus sur les différentes parties de son site.

  12. Mei 24, 2014 pukul 2:34 am

    ‘ Has shown promise in slowing the progression of
    MS in mice. Understanding how to optimize
    our emotional health means that we need to pay
    attention to the overall level of our happiness and well-being.
    Some medications and anesthesia, use of laser instead of traditional treatment and
    anxiety reducing techniques can help you to visit the dental clinic.
    Disease Fighting – Like I said before, drinking Kombucha Tea
    aids in Immune system strength. Advanced nations have adopted health and safety as a law to reduce injuries, global warming and deaths as much as possible.
    The main thing that concerns people about
    using an enema is the process that is involved in it.

    While osteoporosis sometimes occurs in menopausal women, there is
    a very simple way to prevent it. Removing ticks from your dog safely
    is important because they can either leave
    mouthparts in the skin or regurgitate into victim, opening the possibility
    of more infective agents entering the dog. Quite interesting as well, is it can be used as a
    water purifier. Deposits begin to form on the walls of the
    arteries of the heart, thus leading to cardiovascular disease and type II diabetes in men, especially men who
    smoke or eat a diet high in fat and cholesterol.

  13. Agustus 1, 2014 pukul 4:24 pm

    Thanks for sharing your thoughts. I really appreciate your efforts and I will be waiting
    for your further write ups thanks once again.

  14. Agustus 14, 2014 pukul 7:04 am

    Pretty section of content. I just stumbled upon your blog and in accession capital to assert that I get actually enjoyed account your blog
    posts. Anyway I will be subscribing to your feeds and even I achievement you access consistently rapidly.

  15. Agustus 16, 2014 pukul 9:10 pm

    Good website! I really love how it is simple on my eyes and also the
    data are well written. I’m wondering how I could
    be informed whenever a new post has been made.
    I’ve subscribed to your feed which should do the trick! Have a good

  16. September 9, 2014 pukul 10:12 am

    I was suggested this website by means of my cousin. I’m now not sure whether or not this put up is written by way
    of him as no one else understand such precise about my problem.
    You are wonderful! Thank you!

  17. Oktober 1, 2014 pukul 4:22 pm

    It’s genuinely very complicated in this full
    of activity life to listen news on TV, so I just use web for that reason,
    and obtain the most recent information.

  18. Oktober 3, 2014 pukul 5:06 am

    Thanks for sharing your thoughts on ar-15 magazines. Regards

  19. Desember 6, 2014 pukul 3:15 am

    Fantastic blog! Do you have any recommendations for aspiring writers?
    I’m planning to start my own site soon but I’m a little lost on everything.
    Would you suggest starting with a free platform like WordPress or go
    for a paid option? There are so many choices out there that I’m totally confused ..

    Any tips? Many thanks!

  20. Maret 19, 2015 pukul 5:29 am

    I like this site very much. Great info.

  21. April 20, 2015 pukul 3:25 pm

    Your style is unique compared to other folks I have read stuff from.

    Thanks for posting when you’ve got the opportunity, Guess I’ll just bookmark this web site.

  22. Juni 4, 2016 pukul 6:58 pm


  23. Juni 26, 2017 pukul 11:14 am

    Great goods from you, man. I’ve understand your stuff previous to and you are just too fantastic. I actually like what you have acquired here, certainly like what you are stating and the way in which you say it. You make it entertaining and you still take care of to keep it sensible. I can not wait to read much more from you. This is actually a tremendous site.

  24. September 11, 2018 pukul 5:39 pm

    Thanks for sharing. 🙂

  1. September 14, 2015 pukul 12:27 am

Tinggalkan Balasan

Isikan data di bawah atau klik salah satu ikon untuk log in:


You are commenting using your account. Logout /  Ubah )

Foto Google

You are commenting using your Google account. Logout /  Ubah )

Gambar Twitter

You are commenting using your Twitter account. Logout /  Ubah )

Foto Facebook

You are commenting using your Facebook account. Logout /  Ubah )

Connecting to %s

%d blogger menyukai ini: