#1 2019-05-05 00:56:06

schwim

Member

From: Coastal VA, Murica

Registered: 2015-09-29

Posts: 342

Website

[SOLVED] Can not figure out how to import large MySQL file

Hey guys!

FIlesize is about 115mb

I've tried direct MySQL at the terminal:

web2@server:/var/www/clients/client1/web2/web/dump$ mysql -h localhost -u c1schwim -p c1sandi_fivemin < file.sql
Enter password:
ERROR 2006 (HY000) at line 19978: MySQL server has gone away
web2@server:/var/www/clients/client1/web2/web/dump$

I've tried bigdump:

Stopped at the line 334.

At this place the current query includes more than 300 dump lines. That can happen if your dump file was created by some tool which doesn't place a semicolon followed by a linebreak at the end of each query, or if your dump contains extended inserts or very long procedure definitions. Please read the BigDump usage notes for more infos. Ask for our support services in order to handle dump files containing extended inserts.

I have no idea how to get this imported.

What else can I do to import this file?

Thanks for your time!

Last edited by schwim (2019-05-05 12:49:27)

---

Schw.im! A social site with an identity crisis.

iMBeCil

WAAAT?

From: Edrychwch o'ch cwmpas

Registered: 2015-09-29

Posts: 767

Re: [SOLVED] Can not figure out how to import large MySQL file

Try to import this file from inside mysql. Something like:

$ mysql -h localhost -u c1schwim -p
Enter password:
mysql> use c1sandi_fivemin;
mysql> source file.sql;

---

Postpone all your duties; if you die, you won't have to do them ..

schwim

Member

From: Coastal VA, Murica

Registered: 2015-09-29

Posts: 342

Website

Re: [SOLVED] Can not figure out how to import large MySQL file

Absolutely magical sir, thanks so much!

---

Schw.im! A social site with an identity crisis.

iMBeCil

WAAAT?

From: Edrychwch o'ch cwmpas

Registered: 2015-09-29

Posts: 767

Re: [SOLVED] Can not figure out how to import large MySQL file

You're welcome ... glad it helped.

---

Postpone all your duties; if you die, you won't have to do them ..