MySQL

Check MySQL Version

mysql -V

Database Export

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

Import Zip backup

gunzip < Backup.sql.gz | mysql -u USER -p DATABASE

Import .tar.gz gzipped

tar -xzOf your_db_dump.sql.tar.gz | mysql -u USERNAME -pPASSWORD your_database

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