How to Backup MySQL Database Automatically

How to auto backup MySQL database using batch script. You can create your own schedule database backup like- after every 5 minutes a new backup will be generated. Backup filename will be present date & time. So no need to worry about data loss.

Download Batch File-

Download System Scheduler-

[undercrackers]

sqldump is suitable for small databases, but what if you need to regularly backup a live server with quite a lot of data?

[hapticgaming]

this was very useful to me, exactly what I was looking for

[faisalqayyum]

I followed the same steps but the backup file is 0 KB

[anarchyconquer]

Works, thank you. Was exactly what I was looking for

[waitonponela]

how can I create FullBackup for Specific Database for two-time Interval using mysql command?

[jafa]

Thank you very much
I am facing a problem that the backup file is empty
Could you help me
Note that the database, username and password are correct

[LouieGalvezPhil]

Works and easy to follow. If I have several databases, must I write a batch file for each? Can it automatically backup all databases without my having to name them individually? Thanks

[shivkumarmadkar]

Hi sir i want to download my database on C panel hostinger how can i do this pls solution?

[wezendtechnology]

I found this video very helpful.thanks

[Dillinger]

I can't just back up to where my site is hosted on?

[ermiasfentaye]

A better way to backup MYSQL automatically

[colink]

For those with 0kb file, change database password from empty to your password and it will work perfectly

[obn_netchannels]

sir, thank you so much it done properly !!

[jbparkthree]

On my computer,
For /f "tokens=2-4 delims=/-" %%a in ('date /t') do (set mydate=%%a-%%b)
works for the date part thanks.

[hitec]

Thanks man, your video really helped me :)

[srinupotluri]

Thanks a lot it's working perfectly in manual ( till your 1st half video) but auto backup using this backup software not creating the proper filename with date. it's only capture the time. it's giving the SQL file but I had a problem only with file name, do i need to change any date format in system ...?

[bossoftwareandtechnologies]

It creates 0 byte file size can anybody guide ?

[glamourkzglaomourkz]

I configured and works, but I have problem with file backup it comes empty . Error on DataBase "#1356 - View 'mysql.user' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them"

[udaramethmal]

Thanks i will try this one and comment sooner...realy i was in a need of this badly..sir, can i do the automatic backup with system scheduler software by running the bat file instead of writing a scriptlines for time and the date in a bat file as i would like to get a backup file in every minute?
Thank you..

[skillzorskillsson]

What if you restart the computer? Do you need to start the System Scheduler again or does it start in the background automatically and keeps making backup?