WampServer

Hi.
During import DB from sql dump (about 100M I always get an error - #2006 - MySQL server has gone away

I checked my.ini file and increased max_sizes of everything (and yes, i did restart WAMP after all changes), but I still can't do the import, I still have same error.

This is the my.ini settings

[wampmysqld]
port = 3306
socket = /tmp/mysql.sock
key_buffer_size = 160M
max_allowed_packet = 500M
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 80M

[mysqldump]
quick
max_allowed_packet = 500M

Hi,

Can you answer these questions so we know a bit about the versions of everything you are using [forum.wampserver.com]

Are you using phpMyAdmin to do the import or the mysql console?

---------------------------------------------------------------------------------------------
(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-

1 - Windows 7 64 bit
2 - Version WampServer 2.5 64bit
3 - Apache 2.4.9
4 - PHP 5.5.12
5 - MySQL 5.6.17
6 - Color of the WampServer is GREEN

I tried to use SQL YOG community edition (last version 64 bit), and phpMyAdmin (from wamp) - same result. The import stops on the same table (it looks really big)..



Edited 1 time(s). Last edit at 07/13/2016 02:40PM by MegaCoder.

Try using the mysql command line

i.e.

wampmanager -> MYSQL -> MYSQL Console

Then use

>source c:/the/path/to/backup.sql


And that will run the restore.

Alternatively there might be a problem with importing a database from another version of MYSQL. You may need to look at where it stops. Maybe chop the restore file into bits untill you spot the issue

---------------------------------------------------------------------------------------------
(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-