MySQL

Check MySQL Version

mysql -V

MySQL Dump

Backup All Databases

mysqldump --all-databases > backup.sql

Backup database using User

mysqldump -u dbuser -p dbname > dbname.sql

Exclude a table from MySQL Dump

--ignore-table=dbname.tablename

Syntax: 
mysqldump -u DBuser -p DBname --ignore-table=DBname.tablename > dbname.sql

Export Single Table

mysqldump -u username -p database-name table-name > backup.sql

Export Table Structure Only

mysqldump -u DBUser -p --no-data dbname > schema.sql

Import Databases

Import a database

mysql -u DBuser -p DBname < dbdump.sql

Check the size of tables

SELECT table_name AS "Table",
ROUND(((data_length + index_length) / 1024 / 1024), 2) AS "Size (MB)"
FROM information_schema.TABLES
WHERE table_schema = "database_name"
ORDER BY (data_length + index_length) DESC;

Check MySQL Max Connections

SHOW VARIABLES LIKE "max_connections";

cPanel showing incorrect MySQL size

/scripts/update_db_cache