How to import large MySQL database via command line on CWP, VestaCP and Cpanel s

In this tutorial we’ll learn how to import large mysql databases via ssh terminal command line interface. Large mysql database is the issue when you import it via phpMyAdmin and its limit for uploading is lower then your initial mysql db size. In this case we need to import that database via command line – ssh or terminal.

It is always recommended to import database via mysql command line because it is easy and give less overhead like corrupted tables etc.

I always do mysql databases export and import via command line only.

Follow the below commands to import mysql database:

example usage of this command suppose your database name is “blawp_db” and you’ve database backup named “wordpress_cms.sql” uploaded in “/home” dir.

then the command need to be used like :

if you’ve database archive you need to extract it before importing via upper command :

if your database is archived in zip eg : database.sql.zip

if your database is archived in gzip eg : database.sql.gz

if gunzip command doesn’t work install the package :-

For RHEL/Centos :

for Debian/Ubuntu :