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
1 | cd public_html |
STEP 2:
Type
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