I think what you are seeing is called the "extended insert format". It's much faster to process a single large INSERT statement than several smaller ones. There are two things to remember:
a) if you have a lot of data in your table, an extended insert statement may become too long to re-read into your server as a single chunk. You can tell mysqldump to create an extended insert statement in chunks of a certain size if you tell mysqldump just how big you want those chunks to be. Use the "--max_allowed_packet=" option to keep your extended inserts down to a certain maximum size. The largest useful packet is that which matches the max_allowed_packet variable value for the server receiving the data. Any larger than that and the restore will fail. b) you can disable the extended inserts completely if you run mysqldump with the "--skip-extended-insert" option To see all of the options supported by mysqldump, use the "--help" option like this: mysqldump --help And, one last thing, when responding to help from the list, please do not forget to CC the list. I could have been called away or unable to answer for an extended period of time and anyone else on the list could have helped in my place. Shawn Green Database Administrator Unimin Corporation - Spruce Pine Carlos J Souza <[EMAIL PROTECTED]> wrote on 08/18/2005 03:42:36 PM: > Shawn, > > it sees that in the attached archive only one register was generated > for each table of database. it is this that I am asking in the > forum. Because with Mysql 4.0.x this does not happen. This only > happens in Mysql 4.1 > > i use a follow sintax: mysqldump --host localhost --user root > [databasename] > c:\file.sql > > Regards > > Carlos J Souza > > > On Thu, 18 Aug 2005 14:10:56 -0400, [EMAIL PROTECTED] wrote: > > Carlos J Souza <[EMAIL PROTECTED]> wrote on 08/18/2005 > > 03:16:15 PM: > > > >> 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 does not occurs. > >> > >> How to solve it? > >> > >> Regards For all > >> > >> Carlos J Souza > >> > > > > I think that generating the INSERT statement (the 4.1.x behavior) > > should not be a problem. Can you try again to describe what it is > > you would like to do, how you are trying to do it, and what is not > > happening in the manner you desire? > > > > I can tell that English is not your native language. I usually do > > not make this suggestion (as this is an English mailing list) but > > there are several on the list that do speak Portuguese (and > > Spanish) so perhaps you could try describing your problem that way, > > too. > > > > Shawn Green > > Database Administrator > > Unimin Corporation - Spruce Pine > > [attachment "siexwin.sql" deleted by Shawn Green/Unimin]
