MySql 5.5 backup with True Image 2018

Frank, yes you can backup your Windows 8.1 system using ATI 2018 but the state of your MySQL database will dictate how successful the application will be in capturing your database data.

If MySQL is in use / the database locked, then Acronis will try to capture a snapshot of the db by using the Microsoft VSS snapshot feature but this will not include any data being held in the computer memory for the MySQL application.

If your MySQL application includes its own backup options, then you would be best served to use those methods and then capture the backup file using ATI 2018.

Thanks for the response, Steve.  I have tried it and it causes the database to lockup, disabling it for other users.  Is there a way around this?  Or do I just have to maybe back it up at night when I can shut the db down?    

I understand there are pre and post commands that can be written in shut it down and start it up, but i have yet to figure out the correct syntax.

 

 

 

Steve Smith wrote:

Frank, yes you can backup your Windows 8.1 system using ATI 2018 but the state of your MySQL database will dictate how successful the application will be in capturing your database data.

If MySQL is in use / the database locked, then Acronis will try to capture a snapshot of the db by using the Microsoft VSS snapshot feature but this will not include any data being held in the computer memory for the MySQL application.

If your MySQL application includes its own backup options, then you would be best served to use those methods and then capture the backup file using ATI 2018.

I have tried it and it causes the database to lockup, disabling it for other users.  Is there a way around this?  Or do I just have to maybe back it up at night when I can shut the db down?    

I understand there are pre and post commands that can be written in shut it down and start it up, but i have yet to figure out the correct syntax.

Frank, having the db application shutdown would be the best method to ensure that the db can be backed up.

You would need to know what the correct commands are to shut down and restart the db application along with allowing any time needed for any data held in memory to be written out in order to put these into a batch command script to use in any Pre and Post Commands for the backup task.  It would be best to test any scripts before adding them to the ATI backup task, and if you have a test environment to do this, it would cause the least disruption to any users.

See the following webpages that may be helpful to you.

Webpage: Start MySQL Server - see the links in the page for Stopping & Restarting the server.

Webpage: How to Back Up And Restore MySQL Databases From The Command Line

Also: MySQL Backup: Backing Up Using mysqldump Tool

Note: if you make a MySQL Backup using the above tool, then you could exclude the database folders for the MySQL Server from your ATI 2018 backup task but include the backup file created by the tool.  This should get around any need to stop the server for the backup and still protect your database content.

Steve Smith wrote:

I have tried it and it causes the database to lockup, disabling it for other users.  Is there a way around this?  Or do I just have to maybe back it up at night when I can shut the db down?    

I understand there are pre and post commands that can be written in shut it down and start it up, but i have yet to figure out the correct syntax.

Frank, having the db application shutdown would be the best method to ensure that the db can be backed up.

You would need to know what the correct commands are to shut down and restart the db application along with allowing any time needed for any data held in memory to be written out in order to put these into a batch command script to use in any Pre and Post Commands for the backup task.  It would be best to test any scripts before adding them to the ATI backup task, and if you have a test environment to do this, it would cause the least disruption to any users.

 

Steve,

I'm working now on getting the proper commands from my tech support.  They have given me the commands, but still trying to figure out paths, and... what is that box to the right of the command line box?  And are arguements necessary?

Frank, you need to put any commands in a small text file then save that file as a .BAT file.

Example:  CheckDrive.BAT

echo off
if not exist S: goto nodrive
echo "Drive found!"
exit /b 0

:nodrive
echo "Drive not found!"
exit /b 1

The above is a small batch command file that I use to check if my external S: USB drive is connected before running a backup task that writes to it, so is used as a Pre Command in the task.

The exit /b lines indicate to ATI if the command was successful (0) or failed (1).

To use the batch file, you need to open the Options >> Advanced options page as shown in the screen images below.  These show adding the above file as a Pre Command - the process is identical for adding a Post Command.

Click on the EDIT button on the right for the Pre-command entry box.

Click on the [ ... ] box on the right of the Command entry box, then select the .BAT file from the folder where it is stored.

Selecting the .BAT file will fill in the boxes as shown above.  Click on [Test command]

If all is working correctly, you should see a message to confirm the command executed successfully.

Save the changes for the backup task by clicking on the [ OK ] button at the bottom right corner.