I would like to know the best command line string to backup a MySQL database so that when -c is used, each Insert command is shown on a new line.

I am trying to restore a large database and need to break the file up into smaller files. This is easier if the file is formatted neatly.

Cal, February 2005

A good script that will do that is in PHPMyAdmin, its free and the export function will do as you asked

Mike.Sum, July 2008