Resolved pleskrestore failure

[tetrahall]

Hi,
I am trying to restore a mysql db via SSH. Uploaded the backup file "bk.sql" to server, and from the same directory, used the following command:-

plesk bin pleskrestore --restore bk.sql

I get the following message:-
Unable to import file as dump: The file you are trying to upload is not a valid backup file

I cannot use IMPORT from within Plesk because the file is large (>100mb).

Please advise. Thanks!

 

[tetrahall]

Managed to do it using the command:
MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin db_example < /path/to/database_dump

Thanks!