Hi, I want to backup some data from a database. In previous releases when I backuped a database to a file I got inserts each in one line, separated with semicolon. It was very comfortable, because I could very easy edit the file, change something and give it to the database. Now after the backup the file is very weakly readable. It works of course but it is not as convenient as before (in previous releases). Now INSERTS to tables looks like:
INSERT INTO table VALUES (values1), (values2), ... (valuesN); I want something like that: INSERT INTO table VALUES (values1); INSERT INTO table VALUES (values2); ... INSERT INTO table VALUES (valuesN); Of course I can write a script which will do it, but meybe there is an option to the mysqldump? I tried --complete-insert and omitted the --extended-insert option, but it doesn't work. How can I do this? Regards, Maciej Bobrowski -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
