6 MySQL Video Tutorial Importing Backup

In this video tutorial you will learn how to import database in mysql.
We will go through 2 different methods.
1. using "source" command from "mysql" command prompt.
2. using "mysql" command promt tool.

---

Closed Caption:

welcome to the sixth video tutorial for
my sequel in this tutorial we will learn
about how to import databases from
backup we will use an example of one
database from my sequence website it is
a database which you can download and
import for doing practice of about
different bicycle operations if you want
to download it you can visit this link
and from there you can download it i
have downloaded the I know TV version of
this database in my / step directory and
now we will important in our existing my
sequel server so to import any database
first of all you need to create a blank
database
let's create a blank database call my
sequel create his word
so it has created the database and now
to import the back up inside the
database need to use that database you
can confirm by selectively his statement
saying that you are using one database
at the moment my word database is
insights less temp directory once you
download it you need to unzip it so I
haven't shifted and i can import it
using source command source / 10 / were
in school
SQL this will start importing that
database from the sq5 so basically . is
qualify is the file which is a backup
which has all the SQL statements inside
it has statements for creating tables
statement for inserting rows inside
those tables and setting up all other
and relationships between those tables
if there are any so this is one method
through which we can import databases
from abroad SQL fine
there is another option which we will
see in a minute in that option we will
use my sequel command line to to import
databases through command line in our
past tutorials we have seen that we can
use my secret command and specify
username and password and database to
connect and start using it on the
command line from the bicycle problems
once this import is finished I will show
you how to import database using bicycle
command from here we go
it has just finished importing the
database from the daughters school file
you want to see how many tables it is
important you can see you can use
so tables come on which will tell you
there are three tables and if you want
to see how many pieces are there in each
table we can use described command the
esc is a short form for you can use it
city it says there are five different
fields or columns inside that data in
fact that table and the type of data it
can handle you can also do the same
thing for country and so on so this is
one method which we used to import
database using source command now let's
create another database call word sea
life and
we need to jump on the second command
prompt where we can use the command line
to to import that data is the car line
so to import data bases from come online
you can use my sequel command and I will
connect to this and we're using root
user minus p for the password and then
it'll base works Eli and as I am inside
the temp directory I i can just specify
the final straightaway so this process
will start importing same day same
database in tables inside the world
sealine database so the first in the
first half of this video we have created
a database called word and we important
the database using the command line
using the source command like this and
now we are and then and then we created
another database called one see a light
and we are importing the same database
inside that database Caldwell CLI using
command line options so these are two
different methods which which is
convenient to you can use and to import
databases from the SQL backup this this
process is still going on it as we have
seen earlier it takes couple of minutes
to import this data base in in my
computer so once it is finished it will
prompt you back on the dollar prompt if
you're using the linux system and
depending on the operating system you
use here we go it has finished importing
the same database inside world CLA and
now a few ball to the bicycle prompt and
if you see use CLI and
so tables it will show you the same
tables and you can also go back to World
database so tables so from from the
Titan of this is this section when you
saw table as you can see from which
database it is showing you those tables
so that you can you can now import
databases from any backups and these are
two different methods which is
convenient to you can use will see other
tutorials in coming days and weeks and
thanks for watching and have a nice date