: 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
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).
More posts by @Gonzalez347
1 Comments
Sorted by latest first Latest Oldest Best
You could split the file at the end of each group of SQL statements and then import one after the other.
Terms of Use Create Support ticket Your support tickets Stock Market News! © vmapp.org2024 All Rights reserved.