open /usr/local/mysqlThis opens the MySQL folder; now select and drag and drop the data folder onto your open Backup window. Now you can backup up your MySQL data. You can use a similar trick for other hidden folders.
|
|
|
I use Apple Backup to backup my key files to a second hard drive. This works well except that when you select which files to backup you can't choose hidden or system files. As I use my Mac for web development utilising PHP and MySQL, I want to backup both my source code and my MySQL data. To add a hidden file to the backup list, try the following. In Terminal, type:
open /usr/local/mysqlThis opens the MySQL folder; now select and drag and drop the data folder onto your open Backup window. Now you can backup up your MySQL data. You can use a similar trick for other hidden folders.
•
[5,259 views]
Hint Options
Better (safer) way to back up MySQL databases...
That's a bad way to backup a database - any open connections to the database and you're hooped.
It's better to dump the data to a text file, and back that up.
Chance username to your mysql user, and databasename (both places) to the name of the database you want to back up. Here, I assume you have a directory named "backups" in your home directory. Change that to anything you want.
This will create a nicely gzipped archive of the sql dump, which can be easily backed up, ftp'ed, and of course restored.
It's very straightforward to add this to a crontab to run at say 2am every day. That's what I have on all of my servers. And crontab items on other machines to grab the archive every morning at 3am...
Use Apple Backup to backup hidden files
Hmmm...i've tried that...but it only works for files you have the permission to....
Use Apple Backup to backup hidden files
open terminal and type "sudo open /Applications/Backup.app" hit return after you enter your password, Backup will run with root permissions
Command Shift G
I have never used Apple Backup Utility but it sounds you add files to be backed-up by an Open File Dialog, which allows you to enter any local path by pressing Command Shift G to opens a window allowing you to enter /my/hidden/directory/ or whatever you would like.
Note: This is also works for finder windows and Save Dialogs.
Use Apple Backup to backup hidden files
Apple's Backup2 only works if your home directory is on the same partition as the system's. For that reason alone I use SilverKeeper. Unsure about SilverKeeper's ability to handle hidden files, though. |
SearchFrom our Sponsor...Latest Mountain Lion HintsWhat's New:HintsNo new hintsComments last 2 daysLinks last 2 weeksNo recent new linksWhat's New in the Forums?
Hints by TopicNews from Macworld
From Our Sponsors |
|
Copyright © 2014 IDG Consumer & SMB (Privacy Policy) Contact Us All trademarks and copyrights on this page are owned by their respective owners. |
Visit other IDG sites: |
|
|
|
Created this page in 0.30 seconds |
|