MITBBS archive log


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.



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: Logo

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s