MySQL

%toc

Backup

mysqldump -u root -p --all-databases > sqlbackup.sql

Einfache Queries

CREATE

CREATE DATABASE name;
CREATE USER 'username'@'localhost' IDENTIFIED BY 'password here';
GRANT ALL PRIVILEGES ON gitorious . * TO 'username'@'localhost';
mysql -u root -p databasename < dump.sql