WampServer

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.
127.0.0.1 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?

Hi,

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.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

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.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
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 databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-