Mobile app version of vmapp.org
Login or Join
Gonzalez347

: Import huge SQL file(6GB+) to MySQL on VPS I'm trying to import a DB from .sql file, but it's impossible, cause like I said is over 6GB with a lot of records in it and I hit the limit

@Gonzalez347

Posted in: #Mysql

I'm trying to import a DB from .sql file, but it's impossible, cause like I said is over 6GB with a lot of records in it and I hit the limit of max_allowed_packet. I use my cPanel user to login in mysql via PuTTy, but it requires SUPER privileges to set this variable(max_allowed_packet).

10.01% popularity Vote Up Vote Down


Login to follow query

More posts by @Gonzalez347

1 Comments

Sorted by latest first Latest Oldest Best

 

@Gretchen104

You could split the file at the end of each group of SQL statements and then import one after the other.

10% popularity Vote Up Vote Down


Back to top | Use Dark Theme