Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

MySql Backup best practices

Posted on 2011-04-27
4
Medium Priority
?
418 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!
0
Comment
Question by:gcrickman
  • 2
4 Comments
 
LVL 4

Expert Comment

by:vaibhavjaiman
ID: 35482153
0
 
LVL 21

Expert Comment

by:K V
ID: 35482296
" system type dbs that need to be backed up as well?  "
you better have a copy of mysql database.
0
 
LVL 21

Accepted Solution

by:
K V earned 2000 total points
ID: 35482323
0
 

Expert Comment

by:David Smithstein
ID: 35483901
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
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
This article shows how to use a free utility called 'Parkdale' to easily test the performance and benchmark any Hard Drive(s) installed in your computer. We also look at RAM Disks and their speed comparisons.
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Suggested Courses

564 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