List:General Discussion« Previous MessageNext Message »
From:Jeff Shapiro Date:August 21 2005 6:52pm
Subject:Re: MySQLDUMP Problem
View as plain text  
On Thursday 18 August 2005 09:34, Carlos J Souza wrote:
> Sirs,
> When i use  mysqldump on Version 4.1.x, all tables had a one record insert
> generated in script. When i use mysqldump on a 4.0.x version this problem
> dos not occurs.
> How to solve it?

That's because extended inserts are on by default in 4.1.x. To get multiple 
inserts (usually slower) use a command like:

mysqldump --skip-extended-insert mydatabase > mydatabase.sql

Jeff Shapiro
listserv only address
MySQLDUMP ProblemCarlos J Souza18 Aug
  • Re: MySQLDUMP ProblemJeff Shapiro21 Aug