Search code examples
mysqldatabaseapachephpmyadminwampserver

Can't import database through phpmyadmin file size too large

I have been trying to import Database through phpMyAdmin. My database file is a.sql and it's size is 1.2 GB I am trying to import this on local and phpMyAdmin is saying:

You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit.

Please help I really need this to work.

Solution

  • Its due to PHP that has a file size restriction for uploads.

    If you have terminal/shell access then the above answers @Kyotoweb will work.

    one way to get it done is that you create an .htaccess/ini file file to change PHP settings to get the sql file uploaded through PHPmyAdmin.

    php_value upload_max_filesize 120M //file size
php_value post_max_size 120M
php_value max_execution_time 200
php_value max_input_time 200

    Note you should remove this file after upload.