Fix – svn: error: The subversion command line tools are no longer provided by Xcode.

Recently I got the following error on my Mac Terminal when I tried svn command.

svn: error: The subversion command line tools are no longer provided by Xcode.

 

To fix this, run following commands:

sudo rm -rf /Library/Developer/CommandLineTools
xcode-select --install

 

Wait for the software to be installed. And you are done.

Ref.:https://stackoverflow.com/questions/60869347/mac-command-line-tools-11-4-no-longer-has-svn

 

Fix – ERROR 1031 Table storage engine for ‘table_name’ doesn’t have this option

Sometimes you get the below error while importing the database.

ERROR 1031 (HY000) at line 5643 in file: '/Users/username/Downloads/database.sql': Table storage engine for 'table_name' doesn't have this option

Now let’s fix this.

Step – 1

Open your sql file in your favourite editor and go to SQL query of that table.

You will see ROW_FORMAT=FIXED at the last of the query and remove that.

Step – 2

Save your file and try to import the database. This should fix the error.

 

That’s it