CODEWITHSUNDEEP
mysqlsql
Kiarash
Kiarash

Reputation: 7998

import large sql dump into Mysql

I have a bunch of sql files which I could successfully import into my local mysql server. but one of them is the largest around 7 gigs and when I try to import it to mysql it just takes forever with no errors. I don't know how to find what's wrong..

I use mysql -u root --max_allowed_packet=8G < data.sql

I get however the warning option 'max_allowed_packet': unsigned value 6G adjusted to 2147483648.

Any thoughts on what could be up with this system is very appreciated.

Upvotes: 1

Views: 252

Answers (1)

bhavesh05
bhavesh05

Reputation: 53

sql file can be split in crumb , I google and found , This my be your solution http://www.sqldumpsplitter.com/ , neither I tested nor used , Please test with example file before use

Hope it is helpful !

Upvotes: 1

Related Questions