Restoring MySQL Database

RoaRk

New Member
So, I have a script (not mine) which makes rolling backups of the MySQL database for my server. My question is how do I then restore back to the previous database setup in the event of a malicious attack. Here is the script I am using...

Code:
@echo off
COLOR 0B
echo ©©©                      DayZ Database Backup Script                        ©©©
echo ©©©                                                                          ©©©
echo ©©©          This Script will backup your database every 30 minutes          ©©©
echo ©©©                    To end this Script, just close it.                    ©©©
echo ©©©                                                                          ©©©
echo ©©©                                                                          ©©©
echo ©©©                                                                          ©©©
echo ©©©                                                                          ©©©
echo ©©©                                                                          ©©©
echo ©©©                                                                          ©©©
echo ©©©                                                                          ©©©
echo ©©©                                                                          ©©©
echo.
echo.
 
timeout /T 3  > nul
echo Checking for directories...
 
IF exist "C:\ProgramData\MySQL\MySQL Server 5.5\db_backup" ( echo The Directory Exists ) ELSE ( mkdir "C:\ProgramData\MySQL\MySQL Server 5.5\db_backup" && echo Directory Was Created)
IF exist "C:\ProgramData\MySQL\MySQL Server 5.5\db_backup\db_backup" ( echo The Directory Exists ) ELSE ( mkdir "C:\ProgramData\MySQL\MySQL Server 5.5\db_backup\db_backup" && echo Directory Was Created)
IF exist "C:\ProgramData\MySQL\MySQL Server 5.5\db_backup\db_backupHourOld" ( echo The Directory Exists ) ELSE ( mkdir "C:\ProgramData\MySQL\MySQL Server 5.5\db_backup\db_backupHourOld" && echo Directory Was Created)
IF exist "C:\ProgramData\MySQL\MySQL Server 5.5\db_backup\db_backup1Hour30MinsOld" ( echo The Directory Exists ) ELSE ( mkdir "C:\ProgramData\MySQL\MySQL Server 5.5\db_backup\db_backup1Hour30MinsOld" && echo Directory Was Created)
IF exist "C:\ProgramData\MySQL\MySQL Server 5.5\db_backup\db_backup2HoursOld" ( echo The Directory Exists ) ELSE ( mkdir "C:\ProgramData\MySQL\MySQL Server 5.5\db_backup\db_backup2HoursOld" && echo Directory Was Created)
 
echo.
echo.
echo.
echo.
echo.
echo.
echo.
echo.
echo.
echo.
echo.
echo.
echo.
echo.
echo.
echo.
echo.
echo.
echo.
echo.
echo.
echo.
 
SET SOURCE="C:\ProgramData\MySQL\MySQL Server 5.5\data\dayz"
SET TARGET="C:\ProgramData\MySQL\MySQL Server 5.5\db_backup\db_backup"
 
SET SOURCE2="C:\ProgramData\MySQL\MySQL Server 5.5\db_backup\db_backup"
SET TARGET2="C:\ProgramData\MySQL\MySQL Server 5.5\db_backup\db_backupHourOld"
 
SET SOURCE3="C:\ProgramData\MySQL\MySQL Server 5.5\db_backup\db_backupHourOld"
SET TARGET3="C:\ProgramData\MySQL\MySQL Server 5.5\db_backup\db_backup1Hour30MinsOld"
 
SET SOURCE4="C:\ProgramData\MySQL\MySQL Server 5.5\db_backup\db_backup1Hour30MinsOld"
SET TARGET4="C:\ProgramData\MySQL\MySQL Server 5.5\db_backup\db_backup2HoursOld"
 
goto Y
 
:Y
..........

This works perfectly well as far as backing up that folder and deleting backups that are older than 2 hours, but as you can see it backs up the "\data\dayz" folder which contains .frm files. I feel like I have tried to restore the database by just replacing the files in "\data\dayz" with the files from a backup, but it didn't do anything. Do I have to delete or move "ib_logfile0" and "ibdata1" in "MySQL Server 5.5\data"? in order for this to work? Someone let me know what I'm missing here. Thanks!
 
Back
Top