MySQL Archives - Page 4 of 14

How to Increase Import File Size Limit in PHPMyAdmin

Sometimes you may need to increase import file size limit in PHPMyAdmin. Here are the steps to do so.

Sometimes you may need to add column after another column in MySQL. Here is how to do this.

Sometimes you may need to retrieve MySQL username and password if you have lost it. Here are the steps to do so.

Sometimes you may need to find and replace text in entire table in MySQL. Here are the steps to do so.

Sometimes yo may need to take backup of single table in MySQL. Here are the steps to do so.

Often database developers need to view the indexes on table or database in MySQL. Here are the steps to do so.

Sometimes you need to set global SQL mode in MySQL. Here are the steps to do it.

Sometimes you may need to check if column is empty or null in MySQL. Here are the steps to do so.

Sometimes you may need to replace part of string in update query in MySQL. Here are the steps to do so.

Often database administrators need to monitor live MySQL queries. Here are the steps to do so.