How to Use SSH to Import Large Databases into MySQL

SSH is faster and more reliable when your database is too large for phpMyAdmin.

How to Import

1. Prepare Your Files

2. Connect via SSH

3. Import the Database

mysql -u username -p databasename < dumpfile.sql

4. Verify the Import

Tip: For very large databases, avoid phpMyAdmin to prevent timeouts. You can compress the file (.sql.gz) and extract it before importing if needed.