I am using MySql and wrote all my create table scripts directly on the command line client. Now I have no tracks of them. I need all the table scripts present in my database region for future reference. I used the below command to view the script of one of my table :
show create table tablename;
It displays the script for tablename. Can Anybody guide me in collecting all the scripts present in the region, into one file?