We help IT Professionals succeed at work.

MySql Backup best practices

428 Views
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)
Thanks!
Comment
Watch Question

theGhost_k8Database Consultant
CERTIFIED EXPERT

Commented:
" system type dbs that need to be backed up as well?  "
you better have a copy of mysql database.
Database Consultant
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
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.  www.navicat.com
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.