Scripts

describe all tables

mysql -uroot -pjwars jwars < countallmstables.sql > ms.txt
select * from information_schema.columns where table_schema = 'jwars';

restore from database dump

mysql -uroot -pjwars jwars < jwars.sql

restore a tablefrom database dump

name.sql must match the name of the table to be imported
mysql -uroot -pjwars jwars < scenario.sql