Sometimes while running WP-CLI commands, you will get following error Error establishing a database connection So this can be fixed by very simple method. Please watch the video for how to fix that.
How to Fix Error establishing a database connection for any WP-CLI Command For MAMP Read More »
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 »
Video for who doesn’t like to read ;). And if you like the video then subscribe my channel and share this with others who has the same issue. When I was working on the local development, I had an issue as shown in this post image. When I tried to import a database from PHPMyAdmin,
Fix 413 Request Entity Too Large in MaMP in 2 Minutes Read More »
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 »
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 »
