mysql -u username -h hostname -P portnum -D databasename -p
mysqldump -u testuser -p testdb > export.sql
create database newdb; mysql -u root -p newdb < export.sql
grant all on newdb.* to testuser@localhost identified by 'password';
pager less -n -i -S
show table status\G
show table status;
show processlist;
desc tablename;
select * from information_schema.TABLES where TABLE_SCHEMA = 'nomura';
