Friday, September 12, 2008

How to backup the database from server

Login to server via shell using shell details

Enter Following commands:

[root@XYZ]# cd /var/www/vhosts/abc.com/foldername

[root@XYZ backup]# mkdir

[root@XYZ backup]# cd /

## COPY SYSTEM FILES DIRECTLY FROM DEST DATABASE

[root@XYZ ]# cp -pR /var/lib/mysql/dbname/* .

## Ensure if DATA is copied for not

[root@XYZ ]# ls

## list will display here

No comments: