Tutorial·2024-03-22·3 min read

Import Large SQL Files with MySQL CLI (No Timeouts)

Browser imports fail? The MySQL CLI is faster and more reliable for big dumps.

The CLI bypasses phpMyAdmin limits and runs directly on the server.

Basic command

mysql -u db_user -p db_name < dump_part_1.sql

Split the dump first so each import completes quickly. Related: How to Import Large SQL Files in cPanel.

Prep for CLI import

Split your dump into predictable chunks.

Yes. CLI import runs on the server.

Your hosting's phpMyAdmin keeps timing out. Here are the actual ways to get that big database imported.

HostGator phpMyAdmin limits are low. Split the dump for reliable imports.

Bluehost’s phpMyAdmin limits can block big imports. Use this proven workflow.

GoDaddy phpMyAdmin limits are low. Here’s how to get big imports done.