MySql Backup best practices

Posted on 2011-04-27
Last Modified: 2012-05-11
I just inherited 2 MySql DBs and want to make sure my backups contain everything they need.  I plan to use mysqldump and want to back up the 2 dbs separately but wanted to know if there are any system type dbs that need to be backed up as well?  (Like the master db in Sql Server)
Question by:gcrickman
    LVL 4

    Expert Comment

    LVL 21

    Expert Comment

    " system type dbs that need to be backed up as well?  "
    you better have a copy of mysql database.
    LVL 21

    Accepted Solution


    Expert Comment

    Personnaly I use Navicat to schedule and create a .psc backup file that can easily be restored or copied to whatever backup media I'm using.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    How to fix error ""Failed to validate the vCentre certificate. Either install or verify the certificate by using the vSphere Data Protection Configuration utility" when you are trying to connect to VDP instance from Vcenter.
    A Bare Metal Image backup allows for the restore of an entire system to a similar or dissimilar hardware. They are highly useful for migrations and disaster recovery. Bare Metal Image backups support Full and Incremental backups. Differential backup…
    This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
    This tutorial will walk an individual through the process of configuring basic necessities in order to use the 2010 version of Data Protection Manager. These include storage, agents, and protection jobs. Launch Data Protection Manager from the deskt…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now