Larger than 50MB SQL files imported into PHPMYADMIN

With root access as support: You can use SSH to import it like so:

mysql user_db < /absolute/path/to/file.sql

So if the SQL file named podcastsdb.sql was uploaded to /home/israelse/public_html/  you'd run this, just replace file.sql with the name of the sql file you need to import:

mysql israelse_db1 < /home/israelse/public_html/podcastsdb.sql

You can also use MySQL BigDump, which I've suggested to people

This will essentially cut up the sql file and import it a chunk at a time, working around the 50 MB limit in phpmyadmin.

Was this answer helpful?

Add to Favourites Add to Favourites

Print this Article Print this Article

Powered by WHMCompleteSolution