On Dec 4, 2007 6:11 AM, Indunil Jayasooriya <indunil75 at 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. -- During times of universal deceit, telling the truth becomes a revolutionary act. George Orwell