How to Import a Large Database in cPanel Using SSH


This article provides a guide for how to import a large database in cPanel using SSH. This technique is helpful with a database that is too big to import using phpMyAdmin's web interface.

How to Import a Large Database in cPanel Using SSH

To import a large database in cPanel using SSH, follow the steps below:

  1. Login to the cPanel server via SSH console.
  2. Run the following command:
    mysql -p -u user_name database_name < file.sql
    
    (Replace 'user_name' with the database user, 'database_name' with the database name, and 'file.sql' with the with the actual file name including relative file location.)
  3. Enter the database user password and click "Enter/Return" to submit.
  4. This process may take some time, depending on how large the database is. When the import is complete, the SSH terminal will return "[user@server ~] $" default prefix.

Conclusion

You now know how to import a large database in cPanel using SSH (phpMyAdmin workaround).

  • database, import, mysql, mariadb
  • 0 A felhasználók hasznosnak találták ezt
Hasznosnak találta ezt a választ?

Related Articles

Video: Create Email Address in cPanel

This video tutorial demonstrates how to create an email address using cPanel Shared Hosting...

Disabling mod_security in cPanel

Mod_security is an apache module that helps to protect your website from various attacks. It is...

Video: Setup Email Forwarder in cPanel

View our Step-by-Step Tutorial Video for Setting up an Email Forwarder in cPanel Shared Hosting.

Install an SSL Certificate Using the AutoInstaller Software in cPanel

This article will describe how to use AutoInstall to install an SSL certificate.The AutoInstall...

Video: Add MX Entry in cPanel

This video tutorial provides Step-by-Step instructions for adding an MX entry in cPanel Hosting...