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
Ansible Galaxy Introduction.

Ansible Galaxy is the hub of ansible scripts contributed by users. To follow this article its important that you know about ansible. We have a ...

Continue Reading...
Elastic Search Security Measures

After Installing Elastic Search in production, many new developers leave it unconfigured. In this Post, we will look into important config file changes and its ...

Continue Reading...
MySQL Setup and Security

In This Post you'll learn to install and secure your MYSQL Setup to interact with external applications.

Continue Reading...

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