MySQL

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 – 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 »