Tuesday, February 5, 2013

Backup huge DB from Server

How to Backup the Huge Database from server.

1) Download Putty from the below URL,

http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html

2) Connect Putty with your website details like yourwebsitename.com

3) Follow the below step after login the Putty 

Login as : TTTTTTTTTT

TTTTTTTTTT@websitename.com's password :

Last login........

TTTTTTTTTT@websitename.com [~]# ls
///////////////////////////////////////

//It will list all Folder from the server

///////////////////////////////////////

Last login........

TTTTTTTTTT@websitename.com [~]# mysqldump -u DB_username -p DB_name > public_html/backup/backup_db.sql

Enter password: ______

TTTTTTTTTT@websitename.com [~]# // Now it backup the DB and save this into server with the name 'backup_db.sql' inside backup folder

exit


4) Now it backup the DB and save this into server with the name 'backup_db.sql'

5) After that you can download this from server via FTP or control panel

No comments:

Post a Comment