Reputation: 1148
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
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