Basic mysql commands - just to create, modify, drop or dump mysql databases

mysql -u username -p
enter password
show databases;
use "database_name";
show tables;
CREATE TABLE cars (id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(20),
description VARCHAR(30),
confirmed CHAR(1),
signup_date DATE);

DESCRIBE cars;

drop database "database name";

mysqldump
mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql