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