Log in to the VPS with the root user.
# ssh root@VPS_IP_address
Enter the following command in the terminal –
# mysql -u [username] –p [database_name] < [dump_file.sql]
> database_name is the name of the empty database into which you want to load data from the backup file.
Enter the username and password if prompted for a password.