Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

The problem with testing is that one can never be sure (it may seem to work and then you find some thing changed later). A definitive statement from the vendor would definitely be helpful (I cannot seem to find any).

I am thinking about running MySQL Enterprise Backup between MacOS and Liunx OSes

share|improve this question

1 Answer 1

MySQL Enterprise Backup (MEB) is designed to create a point-in-time snapshot of data but only backs up data locally. If the dataset is relatively small, try setting up an NFS share and run MySQL Enterprise Backup with the NFS share as the Target. Of course, there may be some risk involved.

Please check out these links on this subject for further research on MEB

Using MEB with data on server with MacOS and Linux OS on the Target Server? One can only guess. Personally, if I had to port mysql data from one OS to another I would recommend this:

  • Run mysqldump from MacOS to sqldump.sql
  • Install mysql on Linux
  • Load sqldump.sql into Linux
  • Setup replication between servers
    • MacOS running mysql as Master
    • Linux running mysql as Slave

From here, just install MEB on the Linux Box (For free version, use XtraBackup) and run your MEB backups locally on the Linux.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.