MITBBS archive log

05/05/15

My iMac disk space is also used up. Moved the mysql data file (/usr/local/mysql/data) to external hard drive  (/Volumes/diskname/MysqlData/data)

  1. close mysql server
  2. sudo cp -R /usr/local/mysql/data /Volumes/diskname/MysqlData/.
  3. In /usr/local/mysql/my.cnf, add “datadir =  /Volumes/diskname/MysqlData/data”
  4. restart mysql server

The drawback is there will be no TimeMachine backup for this database…

update 1: It seems I can make an alias for the /Volumes/diskname/MysqlData/data and drag the alias into my iMac disk. The timemachine will backup this directory.

update 2: Another way to backup directory on external HDD is to remove the directory on TM’s exclusion list. I will use this method for now.

========================================================

Advertisements

About cgao

Cambridge, MA
This entry was posted in mitbbsArchive, mysql and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s