How to backup and restore mysql, postgresql and mongodb databases

In the production environments, data loss when we accidentally delete the files, or when server crashes or system fails, or when we applied migrations to the data that didn't work so we don't get previous data with the schema.

So we need to do data dump each time or every day when we do changes in the production

In this blog post, you will see how to take a backup, restore your database for MySQL, PostgreSQL, MongoDB databases.

Mysql:

    Data Backup Command: 

    mysqldump -u user_name -puser_password database_name > mysql_dump_file
    Data Restore Command:

    mysql -u username -p database_name < mysql_dump_file            

    user_name: Mysql username

    password: Mysql Password

    database_name: database name

    mysql_dump_file: the file to which you want to dump the data

Postgresql:

   Data Backup Command: 

   psql -U user_name -h host_name db_name < pgsql_dump_file
   Data Restore Command:   

   psql -U user_name -h host_name db_name < pgsql_dump_file         

   user_name: MySQL username

   password: Mysql Password

   db_name: database name

   pgsql_dump_file: the file to which you want to dump the data

Mongo db:

   Data Backup Command: 

   mongodump --username user_name --password pass_word --db database_name --out path_to_your_dump_directory        
   mongoexport --username user_name --password pass_word --db database_name --collection collection_name --out collection_name.json  

   Data Restore Command:

   mongorestore --username user_name --password pass_word --db database_name path_to_your_dump_directory        
   mongorestore --collection collection_name --db database_name path_to_your_dump_collection         

      user_name: mongo username

      password: mongo Password

      collection_name: database collection name

      database_name: database name

Posted On 24 June 2016 By MicroPyramid


Need any Help in your Project?Let's Talk

Latest Comments
Related Articles
HTTP2 and SPDY Protocols - Make HTTP Faster and Safer

HTTP/2, next version of HTTP/1, http/1 can not handle the present web which has become more resource intensive, it cannot processes multiple requests in an ...

Continue Reading...
Letsencrypt wildcard - Setup wildcard subdomain using letsencrypt and certbot

To get wildcard supported certificates, we need to pass the challenge which requires adding TXT records in your dns records.
To get certificates for single ...

Continue Reading...
Configuring WordPress Blog as sub-directory alongside Django in Nginx

Using regular expressions within Nginx we can bind urls to particular application servers, below we will configure wordpress blog and django site to be deployed ...

Continue Reading...
open source packages

Subscribe To our news letter

Subscribe and Stay Updated about our Webinars, news and articles on Django, Python, Machine Learning, Amazon Web Services, DevOps, Salesforce, ReactJS, AngularJS, React Native.
* We don't provide your email contact details to any third parties