Hi Nanu, According to me
You could use 1. --result-file=file, -r file 2. > file (complete path or present working directory would be the place where your file would be saved) Since you are not mentioning the output to be in any different format apart from SQL, it would be a sql file. You can name it as an extension of .sql, however while you import it back it doesnt matter whether your backed up file is on .sql extension or not. Though the idea of keeping extensions is to always help you identify the type of files. Best regards, Amit Sharma On Fri, Dec 19, 2008 at 1:11 PM, Nanu Kalmanovitz <n...@kalmanovitz.co.il>wrote: > Hi! > > I'm a newbie trying to use the backup\dump command. > > My questions are: > > 1. When using the command "mysqldump --single-transaction --quick > -uroot -p --all-databases", what is the default destination path > (server\volume\folder) and the default file name? > > 2. If using a redirection " > destination_file_name", is it possible to > add a path before the filename (server\volume\folder) and what is > regular\correct file name? > > TIA > > Nanu > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=amitsha...@affle.co.uk >
