Quick mysql primer

mysql connection test

os> mysql -u root -p
Password: <PASSWORD>
mysql>use mysql
mysql>show tables;
mysql>select * from user
mysql>exit

Backup a database

mysqldump --user=root --password=<PASSWORD> --database <DBNAME> > /backup/path/<DBNAME>.bkp

Restore a database

os> mysql -u root -p < /backup/path/<DBNAME>.bkp
Password: <PASSWORD>