How to Import a Large Database via SSH

You need to have:

• Access to the cPanel of your hosting account.
• SSH access enabled (if you don't have it, request it from your hosting provider).
• The .sql backup file already uploaded to the server (via FTP or through the cPanel File Manager).
• A MySQL user with permissions on the database.

​

1. Log in to your cPanel
Go to: yourdomain.com/cpanel
Enter your username and password.

2. Create the database and the MySQL user
Inside cPanel:

• Go to "MySQL Databases".
• Create a new database.
• Create a MySQL user (or use an existing one).
• Link the user to the database and grant all privileges.

Save the following information:

• Database name (e.g., user_db)
• Database user (e.g., user_user)
• Password

​

3. Upload the .sql file to the server
Use the File Manager in cPanel or an FTP client like FileZilla.

Upload the .sql file to the desired directory, for example: /home/your_user/

​

​

4. Access the server via SSH

Use a terminal (on Linux or macOS) or the PuTTY program (on Windows).

Access command:

ssh your_user@yourdomain.com

​

​

5. Import the database using the MySQL command

Once connected via SSH, run the following command:

mysql --force -u username -p database_name < file.sql

• You will be prompted for the MySQL user’s password.
• The process may take several minutes depending on the size of the file.

6. Verify that the import was successful

Access phpMyAdmin from cPanel.

Open the database and check that the tables and data are present.