Need up to 30 seconds to load.
[Music]
hi welcome to tech founder I am most
vehement today I will show you how to
create a MySQL database auto backup
system by batch script the first thing
you have to remember if we will stamp or
other local servers you must turn on
maestro services otherwise the auto
backup system will not work properly
then you have to find out your MySQL bin
folder location in them I have installed
them in my speed right in them the
mission is under them MySQL and bin if
we use another server you must have to
find out the bin folder location for
that server ok I have to write the bash
script in my bin drip take a normal text
file and rename it to suppose my key
will back up and change the extension
txt to back okay now it's a bad file the
first line is echo of then MySQL dump
here I have to write the MySQL database
username and password by default it is
root and there is no person but I have
to create a new username and password
for my auto backup system I want to get
backup of my this database which is part
of cells so let us create a new user
name and password
so smite username is super admin setup
posture
okay so my username is super admin
password and my database name is point
of slip now I have to write the
directory name where I want to save the
database in my case I have already
created a directory name to back up
under my II drive take the location from
here and then in which name the database
will be saved like it will be save as
viewers dot must the extension SQL okay
let us check if I double-click on my
back file and then go to my backup okay
my backup file is saved as Pierce doc
SQL please remember that if you export
your database from PHP my admin and if
you export it from C&D the database
price may be different because when spam
the exporter database it's sometimes
compress the data size so you need not
to worry about the driver size the next
thing we will do we want to create a
taxi rulers so that we can set a time
like after every 5 minutes a new backup
of our database will be saved for that
reason we can use windows default
texture Euler but my expense is there is
sometimes difficult and it's very on
Windows versions like 17 8 etc so we may
use a small soft on the name system
should work you can download the
software from my description link it's a
very small circle let us install it
it has a user-friendly window let us
start a new tux my touch name is backup
link with the MySQL back a back file
from bin directory
and working directory is clean should
you okay we want to get up back up in
every minute save the text and you may
quit go back to backup directory and
delete the previous backup file and now
we may wait for one minute to see
actually what happened
okay so it works properly the last thing
I want to save the database back up with
date and time going back to my back foot
I have a pre-written code you may pause
the video and write the code as it is
sales from the back up name from pause
to my day my time I'm saving the bad
script and going back to the backup
directory and see again what happened
okay so it works properly the file is
saved with current date and time thank
you for watching the video please like
comment and share the video and don't
forget to subscribe us
![How to Restore Old MySQL Database to New XAMPP Installation [Tutorial]](https://i.ytimg.com/vi/ugkeFUhyTD8/mqdefault.jpg)