Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How to backup InnoKB databases?

backup databases innokb
0
Posted

How to backup InnoKB databases?

0

InnoKB stores all databases under the default ‘[install-dir]/repository’ folder or your custom repository directory. To backup a database, periodically archive the database folder including all files by using a zip/tar utility (e.g. WinZip, WinRar or Unix tar). Note that before making backups for InnoKB databases, please be sure to first stop or pause InnoKB service, in case of any file access conflicts. To backup the server configurations, just create backups for both the ‘innokb_config.xml’ and ‘innokb_grant.xml’ files.

Related Questions

What is your question?

*Sadly, we had to bring back ads too. Hopefully more targeted.

Experts123