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 »

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

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