Sql Backup And FTP

Welcome Guest Search | Active Topics | Log In | Register
Hot Backup? MySql Backup Options · View
byd3k
#1 Posted : Friday, March 9, 2018 9:33:20 AM
Rank: Newbie

Groups: Registered

Joined: 3/9/2018
Posts: 1
Location: Tampa Bay FL
Hi,

When MySql runs, is that considered a hot backup?

We have an application that uses MySql, and is installed on a high-end laptop. Throughout the day, 2-4 users access an app at random which queries the database. I was hoping to kick off backups every two hours in-case soda or coffee comes in contact with the laptop.

If I use a basic script that the vendor provided to us, the database size is <=200mb's.



If MySql Backup does not perform a hot backup, any suggestions?

Thank you in advance.
Alexander Omelchenko
#2 Posted : Monday, March 12, 2018 3:24:38 AM
Rank: Advanced Member

Groups: Administrators, Registered

Joined: 12/23/2015
Posts: 456
Hi,

MySQLBackupFTP creates backups with the help of mysqldump. By default mysqldump is not hot backup tool.

If your tables are pure InnoDB, and you use the --single-transaction option with mysqldump, then, yes, it would be considered hot.

You can add this options into the "Extra command line params:" at the "Export Options" windows. To open it please click "Advanced backup settings" > "More SQL Options..." > "Export options...".

Please find more details at https://dev.mysql.com/do....7/en/innodb-backup.html
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You can create polls in this forum.
You can vote in polls in this forum.

©Pranas.NET Sql Server Backup MySql Backup Free SQl Backup SQL Backup Master Employee monitoring software Web Scraping Azure SQL Database Backups ergonotes.com