mysql database schema(file OR export OR backup)

mysql database schema(file OR export OR backup)

http://www.dzone.com/snippets/export-your-mysql-database

mysqldump --no-data --tables -u YOUR_USER_NAME -p DATABASE_YOU_WANT_SCRIPTED >> FILENAME.sql

example:

view sourceprint?

1.mysqldump --no-data --tables -u larry -p contacts >> contacts.sql

/opt/lampp/bin/mysqldump --no-data --tables -u root -p GameRound >> GameRound.sql