Database file is too big to import with phpmyadmin
Posted by: JuanW (
Date: January 31, 2018 03:12PM

Windows version - Windows 8.1 PRO 64 bit
Version WampServer - Wampserver 3.1.1 64 bit
Apache Version - 2.4.27 - PHP 5.6.31
PHP Version - 5.6.31 for CLI (Command-Line Interface)
MySQL Version - 5.7.19
MariaDB - 10.2.8
The WampServer icon is Green
The active lines in the hosts files are these two. localhost
::1 localhost
I have access to the localhost (Homepage WampServer).
I have access to phpMyAdmin
I have Eset Nod 32 as an antivirus, and the Windows firewall is on.
The full path to WAMP is c:\wamp64
I'm in the process of setting up my online website on my local machine.
When I import my database file myphpadmin says that the file is too big. The file size is 1.05 gig.
How can I import the file?

Options: ReplyQuote
Re: Database file is too big to import with phpmyadmin
Posted by: Otomatic (Moderator)
Date: January 31, 2018 04:26PM


Modify limit parameters in wamp64/alias/phpmyadmin.conf like this :
# To import big file you can increase values
  php_admin_value upload_max_filesize 1500M
  php_admin_value post_max_size 1500M
  php_admin_value max_execution_time 3600
  php_admin_value max_input_time 3600
You must restart Wampserver.

The most important import I made was with a 652 M SQL file.
I don't know if it'll work with a 1.05 G file.
Otherwise, you will have to import by splitting the file to import table by table.

Wampserver 3.1.9 32 bit - Apache 2.4.39 - PHP 7.3.5/7.2.18/7.1.29/7.0.33/5.6.40 - MySQL 5.7.26 - MariaDB 10.3.15
Wampserver 3.1.9 64 bit - Apache 2.4.39 - PHP 7.3.5/7.2.18/7.1.29/7.0.33/5.6.40 - MySQL 5.7.26/8.0.16 - MariaDB 10.3.15
PhPMyadmin 4.8.5 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote
Re: Database file is too big to import with phpmyadmin
Posted by: RiggsFolly (Moderator)
Date: January 31, 2018 08:13PM

Alternatively import the backup using the mysql command prompt

wampserver->mysql->mysql Console

mysql> use `database-name`
mysql> source path/to/import/file.sql

(Windows 10 Pro 64bit) (Wampserver 3.1.8 32bit & 64bit)
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 6.3.10>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your MySQL databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote

Sorry, only registered users may post in this forum.