C:\>mysqldump -hlocalhost -P3307 -uroot -ppass --tables gis places > c:/x.sql
This would export table structure and data for table named places from schema named gis
you can export multiple tables by providing list of table names instead of just one in this example
------------------------------------------------------------------
C:\>mysqldump -hlocalhost -P3307 -uroot -ppass gis > c:/y.sql
This would export all tables in schema gis
------------------------------------------------------------------
C:\>mysql -hlocalhost -P3307 -uroot -ppass myschema < c:/x.sql
This would import the data into schema named myschema
------------------------------------------------------------------
Export schema objects without data
C:\>mysqldump -hlocalhost -P3307 -uroot -ppass --tables --no-data myschema > c:/myschema_script.sql
Import:
C:\>mysql -hlocalhost -P3307 -uroot -ppass myschema < c:/myschema_script.sql