When DBA take backup of full database table and if developer need any one table to restore at that time need to take below action to restore single table in...

Most common error in mysql database during the access.  Execute below script on mysql shell for resolve the error. Note : Modified below script as per your requirement and add...

During the access of mysql database DBA face error like 'Row Size too large 8126' in few tables which could be resolve by taken below steps : Add the following...

Couldn't execute SQL: LOAD DATA LOCAL INFILE '/tmp/fifo' REPLACE INTO TABLE FIELDS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' MySQL Bulk Loader.0 - The used command is not...

After setup the mysql database many times users got error during execution of script on database "cannot execute statement : impossible to write to binary log since BINLOG_FORMAT=STATEMENT" Two ways...

Sometimes DBA or Developer need to identify which connections are open in background so they can identify through below script. Execute below script on mysql shell. SELECT IFNULL(usr,'All Users') user,IFNULL(hst,'All...