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