SSH is faster and more reliable when your database is too large for phpMyAdmin.
1. Prepare Your Files
Upload your .sql database dump to your home directory.
Ensure the database exists and your user has full access.
2. Connect via SSH
Log in using an SSH client.
Navigate to the folder where your .sql file is located.
3. Import the Database
mysql -u username -p databasename < dumpfile.sqlEnter your database password when prompted.
4. Verify the Import
Log in to MySQL or phpMyAdmin to confirm that tables and data are present.
Tip: For very large databases, avoid phpMyAdmin to prevent timeouts. You can compress the file (.sql.gz) and extract it before importing if needed.