User Tools

Site Tools


jas:scripts

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
jas/scripts.txt · Last modified: 2021/04/16 16:43 by 127.0.0.1