mysql dump

mysqldump is the client program for the back up of mysql database/tables.

to generate just schema of a table we can use option -d.

to limit the data in mysqldump we can use option --where="true limit 1000" which will give 1000 records.

ex. command is
mysqldump -u -p [] --where="true limit " > filenameforbackup.sql