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
Thursday, May 6, 2010
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
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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment