login to you ssh.. and then for backup use:

mysqldump --opt -u user -p dbname > {path}/backup.sql

and for restore use

mysql -u user -p dbname < {path}/backup.sql


Replace user with the username of ur account (cpanel/kloxo) and {path} with the path..

for example

mysqldump --opt -u nfury007 -p nfurydatabase > /home/nfury007/public_html/backup.sql
Jason_weds_Freddy Reviewed by Jason_weds_Freddy on . need help with database transfer Hellow I have my database backup on my leech. I want to add this back up to my new vps. I am using kloxo panel Can anyone help me please???? Rating: 5