I want to dump my database along the table schema and the table data also using the unix command line .
I used .
mysqldump -d -u root -p frontend > frontend.sql But above command is dumping only schema not the data from the database .
Please help me out how can i dump the database along the data also.
backup: # mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql This will do,
If your requirement is to dump data alone then go for this,
To export to file (data only)
mysqldump -u [user] -p[pass] --no-create-db --no-create-info mydb > mydb.sql 
backup: #
mysqldump -u root -p[password] [database_name] > dumpfilename.sql restore:#
mysql -u root -p[password] [database_name] < dumpfilename.sql [ref:] http://www.thegeekstuff.com/2008/09/backup-and-restore-mysql-database-using-mysqldump/
You just need to remove -d from your mysqldump command
mysqldump offers plenty of options to build a proper backup from your database:
mysqldump [options] db_name [tbl_name ...] mysqldump [options] --databases db_name ... mysqldump [options] --all-databases Here you can find more detail about how to mysqldump:
You're missing --no-data=False
e.g.
mysqldump -d -u root frontend --no-data=False -p > frontend.sql
To restore database from .sql dumpfile
mysql -u [yourusername] -p [password] [nameofthedatabase] < /pathtoyoursqldumpfile.sql
Use mysqldump to create backup from database.
mysqldump -u [yourusername] -p [password] [nameofthedatabase] > /pathtoyoursqldumpfile.sql
I think the command you would need will be mysqldump. Try the following:
mysqldump -u root -p -h localhost frontend < frontend.sql 
frontend.sql directed to stdin? Does mysqldump read from stdin?
mysqldump.Do not write any table row information (that is, do not dump table contents). This is useful if you want to dump only the CREATE TABLE statement for the table (for example, to create an empty copy of the table by loading the dump file).