WampServer

Hello,

I wanted to change maximum file size for phpmyadmin upload,on localhost, becouse by default size was 2MB (and my .sql file is 17 MB ) and found this post on how to change max file size
[forum.wampserver.com]
saying...
Find:
post_max_size = 8M
upload_max_filesize = 2M
max_execution_time = 30
max_input_time = 60
memory_limit = 8M

Change to:
post_max_size = 750M
upload_max_filesize = 750M
max_execution_time = 5000
max_input_time = 5000
memory_limit = 1000M

Ive done this in php.ini file and now when I try to import mydatabase.sql i get the folowing message (its in german but You get the picture)

Fehler
SQL-Befehl: "befehl is command in german"

INSERT INTO `cache_field` (`cid`, `data`, `expire`, `created`, `serialized`) VALUES ('field:node:17', 0x613a313a7b733a343a22626f6479223b613a313a7b733a333a22756e64223b613a313a7b693a303b613a353a7b733a353a2276616c7565223b733a3339353830323a223c646976207374796c653d22746578742d616c69676e3a2063656e7465723b223e3c696d67207372633d22646174613a696d6167652f706e673b6261736536342c6956424f5277304b47676f414141414e5355684555674141426559414141514443415941414141432b2f7662414141414358424957584d4141426353414141584567466e6e394a534141414149474e49556b304141486f6c41414341677741412b66384141494470414142314d414141366d4141414471594141415862354a6678555941424958465355524256486a61375031356b477a5866523934667339644d322f756d62585871376676324145434a4568496c4568546f6b685a69795748624d716174734d5463737339452b337044736630684675656d4c596e374f675965397739486d76617933696872476e5a5a45756b784530556435414173654d39414139765832765066626e377657662b754a6c5657665771336e734167634c4c717538486b616971724b797166486b7a37376e6e6d372f374f304a4[...]

MySQL meldet: "meldet is report in german"

#2006 - MySQL server has gone away



Edited 4 time(s). Last edit at 10/31/2012 08:49AM by filip2012.

sorry,and Im using Wampserver Version 2.2

If you have a large file to import dont use phpMyAdmin. Do it this way.

Run the MySQL Console

wampmanager -> MySQL -> MySQL Console

mysql> use [database name]
mysql> source "x:/path/to/database.sql"