mysql : command

1 - copy database to new database

 create database <new_database>

mysqldump -u<user> -p<password> <current_database> | mysql -<user> -p<password> <new_database>;

2 - show table status

SHOW TABLE STATUS from <database>