By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,640 Members | 2,095 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,640 IT Pros & Developers. It's quick & easy.

mysqldump: Maximum size of an insert block

P: 1
Hi

I know I can mysqldump this:

Expand|Select|Wrap|Line Numbers
  1. INSERT INTO `article` (`id`, `title`, `text`) VALUES
  2. (1, 'test', 'this is a test'),
  3. (2, 'test', 'this is a test'),
  4. (3, 'test', 'this is a test'),
  5. (2, 'test2', 'also a test');
and even this:

Expand|Select|Wrap|Line Numbers
  1. INSERT INTO `article` (`id`, `title`, `text`) VALUES (1, 'test', 'this
  2. is a test');
  3. INSERT INTO `article` (`id`, `title`, `text`) VALUES (2, 'test', 'this
  4. is a test');
  5. INSERT INTO `article` (`id`, `title`, `text`) VALUES (3, 'test', 'this
  6. is a test');
  7. INSERT INTO `article` (`id`, `title`, `text`) VALUES (4, 'test2', 'also
  8. a test');
But can I end up with this result?

Expand|Select|Wrap|Line Numbers
  1. INSERT INTO `article` (`id`, `title`, `text`) VALUES
  2. (1, 'test', 'this is a test'),
  3. (2, 'test', 'this is a test');
  4. INSERT INTO `article` (`id`, `title`, `text`) VALUES
  5. (3, 'test', 'this is a test'),
  6. (2, 'test2', 'also a test');
Jun 17 '11 #1
Share this Question
Share on Google+
1 Reply


Atli
Expert 5K+
P: 5,058
Hey.

I don't see anything in the mysqldump documentation that would allow that, nor do I get why there would be.

Why do you want them grouped like that?
Jun 17 '11 #2

Post your reply

Sign in to post your reply or Sign up for a free account.