Know there in this video we are going to back up a single database.
We are going to do that using the pge on the score dump tool.
Now before we back up databases good to have a directory that you back to database too.
And there we are going to be using the terminal.
So I feel no windows would be isn't command prompt you on a Mac you can use the terminal and then we'll
be using the pge underscored dump tool to perform the backup.
So the first thing to do is to make sure you have a backup directory.
I'm going to create one now.
He my seed right.
I'm just going to right click and as good a new folder.
I just give it a name I'll call it pge back up.
Jim stand in for us.
Chris back OK.
So that's my backup director in next and I need to do is open up my command line or I've got my command
prompt here on the windows I'm just CANNON Right click on it.
ANGLE run as administrator because I want it to run as an administrator and that will give me this screen
here.
What I like to do I like to navigate to the route of the sea.
So to do the typing see the dot dot and press enter.
And that takes me back.
Do you see the dot dot again and press enter.
And that takes me back some now in the route of D.C. so I'm dozen at ipsc Ellis to clear the screen
so all I have is just route.
The next thing I want to do is to navigate to the beam directory of my post Gress installation to navigate
to your post gross installation.
Surely in the Program Files direct on and click on my Brooklands file and look for my post Chris leashing.
So that's my post Chris fuel folder.
Click on that.
Click on 10 and then click on being and don't just copy the path which is this one here.
Right click.
Copy.
Then you go back in to your command line typing Cedi to change directory this space and then paste that
location into it.
Press Centre.
So we now have access to the post Chris installation b been direct re.
I'm going to type in CNS to clear the screen.
So now that we have that it is time to use the pge on this core dump command.
So before I execute the command I want I explained the command to you briefly.
So this is a command.
I am going to execute to do the backup.
So let me run through some of.
He switches in the command.
This is the tool P gender's God Tom.
The dash.
You occleve specifies the user that is going to be used to connect to depose gris secure database server
example I have use PPO's Gress to connect to make the connection to the server.
The dash w those forces the PGA underscored dump to prompt for the password before connecting to depose
secure database server to that's what did W is for it will prompt you for a password to connect to the
server before it was Allow me but pop to proceed the dash f specifies the output file format the format
of the output file and the format can be anything.
It could be Coston format going to be used in TAR.
Or you can also have it in Esquire which is in plain text format so this is the command and we are back
in opted direct.
Remember I created a Derek precor peachy bad cops with a backup to this Derek.
And this is going to be the name of the file is going to be called devita Rental davidi Rental is the
database I'm backing up and I'm going to backdoor use in a tar format.
TAR is a archived format so this t here basically is used to represent the format of the backup we have
presented it as a dot top.
Someone to copy this into my command line and then execute the command.
Now copied the command here to Michael my life and press enter.
I should get a prompt for a password.
So I need to enter the password but make sure I have authority to do the that.
And then I press enter.
And if everything goes okay to return back to the camp be in command so that means I've got no errors.
So he would have performed the backup.
So now if I go back and take a look at my directory which is see far there is foul here called divi
the rental so you notice in his format it is in art form which is said Dot taaffe format.
Okay.
So we have successfully performed the back up using the pge on the score dump tool.
So that's it for this feature you.
Thanks for watching.
Bye for now.