mysql

mysql.md

Create database dump

mysqldump -h mysqlhost --port 3306 -u reporting -p database_name | gzip > database_name_$(date '+%y-%m-%d').gz

Restore mysql dump to database

mysql -u <user> -p -h mysqlhost [database] < db_backup.dump

See size of all Database in MySQL

SELECT table_schema "Database Name",
    sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB",
    sum( data_free )/ 1024 / 1024 "Free Space in MB"
FROM information_schema.TABLES
GROUP BY table_schema ; 

Mysql Database copy from one table to another

 mysqldump -h data.base.host --password=pass -u user database1 \
| mysql -h data.base.host --password=pass -u user database2

Create user and database

create database temp_data;
grant all privileges on temp_data.* to 'temp_data_user'@'localhost' identified by "password";