I am trying to find out some tool which can take physical backup of MYSQL
database. Like mysqlbackup
but it is not open source. There is mysqldump
but i want to take physical backup. Can someone please suggest me some tool to take backup of MYSQL db on windows
. And i am using Innodb
as my database engine.
MySQL – How to Take Physical Backup of InnoDB Database on Windows
backupinnodbMySQLmysql-5.5windows
Related Question
- MySQL backup InnoDB
- Mysql – Backup / Export data from MySQL 5.5 attachments table keeps failing!
- MySQL incremental backups per database (not global)
- MySQL – How to Backup Database on Windows Without Using mysqldump
- MySQL – How to Backup Database from One Cloud Server to Another
- MySQL – How to Take Backup from Another Server Using AutoMySQLBackup
- Mysql – How to take single database backup using thesqlbackup command in Mysql 8.0.18 version DB
Best Answer
You literally do not need a third party tool.
STEP 01
Find out the path to the data by running
For this example, let's suppose it is
C:\Program Files\MySQL\MySQL 5.6\data
STEP 02
Pick a destination folder to copy the data directory
For this example, let's pick
D:\MySQLBackup
STEP 03
Create batch file called
C:\RunMySQLBackup.bat
with the the following commandsCONCLUSION
Just run
C:\RunMySQLBackup.bat
on demand or add it to the Windows Scheduler. This is just a rough backup script and it only keeps one copy.This is not the first time I discussed this. I have another post MySQL backing up MyISAM tables by copying the physical files - and automating the process for copying an all-MyISAM database.
You should think about doing mysqldumps since you can get the data at a point-in-time. Should you want to go back to mysqldumps, I have another post I wrote on how to do mysqldumps in Windows with named backup filenames based on the data and time (mysqldump with automatically generated export name).