Timo Goosen

Github pages blog

View My GitHub Profile

MySQL Stuff

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';