need help with database transfer

[nfury007]

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????

Thx in advance

nfury007 Reviewed by nfury007 on 10th Jul 2011. 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

[madaboutlinux]

Where you able to migrate the database on your new server?

[Jason_weds_Freddy]

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