MySQL - Restoring Database From Backup file - BASH

http://filmsbykris.com/wordpress/?p=320

---

Closed Caption:

of up
okay so we messing with our database
table here quite a bit and basically we
got it down to where
weekly all users except for one and
she's in there
I five times are likely not too long ago
I did a backup
my database so let's see how we can
restore that
so we'll just type in X your text the
MySQL and my list
files in my directory you can see that I
have to
a and we have data backup and backup SQL
I let's go with that data backup that sq
I think that's the one that I want to
import will have a look there so
basically our command is going to be
this wrist say
MySQL dash you for user route
dash p and your passer with no space
once again up sure to watch the previous
trials before jumping in here
might be lost they were gonna say the
database that we want to
restore to which in this case is films
by Chris and there is going to
use the less than symbol walk a simple
there
ever gonna say the name the file that we
want to restore back into it
sold us a database our data backup that
SQL
will hit enter who okay um
I type something wrong it's from like
Chris KR
there we go and its films
the okay there we go
no error so we should be good now we can
log back
into our database with sequel dash each
local host ash
you ruin our dash P password or password
13 you can say use database films by
Chris
and now if I say select
ass strict
from so that means select everything
from the table
users semi-colon enter you can see that
restored back to
are that older database om so
that is again over in the past how to
backup your database
and an assist our storage done the story
alright after but i wanna to
mess up the database a little bit more
so that's why we did other tutorials in
between so we're back to our original
database with our original users and are
four columns
so that is how you can restore lets a
social its Reese review real quick
basically we've got
are MySQL dashed you for user root users
user using
dash p for password in your password
with no space between the pee in the
password
being name the database you're restoring
to and then left then and the name
love the SQL file you backed up
previously
so there you go we've we've learned how
to backup databases
learn how to back up tables we learn how
to restore the database tables we learn
how to pack stuff up to
SCV come separated value files and how
to restore from those as well
are actually import are from those set
files
so moon quite a long time that's fine
because most are doing this tutorial ce
just let you know I'm doing all these
mice SQL tutorials
in one day so far II was planned due in
like
325 and I think a bit like over 10 now
arm cuz keep on seeing more and more
things I want to TGI
so I hope you guys are enjoying these
done I so have
more to come I think so thanks for
watching and have a great day
0 I'm hmm