MySQL (MySQL Inspired Databases, Including MariaDB)

How to Optimize MySQL Queries for Speed and Performance

A great article on how to optimize MySQL queries: How to Optimize MySQL Queries for Speed and Performance ...

How to Combine Data From Multiple Rows into One Field using MySQL [GROUP_CONCAT]

SELECT post_id, GROUP_CONCAT(meta_value) as full FROM wp_postmeta WHERE (meta_key = 'isc_image_source' or meta_key = 'isc_image_source_url') GROUP BY...

MySQL: How to Find Slow Queries & Optimize Them

Let's see if you have "slow_query_log" enabled -- issue the following command: show global variables like '%slow%'; If "slow_query_log" is set to...

How to Import and Export MySQL Database(s)

Export a Database $ sudo mysqldump -u username -p dbname > dbexport.sql Export Table from a Database into a File > select * from wp_posts...

How to Rename a MySQL Database

You can't rename a database directly. It's a four-step process. mysql -u username -p -e "CREATE DATABASE new_dbname"mysqldump -u username -p old_dbname...

How to Search Your Entire MySQL Database for a Phrase

I tested the following command on an Ubuntu v18.04 virtual private server (VPS). $ sudo mysqldump -u <username> --no-create-info --extended-insert=FALSE...

12 Important MySQL Commands You Should Know

MySQL is the world's most widely used relational database management system (RDMS), maintaining greater than 40% market penetration and leveraged by a...