I have 2 dozen tables in a mysql DB. I can see the table by using desc tableName; How i dump the desc for all tables into a file so i can look through them easily and quickly?
mysqldump with --no-data will dump the schema out for you, e.g.:
mysqldump --opt --no-data -h $host-u $username -p$password $database
Sign up using Google
Sign up using Facebook
Sign up using Stack Exchange
4 years ago