MySql backup every 5/10 mins

[rossco5378]

Does anyone know of a free mysql tool that wiill export my server database every 5 minutes?

 

Thanks.

[Antichrist]

use BEC and a bat file for sql backups or just use windows scheduler or whatever the hell it's called

[LunatikCH]

there is a free tool, its called cmd.exe

but this in a textdocument:

cd /D "C:\Program Files\MySQL\MySQL Server 5.6\bin"

mysqldump -u root -p DBNAME --password=YoUrAwEsOmEpAsSwOrD --result-file="C:\Yourawesomebackupdirectory\SQL Backup\Backup.sql"

Safe the textdocument as a .bat file and run it with a sheduler eg. BEC or Planed Tasks....

[rossco5378]

there is a free tool, its called cmd.exe

but this in a textdocument:

cd /D "C:\Program Files\MySQL\MySQL Server 5.6\bin"

mysqldump -u root -p DBNAME --password=YoUrAwEsOmEpAsSwOrD --result-file="C:\Yourawesomebackupdirectory\SQL Backup\Backup.sql"

Safe the textdocument as a .bat file and run it with a sheduler eg. BEC or Planed Tasks....

Fair enough but that just over writes the file... I want to keep atleast 24 hours worth of backups. Is there anyway to save the sql with a time and date on the end?

 

EDIT:

This bat file doesn't fully back up the database for some reason. It doesn't backup the contents of each table

[LunatikCH]

Fair enough but that just over writes the file... I want to keep atleast 24 hours worth of backups. Is there anyway to save the sql with a time and date on the end?

 

EDIT:

This bat file doesn't fully back up the database for some reason. It doesn't backup the contents of each table

Did you set your Mysql directory correct?

I run that on mysql server 5.6 and one server 5.5 without issues.

[cen]

http://www.redolive.com/automated-mysql-backup-for-windows/

[rossco5378]

http://www.redolive.com/automated-mysql-backup-for-windows/

Nice, Just what i was looking for. But how do i make it just backup the dayz_epoch database and not the others?

 

Thanks