Wednesday, November 23, 2011

Export mysql schema alone in command line

MysqlExport Only schema :

Go to mysql bin directory in command prompt
mysqldump --no-data --tables –u username –p dbname --routines --triggers > c:/file.sql
Press enter
Enter Password:
Enter your password
You are done with it

No comments:

Post a Comment