Hello, The reference manual is great place to start for this type of information.
http://dev.mysql.com/doc/refman/5.0/en/binary-log.html --log-bin[=file_name] is the mysqld startup command. Thanks, Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX USA Phone: (713) 636-9239 -----Original Message----- From: prathima rao [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 14, 2005 6:04 AM To: mysql@lists.mysql.com Subject: how to create binary logging for a database hello, how can i create a binary log in a new database ----- Original Message ----- From: "Adam Lipscombe" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> Sent: 14/12/2005 3:50 PM Subject: Mysqldump INSERT statements (Was Mysqldump line endings) >> (--result-file) option to save your output but use the > output redirector >> to map the output of mysqldump to a file you specify, you will get >>the CRLF line endings you seek. Many thanks. One more thing: by default mysqldump uses --extended-insert=TRUE. This results in all the VALUES data being on one line. IF the table has much data this produces very long lines when viewed in a text editor. (WordPad crashes!) If --extended-insert=FALSE then multiple INSERT statements are used. IS there any way to have 1 INSERT statement with each subsequent data line on a separate line? E.g. : INSERT INTO t1 VALUES (1,2,3), (1,4,5), (1,6,7); TIA - Adam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.371 / Virus Database: 267.13.13/199 - Release Date: 13/12/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]