Question How to import large sql dump via CLI

[SamirM]

Hi,
I have a CentOS 7.4 wit Plesk Onyx 17.5.3 and need to import a very large MySQL db ( abt 1Gb).
I have created the db in the Plesk panel, and cant seem to find a way to import the db via CLI.

On CentOS6x and with Plesk v12x, I could easily do this, but am a little stumped with Onyx and CentOS 7.
Will appreciate any guidance

Samir

 

[UFHH01]

Hi SamirM,

cant seem to find a way to import the db via CLI.

You might consider to use an example command like ( logged in as user "root" over SSH ):

MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin YOUR_EXISTENT_DATABASE_NAME < /COMPLETE/PATH/TO/YOUR/DATADASE_DUMP.sql

... to restore your dump - file.