Category: MySQL
How to Fix Error establishing a database connection for any WP-CLI Command For MAMP
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.
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…
Fix 413 Request Entity Too Large in MaMP in 2 Minutes
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 – 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 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…
