How to backup and restore your database(mysql, postgresql, mongodb)

Reading Time : ~ .

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

    By Posted On
SENIOR DEVELOPER at MICROPYRAMID

Need any Help in your Project?Let's Talk

Latest Comments
Related Articles
How to setup http password authentication with nginx Nikhila Mergu

HTTP Authentication is used to allow access limit to a site or particular directories by validating the username and password. HTTP basic authentication can also ...

Continue Reading...
Securing Elastic search Instance with Shield Jagadeesh V

Shield allows you to protect elastic search data with a username and password. It provides additional functionalities like encryption, role-based access control, IP filtering. It ...

Continue Reading...
ELK Stack for Parsing your Logs Jagadeesh V

In This Tutorial we will look onto parsing your syslog files and store and display it in interactable website. We will be using ELK Stack ...

Continue Reading...

Subscribe To our news letter

Subscribe to our news letter to receive latest blog posts into your inbox. Please fill your email address in the below form.
*We don't provide your email contact details to any third parties