How to get and restore database backup on linux server

For taking backup of your database on Linux Server you have to make sure that your database is good enough. with shell access you can take the database backup in .sql format with following command

#mysqldump user_databasename > database.sql

As you are having database backup and want to restore it then use following command

#mysql user_databasename < database.sql