terminal

Import large DB in MySQL using command in MAMP

Sometimes using phpmyadmin, it’s kind of impossible to import DB from the import section. So below is the command to import large DB into MySQL. Step-1 Login to MySQL using following command /Applications/MAMP/Library/bin/mysql –host=localhost -uroot -proot Step-2 Select DB in which you want to import DB use DB_NAME; Step-3 Import DB SET autocommit=0 ; source

Import large DB in MySQL using command in MAMP Read More »

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 – svn: error: The subversion command line tools are no longer provided by Xcode. Read More »

Download folder/files from server using ssh terminal

You will need SCP installed on your system. Run the following command from your terminal scp -r username@host:/path/to/folder /Destination/path/of/local/machine/ If you access the server via pem key, then command will be scp -r -i /path/to/pemkey.pem username@host:/path/to/folder /Destination/path/of/local/machine/ That’s it.

Download folder/files from server using ssh terminal Read More »

Fix – ERROR 2006 (HY000) while importing database in MySQL

While importing big database in MySQL, you might get the error as shown below: ERROR 2006 (HY000) at line 3387 in file: ‘path_to_the_db_dump.sql’: MySQL server has gone away Step 1: Open a terminal and find a config file for MySQL by command locate my.cnf. You will get the list of files. Open your responsible file.

Fix – ERROR 2006 (HY000) while importing database in MySQL Read More »