Get Database Backup and Restore Database from Backup Using SSH(Terminal).

0
115
views
Advertisement

In this post we’ll let you know how to get Database Backup and how to Restore Database Using SSH. In this post we have mention both types of commands for get database backup/restore from .sql file or get database backup/restore from compressed file.

If you want to run sql query and you need to go into the mysql mode then following command will helps you on that. you just need to replace “root” with your database username and run this command after that it’ll ask you for your database user’s password. you just need to enter the password of your database user and press enter that it.

Connect To Mysql

mysql -u root -p

For run below commands you don’t need to login into the mysql on your terminal. You just need to loged in to your server using ssh and run following commands and you’ll get database backup or you’ll restore database Using this command.

Take Database Backup

Following Command will helps to create Database backup without compressed. You just need to replace “root” with your database username and “DBUSER_PASS” with you Database User’s Password and also you need to replace “DATABASE_NAME” with your Database name and PATH with your directory path and don’t forgot to replace file FILE_NAME.sql with filename which you want.

mysqldump --opt -u root -pDBUSER_PASS DATABASE_NAME > /PATH/YOU/WANT_SAVE/FILE_NAME.sql

Take Compressed Database Backup

With this command we are able to create Database Backup with compressed file and it’s size lower then normal backup. And we are always suggest you to take backup with compressed file because it’s really helps you when your database size is big. You just need to run following command for take Database Backup with compressed file. And you just need to replace “root” with your database username and “DBUSER_PASS” with you Database User’s Password and also you need to replace “DATABASE_NAME” with your Database name and PATH with your directory path and don’t forgot to replace file FILE_NAME.sql.gz with filename which you want.

mysqldump --opt -u root -pDBUSER_PASS DATABASE_NAME | gzip -9 > /PATH/YOU/WANT_SAVE/FILE_NAME.sql.gz

Restore Database

Following command will helps you to restore database from backup. To restore Database you just need to run following command and replace “root” with your database username and “DBUSER_PASS” with you Database User’s Password and also you need to replace “DATABASE_NAME” with your Database name and PATH with your directory path and don’t forgot to replace file FILE_NAME.sql with your backup filename.

mysql -u root -pDBUSER_PASS DATABASE_NAME < /PATH/YOU/WANT_SAVE/FILE_NAME.sql

Restore Database from Compressed file.

Using with following command you are able to restore database from Compressed file. To restore Database you just need to run following command and replace "root" with your database username and "DBUSER_PASS" with you Database User's Password and also you need to replace "DATABASE_NAME" with your Database name and PATH with your directory path and don't forgot to replace file FILE_NAME.sql with your backup filename.

gunzip < /PATH/YOU/WANT_SAVE/FILE_NAME.sql.gz | mysql -u root -pDBUSER_PASS DATABASE_NAME

We hope this post helped you to Get Database Backup Or Restore Database Backup Using SSH(Terminal). Bookmark it for your future reference. Do comment below if you have any other questions or doubts.

P.S. Do share this post with your team.