FREE Site Transfer With All Plans

  • FREE WordPress Plugin Tune-Up
  • FREE SEO Analysis and Overview
Knowledgebase

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

http://www.ozerov.de/bigdump.zip

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

Client Login

Email

Password

Remember Me