CODEWITHSUNDEEP
mysqldatabase-backupsmysql-backup
Kalpak
Kalpak

Reputation: 3530

Can I backup multiple mysql databases (All InnoDB) without using mysqldump and just using file/folder backup

Is there any way where I can take a backup of some files/folders to take the backup of all my Mysql databases. I am using Acronis Cloud Backup tool and I dont find any option where I can backup mysql database. It is either Drive/Folder or entire machine. Need an approach without using mysqldump. Instead I am looking at directory/files backup

Also it is NOT a linux machine so cron & shell script cannot be used. It is windows 2016 server.

What is the best approach to backup multiple mysql databases which in emergency can be restored reasonably fast and accurately.

Thanks

Kalpak

Upvotes: 0

Views: 221

Answers (1)

nbk
nbk

Reputation: 49375

You can backup the complete folder

C:\ProgramData\MySQL\MySQL Server 8.0

And after reinstalling you copy all folder/files back.

I had to do it last week, so i am sure that it works, but you need all files.

And this is not incremnetal.

Upvotes: 1

Related Questions