CODEWITHSUNDEEP
mysqldatabasephpmyadmin
yesbutmaybeno
yesbutmaybeno

Reputation: 1148

Large DB import failing, Wamp + PHPMyAdmin

Trying to reinstall a local copy of my website on a local Wamp server, but after about 30 minutes the DB import keeps failing like this: https://i.sstatic.net/TWARs.png

The .GZ file is 125mb and the upload limit is 750mb. According to SELECT statements, wait_timeout is 28800 and max_allowed_packet is 1048576

Those seem to be the two values I've seen referenced in other answers as to be the problem, but they seem sufficiently high here right? What else could it be?

Upvotes: 0

Views: 99

Answers (1)

Mirabeau
Mirabeau

Reputation: 52

Under Linux:

$ mysql -u [user] -p [BDD_Name] < YourSQLfile.sql

Under Windows:

c:\> mysql -u[user] -p [BDD_Name] < YourSQLfile.sql

And for a .gz file:

zcat YourSQLfile.sql.gz | mysql -u [user] -p [BDD_Name]

Upvotes: 1

Related Questions