DreamHost SQL Import Guide

DreamHost's phpMyAdmin times out on large dumps, but SSH access makes the CLI the better route.

Typical limits

  • • phpMyAdmin import timeouts on large files
  • • Upload size limits in the web interface
  • • Remote database host adds latency to imports

Best fixes

  • • Use SSH and import with the mysql command line
  • • Reference the database hostname, not localhost
  • • Split the dump if you must use phpMyAdmin

Quick fix

Split your dump into smaller chunks before importing.

Open SQLSplit

Related articles