check the documentation on mysql for table by table, but offhand I'd say mysqldump tablename.database --opt -u username -p > /parth/to/file
then once it's done, since you have command line access then try this
head filename
tail filename
You can use "more" or "less" as well.