Import Large Database in cPanel by SSH Command

Admin

3 months ago

Importing large database from phpmyadmin Import is difficult because of time limit and file size,
so here we will see how to import large databases in phpmyadmin or cPanel using SSH.

You can use the ‘Terminal’ Option from Cpanel or PuTTY for command.

Here we will use ‘Terminal’.

STEP 1:
Go to public_html directory
Type in terminal

cd public_html

1	cd public_html

STEP 2:
Type

mysql -u your_DB_username -p your_db_name < path_of_your_sql_file.sql

1	mysql -u your_DB_username -p your_db_name < path_of_your_sql_file.sql

Press Enter

STEP 3:
This will ask for password: Type the Database password of your DB

and wait… your data will imported successfully