On Dec 4, 2007 6:11 AM, Indunil Jayasooriya indunil75@gmail.com wrote:
mysqldump -u root -p databasename > database.txt
You might also want to use -Qc, so that you quote the data and do complete inserts. This depends mostly on the version of mysql that you're running, which I didn't see in your initial post. Better safe than sorry.