MySQL Stuff

• MySQL Views

Show views:

SHOW FULL TABLES IN database_name WHERE TABLE_TYPE LIKE 'VIEW';

Dump from remote server:

mysqldump -h hostname-of-the-server -u mysql_user -p database_name > file.sql

Grant syntax:

GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'localhost';

Create db backup all db’s one shot:

Dump everything locally:

mkdir ~/mysql-data-backup

mysqldump -u root -p --all-databases > ~/mysql-data-backup/all_databases_backup.sql