How to backup and restore a database in postgresql using pg_dump in cmd||

hi guys in this video I'll show you how you can backup and restore the database it mostly SQL using CMD in Windows so let's get started so to backup a database and restore it you just need two things the database and login root or a user the user should have the privileges like this and let's go to the CMD for waking up so here you need to give the location of the mysterious ql bin let's copy the location go to the C Drive and Program Files and then mostly SQL and your version just copy this and then go to CMD and type CD and paste the location and then click on enter and now just type the command and then you use the name and then your database name and then give the location where you want to save the backup file I am choosing desktop here just go to the C Drive and then and copy the location and paste it here and type the name of the backup file you want to give and then give the extension dot s queuing and then click on end and then give the password of your user and then click enter and even finally back up the database here you can view all how to view the database so first step is the one now let's reach through the database I will be deleting it from here restore it so to become just create database this evening and then beacon okay and now just go - and now just go to see MD and get the command your username your database name and then the location of the SQL file copy it and paste and the name and then the file extension not as you will then click on enter and then give you a password and then click enter and finally your database have been issued there so it is having my data here I was having here so you have finally restored and so you have finally backed up and these to your database using CMP thanks for watching

Channel: Tanvir Singh

Views: 22,364

Keywords: #PostgreSQL

Id: ng60lcr1jBU

Length: 5min 1sec (301 seconds)

Published: Sat Nov 03 2018