Step-by-Step Guide: Uploading a Large WordPress Database via SSH with PuTTY

Service Description:

Follow these detailed steps to upload a large WordPress database via SSH using the PuTTY application:

1. Upload your database file to the File Manager (public_html) folder.
2. Create a new database.
3. Create a new user for the database.
4. Add the user to the database and enable all privileges.
5. Go to the SSH Access section.
6. Click on Manage SSH Keys.
7. Create a Public Key, then click manage and authorize it.
8. Download the Private Key after converting it using a passphrase (password) and save it on your device.
9. Go to cPanel again and click on Manage SSH to get your login info:
   • Server IP:
   • Username:
   • SSH port:
10. Download the PuTTY application from here.
11. Create a new profile using Server IP, Username, and SSH port.
12. Go to the Connection, Auth, Credentials, and upload the private key you downloaded previously.
13. Connect using your USERNAME.
14. Enter your password.
15. Enter the first command: cd /home/username/public_html (replace /home/username/ with your Home Directory).
16. Enter the second command: mysql -u database_username -p database_name < file.sql (replace database_username with your database username, database_name with your database name, and file.sql with your database file name uploaded to the public_html folder).
17. You will be asked to enter your database password. Paste it and press enter.

Note: The passwords will not be displayed as a security measure when using SSH access via PuTTY. Just copy and paste it, and it will work

.