MacOS: Could not read files copied from external drive to your Mac

While you have successfully copied the data from your external devices particularly from NTFS file system to your MacOS's file system (APFS), you still would need to struggle to access those files later for some reason. Or in certain cases being a super user you may be able to access those files, but not your applications.

Here the three simple steps to fix the issue.

Prerequisite:

Step 1: Install the XCode command line tools.

$ xcode-select --install

Actual commands that fixes the issue:

Step 2: Get the file information like file type, creator, and other file attributes etc. and verify.

GetFileInfo <path to file>
Example: GetFileInfo /Users/venkat/backups/VMDiskFile.vmdk


Step:3 Change it's file permissions by executing

SetFile -c "" -t "" <path to file>
Example: SetFile -c "" -t "" /Users/venkat/backups/VMDiskFile.vmdk

Your file is now accessible by all. Of course you may choose set of permissions as per the requirement. The above command just lifts all the restrictions on the file. 

MySQL Table Synchronization

MySQL Table Synchronization
=======================

Step: 1 Download the below package and sample script for table sysnchronization.

# cd /opt
# wget  https://static.spiceworks.com/images/how_to_steps/0000/3025/mysql-table-sync-0.9.3.tar.gz
# wget https://static.spiceworks.com/images/how_to_steps/0000/3026/syncTables.sh

Step: 2 Extract above package

# tar xzvf mysql-table-sync-0.9.3.tar.gz
# cd mysql-table-sync-0.9.3

Step: 3 Install perl-mysql modules

# yum install perl-ExtUtils-MakeMaker
# yum install "perl(DBD::mysql)"

Step: 4 Compile and install mysql-table-sync

# perl Makefile.PL
# make install

Step: 4 Then open syncTables.sh read configuration on top of the script. Change the configuration